Join Cris Ippolite for an in-depth discussion in this video Introduction to data modeling, part of Relational Database Design with FileMaker Pro.
- In the relational model,…data is broken down into small chunks…which are connected to each other by relationships.…By breaking data into smaller pieces,…accuracy is ensured by making data entry…a one time process,…and then reusing the data…by connecting it with other pieces.…Using this process,…a large collection of unorganized data is simplified…into its smallest units…and then related with many other small units…to recreate the big picture…in a more organized format.…The relational model provides a simple…and flexible way to describe data.…
Data modeling is the initial purpose of any database.…The data has to be modeled or described…so that it can be input and output…in a method that can be duplicated…and applied to the business rules…of the organization using the system.…You actually see data organized like this…in the real world, all around you.…For example, if you go into any office,…you'll see several file cabinets…that store different files about different things.…One file cabinet, for example,…may store information about customers,…
The course applies to versions of FileMaker Pro from 7 through the most current version.
- Reviewing relationships types
- Diagramming relationships
- Resolving many-to-many relationships
- Determining which tables need key fields
- Defining tables in FileMaker Pro
- Using the Relationship Graph
- Using multiple match fields in one relationship
- Using global fields to filter portals
- Creating self relationships
- Creating aggregate functions using relationships
Skill Level Intermediate
Q: The exercise files for this course do not work on a Mac. It downloads executable files. Can you provide a workaround?
A: The files provided for this course were made pre-FileMaker Pro 12. The system does not recognize the .fp7 files immediately as something that can be opened with FileMaker Pro 12 and instead shows them as Unix Executable Files.
The solution is quite simple. Just double-click the file, at which point the Mac will prompt you to choose an application to open the
file with. Select FileMaker Pro 12 and it will then convert the file from a .fp7 file into the new FileMaker Pro 12 file format, which is .fmp12.
Q: This course was updated on 5/12/2015. What changed?
A: We moved a video from the "Using Relationships" chapter of FileMaker Pro 13 Essential Training into this course, where it will remain evergreen.