## 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