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 |