Unit 2 Assignment 1 | Complete Solution

1.      What is the difference between a database and a table?

2.      What does it mean to say that a database displays both entity integrity and referential integrity?

3.      Why are entity integrity and referential integrity important in a database?

4.      What are the requirements that two relations must satisfy to be considered union-compatible?

5.      Which relational algebra operators can be applied to a pair of tables that are not union-compatible?

6.      Explain why the data dictionary is sometimes called “the database designer’s database.”

FIGURE Q3.14 The Crow’s Foot ERM for Question 14

SOURCE: Course Technology/Cengage Learning

14. Suppose you have the ERM shown in Figure Q3.14. How would you convert this model into an ERM that displays only 1:M relationships? (Make sure you create the revised ERM.)