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. ...

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.