Overview
-
Learn how to translate aspects of the real world into the form and language of a relational database.
Syllabus
-
Introduction
- Welcome
- Why relational databases?
- Using exercise files
- Introduction to data modeling
- Reviewing relationship types
- Diagramming your relationships
- Understanding problems caused by many-to-many relationships
- Adding a join table
- Primary and foreign key fields
- Defining tables in FileMaker
- Defining primary and foreign key fields
- Creating relationships in the relationship graph
- Introduction to related fields
- Introduction to portals
- Difference between relationships and queries in FileMaker
- Multiple match fields in a relationship
- Using operators in query relationships
- Using value lists to link child records
- Using relationship options to create related records
- Using scripts to create child records
- Donations example
- Class enrollment example
- Personnel management example
- Using global fields to filter portals
- Using global fields to create a user-driven portal filter
- Using relationships in a script to navigate
- Reviewing related data more than one site away
- Creating self relationships
- Creating aggregate functions using relationships
- Dashboards using relationships
- Cascading portals
- Next steps
