Problem
Textbook: Database Design 25th anniversary Edition. Chapter 10.
A. State two major reasons why a relationship is important.
B. Name the three types of relationships.
C. Which relationship will pose the most problems?
D. State two problems you could possibly encounter with a many-to-many relationship.
E. What is a self-referencing relationship?
F. How do you begin the process of identifying the relationships among the tables in the database?
G. What are the two types of questions you can ask to help you identify existing relationships?
H. What shorthand symbol do you use to designate a one-to-many relationship in the table matrix?
I. How do you determine what type of relationship officially exists between each pair of tables in the matrix?
J. How do you establish a one-to-many relationship?
K. True or False: Retrieving information from tables with a self-referencing relationship can be tedious and somewhat difficult.
L. How do you establish a self-referencing many-to-many relationship?
M. How do you refine the foreign keys in the database?
N. What two element categories must you modify for a foreign key's field specification?
O. What is the function of a deletion rule?
P. What two types of participation can you designate for a table?
Q. What does the degree of participation indicate?
R. When does a relationship attain relationship-level integrity?