Chapter 11. Business Rules

   

---

Review Questions

1:	State two major reasons why a relationship is important.
2:	Name the three types of relationships.
3:	Which relationship will pose the most problems?
4:	State two problems you could possibly encounter with a many-to-many relationship.
5:	What is a self-referencing relationship ?
6:	How do you begin the process of identifying the relationships among the tables in the database?
7:	What are the two types of questions you can ask to help you identify existing relationships?
8:	What shorthand symbol do you use to designate a one-to-many relationship in the table matrix ?
9:	How do you determine what type of relationship officially exists between each pair of tables in the matrix?
10:	How do you establish a one-to-many relationship?
11:	True or False: Retrieving information from tables with a self-referencing relationship can be tedious and somewhat difficult.
12:	How do you establish a self-referencing many-to-many relationship?
13:	How do you refine the foreign keys in the database?
14:	What two element categories must you modify for a foreign key's field specification?
15:	What is the function of a deletion rule ?
16:	What two types of participation can you designate for a table?
17:	What does the degree of participation indicate ?
18:	When does a relationship attain relationship-level integrity ?

---

Top