Question 1

The primary key of the Customer file is the Customer ID field and the primary key of the Order file is the Order ID field.Therefore,the _____ field would be used to create a logical relationship between the Customer and Order files.

Accepted Answer

The answer of The primary key of the Customer file...

Question 2

A database management system helps you specify the _____ organization of data within a database.

Accepted Answer

The answer of A database management system helps you specify...

Question 3

A(n)_____ represents how data is physically stored on a storage device.

Accepted Answer

The answer of A(n)_____ represents how data is physically stored...

Question 4

Views are located within the _____ subsystem of the DBMS.

Accepted Answer

The answer of Views are located within the _____ subsystem...

Question 5

A(n)_____ subsystem permits the user to develop transaction-intensive applications.

Accepted Answer

The answer of A(n)_____ subsystem permits the user to develop...

Question 6

A database consists of _____ and a(n)_____.

Accepted Answer

The answer of A database consists of _____ and a(n)_____....

Question 7

Report generators are contained within the _____ of the DBMS.

Accepted Answer

The answer of Report generators are contained within the _____...

Question 8

_____ is a standardized fourth-generation query language found in most DBMSs.

Accepted Answer

The answer of _____ is a standardized fourth-generation query language...

Question 9

Query-by-example tools rely heavily upon the _____ within a database to find information.

Accepted Answer

The answer of Query-by-example tools rely heavily upon the _____...

Question 10

_____ allows you to query by pointing,clicking,and dragging and then specifying a selection criteria.

Accepted Answer

The answer of _____ allows you to query by pointing,clicking,and...

Question 11

A(n)_____ represents how users see information to meet their particular business needs.

Accepted Answer

The answer of A(n)_____ represents how users see information to...

Question 12

A(n)_____ is a primary key from one table placed within a second table to establish a relationship between the two tables.

Accepted Answer

The answer of A(n)_____ is a primary key from one...

Question 13

According to your textbook,a(n)_____ permits you to see the contents of a database file,change the contents,and sort the file.

Accepted Answer

The answer of According to your textbook,a(n)_____ permits you to...

Question 14

_____ ensure the validity of database updates when multiple users attempt to access and change the same information.

Accepted Answer

The answer of _____ ensure the validity of database updates...

Question 15

A(n)_____ contains facilities to help you develop transaction-intensive applications.

Accepted Answer

The answer of A(n)_____ contains facilities to help you develop...

Question 16

A(n)_____ uniquely identifies each record.

Accepted Answer

The answer of A(n)_____ uniquely identifies each record....

Question 17

Microsoft Access is an example of a(n)_____.

Accepted Answer

The answer of Microsoft Access is an example of a(n)_____....

Question 18

If a salesperson attempts to order merchandise for a customer not in the customer database,the database will typically generate an error message.This message indicates that a(n)_____ has been violated.

Accepted Answer

The answer of If a salesperson attempts to order merchandise...

Question 19

A(n)_____ subsystem is used to create and maintain the data dictionary.

Accepted Answer

The answer of A(n)_____ subsystem is used to create and...

Question 20

_____ and _____ both extract data meeting specific criteria from a database,but have different user interfaces.

Accepted Answer

The answer of _____ and _____ both extract data meeting...

Quiz 3: Databases and Data Warehouses: Building Business