1. A DBMS promotes and enforces integrity rules. These include minimizing redundancy and maximizing consistency. T/F

2. You have been hired by XYZ Corp to develop a data model for their human resources department. You are working on the model and determining what the relationship would be between employee and employee dependents. What would the relationship be?

Many to Many (optional)

Many to Many (mandatory)

One to Many (optional)

One to Many (mandatory)

3. Jennifer is updating the database for her company. She wants to delete customer records that have not made a purchase from more than 5 years ago but when she tries the database tells her that she can't because she must first delete the customer sales transactions records first. What is this referred to?

Database reliability

Systems integrity

Safety system constraints

Referential integrity

4. The M:N relationship specifies that there is a ______to ______ relationship between entities.

Many, One or Two

Many, Some

Many, Many

Many, Few