From the course: FileMaker: Relational Database Design
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Diagramming your relationships - FileMaker Pro Tutorial
From the course: FileMaker: Relational Database Design
Diagramming your relationships
- [Instructor] So far we've discussed how to identify different relationship types. And in this movie I'm going to expand on that technique and we're going to learn a general method for diagramming database systems. And it's called creating an entity relationship diagram. These are also referred to as ERDs. Now ERD modeling breaks into three phases. First, we develop a list of entities or tables that belong in the data model. Then we will determine and diagram the relationships between those entities. And then finally we review the diagram for correctness and consistency. And that's the step where we're going to eliminate things like one to one relationships, and many to many relationships. So let's start first by trying to identify what might be our entity candidate list. If we look at our example database that we'll be using throughout this course, we see that we've got a database that manages orders, where there is one order per customer. And we also have multiple products per…
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.