11. | Discuss the alternative terminology that is used in the relational model. |
|
12. | Why are functional dependencies not equations? |
|
13. | What is a foreign key, and what is it used for? |
|
14. | What are insertion and deletion anomalies? |
|
15. | What does it mean when we say that a relation is in Boyce-Codd Normal Form (BCNF)? |
|
16. | You have been given a set of tables with data and asked to create a new database to store them. When you examine the data values in the tables, what are you looking for? |
|
17. | Why do normalized tables require more complex SQL when SQL statements are used in application programs? |
|
18. | What is the multivalue, multicolumn problem? Include an example not used in the text. |
|
19. | Why is the multivalue, multicolumn problem another form of the multivalued dependency problem? |
|
20. | What is the inconsistent values problem? Include an example not used in the text. |
|