March 2003
Beginner
672 pages
14h
English
book
Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition
by Michael J. Hernandez
Content preview from Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Review Questions
|
State two major reasons why a relationship is important. |
|
|
Name the three types of relationships. |
|
|
Which relationship will pose the most problems? |
|
|
State two problems you could possibly encounter with a many-to-many relationship. |
|
|
What is a self-referencing relationship? |
|
|
How do you begin the process of identifying the relationships among the tables in the database? |
|
|
What are the two types of questions you can ask to help you identify existing relationships? |
|
|
What shorthand symbol do you use to designate a one-to-many relationship in the table matrix? |
|
|
How do you determine what type of relationship officially exists between each pair of tables in the matrix? |
|