From the course: FileMaker: Relational Database Design
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Class enrollment example - FileMaker Pro Tutorial
From the course: FileMaker: Relational Database Design
Class enrollment example
- In this movie, we're going to use a real world use case to apply what we've learned about modeling relationships, but this time, we're going to look at one to one relationships, and also, instances; now, as a quick review, remember that ERD Modeling breaks into three phases, first, you develop a list of tables, and then you determine and diagram the relationships between those tables, and you might have to repeat step one and two, if you encounter many to many, or one to one relationships, both of which, we'll encounter in this example. So, in this example, we have the Francis Learning Center, which is an organization that offers classes to the public; the center has many teachers, who teach several different classes, and students can enroll in as many classes as they like; the center would like to be able to track enrollment for each class, as well as use the database to pay teachers for each class that they teach. Additionally, a teacher can also be a student advisor, and a…
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.