Chapter 4_Relational Database

Multiple Choice

Which of the following is NOT considered an advantage of a database system?

• Data independence

• Data Sharing

• Data storage in multiple locations

• Data integration

​A description of the data elements in a database, the relationships among them, and the logical model used to organize and describe the data

Multiple Choice

Which of the following is an individual user's view of the database?

• internal-level schema

• logical-level schema

• external-level schema

• conceptual-level schema

​Refer to Table 4.1

​Refer to Table 4.2

​Refer to Table 4.2 and Table 4.5

​

Multiple Choice

Which of the following describes a situation where non-primary key items are stored multiple items, leading to data inconsistencies?

• update anomaly

• insert anomaly

• delete anomaly

​Recall your AIS160 - creating a database

Multiple Choice

Databases were developed to address the proliferation of master files, which had to be created each time the need for information arose.

• True

• False

Multiple Choice

Databases used for transaction processing are eventually replaced by data warehouses.

• True

• False