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 - FileMaker Pro Tutorial
From the course: FileMaker Pro 12 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 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…
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.
Contents
-
-
-
-
-
-
Understanding relationship types4m 9s
-
Diagramming relationships with entity-relationship ER diagrams7m 7s
-
Understanding key fields4m 19s
-
Determining which key fields you need3m 11s
-
Defining primary and foreign keys4m 54s
-
Creating relationships using the relationships graph and table occurrences5m 35s
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-