From the course: FileMaker Pro 12 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Diagramming relationships with entity-relationship ER diagrams

Diagramming relationships with entity-relationship ER diagrams - FileMaker Pro Tutorial

From the course: FileMaker Pro 12 Essential Training

Start my 1-month free trial

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 are going to need in our database. Then we understand that since we can potentially have multiple tables in one database, we need to evaluate what kind of relationships those tables are going to have with each other. Understanding now that there are three different relationship types, say one-to-one, a one-to-many and many-to-many, it's time to now create a diagram of all the tables that we are going to have and then how they're related to each other. This will help us set up the relationships inside the FileMaker Database when we are ready to start creating the database. In this movie I am going to expand on these techniques, and we are going to learn a general method for diagramming database systems, and it's called the creating an Entity Relationship Diagram, commonly referred to as an ERD. ERD modeling breaks into three phases, first, we develop a list of entities or tables that…

Contents