In the first two courses in this series, you planned and built a set of tables for an asset-tracking database. The database replaces a spreadsheet that's too big to use easily. This course teaches you how to build relationships between your new tables.
Why relationships? Because they're an essential component of your database. They bring the data in your tables together so you can extract meaningful information.
This course explains the different types of relationships you can use in a database, and shows you how to create the most common type, called a one-to-many relationship. You'll also learn how to use referential integrity to
make sure you don't accidentally remove information.
If you haven't taken the first two courses in this series, you need to be familiar with primary and foreign keys. And remember, this is a course for beginners, so if you're feeling intimidated, give it a try.
To learn more about this course, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.