Company
| CompanyID | Name |
| 1 | Acme Corporation |
| 2 | XYZ Industries |
Location
| LocationID | Address | City | State | ZipCode |
| 1 | 123 University Ave | San Francisco | CA | 94102 |
| 2 | 456 University Blvd | Los Angeles | CA | 90001 |
TypeOfJobPosting
| TypeID | TypeName |
| 1 | Librarian |
| 2 | Archivist |
InformationManagementJobs
| InfoMgmtJobID | CompanyID | LocationID | TypeID |
| (→ Company.CompanyID) | (→ Location.LocationID) | (→ TypeOfJobPosting.TypeID) |
| 1 | 1 | 1 | 1 |
| 2 | 1 | 2 | 1 |
| 3 | 2 | 1 | 2 |
| 4 | 2 | 2 | 2 |
Employee
| EmployeeID | FirstName | LastName | EmailAddress | PhoneNumber |
| 1 | John | Doe | johndoe@example.com | 555-1234 |
| 2 | Jane | Smith | janesmith@example.com | 555-5678 |
AppliedJobs
| ApplicantID | InfoMgmtJobID | EmployeeID |
| (→ InformationManagementJobs.InfoMgmtJobID) | (→ Employee.EmployeeID) |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 1 |
| 4 | 4 | 2 |