Chapter1

Question 1

Numeric, textual, visual, or audio information that describes real world systems

Answer 1

DATA

Question 2

Encoded as continuous variations on physical media

Answer 2

ANALOG DATA

Question 3

Encoded as zeros and ones on electronic or magnetic media

Answer 3

DIGITAL DATA

Question 4

Collection of data in a structured format

Answer 4

DATABASE

Question 5

Software that reads and writes data in a database. Ensures data is secure, internally consistent and available at all times.

Answer 5

DATABASE SYSTEM
OR
DATABASE MANAGEMENT
SYSTEM (DBMS)

Question 6

A request to retrieve or change data in a database.

Answer 6

QUERY

Question 7

Specialized programming language designed specifically for database systems.

Answer 7

QUERY LANGUAGE

Question 8

Software that helps business users interact with database systems.

Answer 8

DATABASE APPLICATION

Question 9

Responsible for securing the database system against unauthorized users. Enforces procedures for user access and database system availability.

Answer 9

DATABASE ADMINISTRATOR

Question 10

Determines the format of each data element and the overall database structure. Must balance several priorities including storage, response time, and support for rules that govern the data

Answer 10

DATABSE DESIGNER

Question 11

Develops computer programs that utilize a database.

Answer 11

DATABASE PROGRAMMER

Question 12

Consumer of data in database. Request, update, or use stored data to generate reports or information

Answer 12

DATABASE USER

Question 13

A group of queries that must be either completed or rejected as a whole

Answer 13

TRANSACTION

Question 14

Describes the internal components and the relationships between components.

Answer 14

ARCHITECTURE

Question 15

Interprets queries, creates a plan to modify the database or retrieve data and returns query results to the application

Answer 15

QUERY PROCESSOR

Question 16

Performed by query processor to ensure the most efficient instructions are executed on the data

Answer 16

QUERY OPTIMIZATION

Question 17

Translates the query processor instructions into low level file-system commands that modify or retrieve data

Answer 17

STORAGE MANAGER

Question 18

Used by storage manager to quickly locate data

Answer 18

INDEXES

Question 19

Ensures transactions are properly executed

Answer 19

TRANSACTION MANAGER

Question 20

A file containing a complete record of all inserts, updates, and deletes processed by the database.

Answer 20

LOG

Question 21

Directory of tables, columns, indexes, and other database objects.

Answer 21

CATALOG / DATA DICITIONARY

Question 22

Stores data in tables, columns, and rows, similar to a spreadsheet.

Answer 22

RELATIONAL DATABASE

Question 23

Includes statements that read and write data, create and delete tables, and administer the database system

Answer 23

SQL
STRUCTURED QUERY LANGUAGE

Question 24

Massive volumes of online data, often with poorly structured or missing information

Answer 24

BIG DATA

Question 25

Non-relational systems that are optimized for big data.

Answer 25

NoSQL NOT ONLY SQL

Question 26

Software that anyone can inspect, copy, and modify with no licensing fee.

Answer 26

OPEN SOURCE

Question 27

A command for a database that typically inserts new data, retrieves data, updates data, or deletes data from a database.

Answer 27

QUERY

Question 28

Computer programming language for writing database queries.

Answer 28

QUERY LANGUAGE

Question 29

Four common queries

Answer 29

C - CREATE R - READ U - UPDATE D - DELETE

Question 30

Standard language of relational database systems.

Answer 30

SQL STRUCTURED QUERY LANGUAGE

Question 31

A complete, executable database command.

Answer 31

SQL STATEMENT

Question 32

Creates table by specifying the table and column names

Answer 32

CREATE TABLE STATEMENT

Question 33

Indicates the format of column values; can be numeric, textual, or complex.

Answer 33

DATA TYPE

Question 34

Specification of DB objects such as tables, columns, data types, and indexes. Also refers to the process used to devleop the specification

Answer 34

DATABASE DESIGN

Question 35

Specifies the database requirements without regard to a specific database system.

Answer 35

CONCEPTUAL DESIGN

Question 36

ER diagrams depict

Answer 36

ENTITIES, RELATIONSHIPS, & ATTRIBUTES

Question 37

Implements the database requirements in a specific database system.

Answer 37

LOGICAL DESIGN

Question 38

A column that is used to identify individual rows of a table.

Answer 38

KEY

Question 39

A diagram that depicts the logical design.

Answer 39

TABLE DIAGRAM

Question 40

The logical design, as specified in SQL, and depicted in a table diagram.

Answer 40

DATABASE SCHEMA

Question 41

Adds indexes, and specifies how tables are organized on storage media

Answer 41

PHYSICAL DESIGN PHASE

Question 42

Principle that the physical design never affects query results is called

Answer 42

DATA INDEPENDENCE

Question 43

A library of procedures or classes that links a host programming language to a database.

Answer 43

API APPLICATION PROGRAMMING INTERFACE

Question 44

A relational database system sponsored by Oracle

Answer 44

MySQL

Question 45

A conceptual framework for database systems.

Answer 45

DATABASE MODEL

Question 46

Three parts of database systems.

Answer 46

DATA STRUCTURES - that prescribe how data is oraganized. OPERATIONS - that manipulate data structures. RULES - that govern valid data.

Question 47

An unordered collection of elements enclosed in braces.

Answer 47

SET

Question 48

An ordered collection of elements enclosed in parentheses.

Answer 48

TUPLE

Question 49

A _________ haS a name, a fixed tuple of columns, and a varying set of rows

Answer 49

TABLE

Question 50

Has a name and a data type.

Answer 50

COLUMN

Question 51

An unnamed tuple of values, with each value corresponding to a column and belonging to the column's data type.

Answer 51

ROW

Question 52

A named set of values, fromn which column values are drawn

Answer 52

DATA TYPE

Question 53

Operations that are the theoretical foundation of the SQL language.

Answer 53

RELATIONAL ALGEBRA

Question 54

Part of the relational model and govern data in every relational database.

Answer 54

RELATIONAL RULES

Question 55

Based on business policy and specific to a particular database.

Answer 55

BUISNESS RULES

Question 56

Relational rules are implemented as ___ _________ and enforced by the databse system.

Answer 56

CONSTRAINTS.