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

Reviewing relationship types - FileMaker Pro Tutorial

From the course: FileMaker: Relational Database Design

Start my 1-month free trial

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…

Contents