From the course: FileMaker Pro 13 Essential Training
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Diagramming relationships with entity-relationship (ER) diagrams - FileMaker Pro Tutorial
From the course: FileMaker Pro 13 Essential Training
Diagramming relationships with entity-relationship (ER) diagrams
So far in the process of creating a database, we've learned that we have to determine what tables we're going to need inside the database. Then, once we determine what tables we need, we need to understand that since we can potentially have multiple tables in one database. We need to evaluate the kinds of relationships that those tables are going to have with each other. Understanding now that there are three different types of relationships, one to one, one to many, and many to many. It's time now to create a diagram of all the tables that we're going to have and then how they're going to be related to each other. This will help us set up the relationships inside the FileMaker database when we're ready to start creating the database. In this movie, I'm going to expand on the techniques that we've talked about already. And we're going to learn a general method for diagramming database systems and it's called Creating an Entity Relationship Diagram. Entities are the different groups of…
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.