Relational Database Design with FileMaker Pro

WEBRip | English | MP4 + Project files | 1280 x 720 | AVC ~634 kbps | 29.970 fps

AAC | 160 Kbps | 48.0 KHz | 2 channels | 2h 40mn | 447.8 MB

Genre: Video Tutorial / Development, Programming

Let author Cris Ippolite show you how to translate aspects of the real world into the form and language of a relational database, using three practical data modeling examples. The course begins by reviewing some of the basic concepts of data modeling, introducing tables, key fields, and the Relationship Graph. Then, after demonstrating how to establish relationships in a database, the course concludes with a demonstration of some advanced modeling techniques, such as filtering, scripting, and the use of portals. The course applies to versions of FileMaker Pro from 7 through the most current version.

Main topics covered:

Introduction

Welcome UPDATED

Why relational databases? UPDATED

Using the exercise files UPDATED

1. Reviewing Data Modeling

Introduction to data modeling UPDATED

Reviewing relationships types UPDATED

Diagramming relationships UPDATED

2. Resolving Many-to-Many Relationship

Understanding problems caused by many-to-many relationships UPDATED

Adding a join table UPDATED

3. Introducing Key Fields

Using primary and foreign key fields UPDATED

Determining which tables need keys UPDATED

4. Using the FileMaker Relationship Graph

Defining tables UPDATED

Defining key fields UPDATED

Introducing the Relationship Graph UPDATED

5. Working with Relationships

Understanding related fields UPDATED

Understanding portals UPDATED

Using relationship options to create related fields UPDATED

Using multiple match fields in one relationship UPDATED

6. Real-World Data Modeling Examples

Donations example UPDATED

Class enrollment example UPDATED

Personnel management example UPDATED

7. Advanced Relationship Techniques

Using global fields to filter portals UPDATED

Using global fields to create a date range filter UPDATED

Using relationships in a script to navigate UPDATED

Using portals to connect to data more than one table away UPDATED

Creating self-relationships UPDATED

Adding charts with related data to layouts NEW

8. Relationships in Calculation

Creating aggregate functions using relationships UPDATED

Using the List function UPDATED

Conclusion

Next steps UPDATED