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 |