Questions from Database Management

Q: What are the benefits of the use of an enterprise key?

What are the benefits of the use of an enterprise key?

Q: Contrast the following terms: a. normal form; normalization

Contrast the following terms: a. normal form; normalization b. candidate key; primary key c. partial dependency; transitive dependency d. composite key; recursive foreign key e. determinant; candidate...

Q: Consider Figure 1-15. a. What is the

Consider Figure 1-15. a. What is the purpose of introducing an attribute called Product ID to the Product table? What is its data type? b. If the company wants to keep track of the total outstanding b...

Q: Describe the primary differences between the conceptual and logical data models.

Describe the primary differences between the conceptual and logical data models.

Q: List the three components of a relational data model.

List the three components of a relational data model.

Q: What is a schema? Discuss two common methods of expressing a

What is a schema? Discuss two common methods of expressing a schema.

Q: Describe three types of anomalies that can arise in a table and

Describe three types of anomalies that can arise in a table and the negative consequences of each.

Q: Demonstrate each of the anomaly types with an example.

Demonstrate each of the anomaly types with an example.

Q: Define each of the following terms: a. data definition

Define each of the following terms: a. data definition language b. data manipulation language c. referential integrity constraint d. relational DBMS (RDBMS) e. schema

Q: What are the primary data integrity constraints in SQL?

What are the primary data integrity constraints in SQL?