SQL in 24 Hours, Sams Teach Yourself, 7th Edition

Hour 6

Defining Entities and Relationships

What You’ll Learn in This Hour:

• ▶   Gain a deeper understanding of entities and relationships

• ▶   Understand how to model referential integrity

• ▶   Define parent and child relationships using primary and foreign keys

• ▶   Walk through defining entities and relationships with the BIRDS database

• ▶   Walk through the process of adding entities to the BIRDS database through hands-on exercises for modeling your own entities and relationships that will be integrated with the BIRDS database

During this hour, you learn about one of the most important phases of database design: defining entities and relationships. The entities and relationships that you define in this book are based on the groups of data ...