From the course: FileMaker: Relational Database Design
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Reviewing relationship types - FileMaker Pro Tutorial
From the course: FileMaker: Relational Database Design
Reviewing relationship types
- [Narrator] When we talk about relationships in database terms, we're talking specifically about how different tables are related to each other and how the relationships between those tables really define the data that's stored inside of them, so in order to decide on the data model for your database, it's important to first determine what possible kinds of connections we could have between those databases, and those are called relationships. I'd like to cover with you the three main relationship types. First, there are one-to-one relationships, which are very rare, and it usually means that you've created a table for something that should actually be a field. Then, there are one-to-many relationships, which can also be evaluated as many-to-one depending on which direction you're looking at. These are the relationships that you want to go for. You want all your relationships ultimately to become one-to-manys. The third type of relationship is referred to as a many-to-many…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.