From the course: FileMaker: Relational Database Design
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Personnel management example - FileMaker Pro Tutorial
From the course: FileMaker: Relational Database Design
Personnel management example
- [Narrator] In this movie, we're going to use another 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 the concept of a self-join table using an instance. But first, let's remember that ERD modeling breaks down into three phases. Developing the List of Tables. Determining and diagramming the relationships between those tables. And if we encounter any many-to-many or one-to-one relationships, we'll repeat those first two steps. In this example, we have the Radley and Friends Corporation HR department and they need a database to manage all of their employees. They need to be able to manage the benefits each employee receives. In addition, they way to use this same database to track employees that are managers and which employees they manage. And they also want to be able to see any given employee's manager. So now remember, when we're looking for entities in process descriptions, we're…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.