Company

CompanyIDName
1Acme Corporation
2XYZ Industries

Location

LocationIDAddressCityStateZipCode
1123 University AveSan FranciscoCA94102
2456 University BlvdLos AngelesCA90001

TypeOfJobPosting

TypeIDTypeName
1Librarian
2Archivist

InformationManagementJobs

InfoMgmtJobIDCompanyIDLocationIDTypeID
(→ Company.CompanyID)(→ Location.LocationID)(→ TypeOfJobPosting.TypeID)
1111
2121
3212
4222

Employee

EmployeeIDFirstNameLastNameEmailAddressPhoneNumber
1JohnDoejohndoe@example.com555-1234
2JaneSmithjanesmith@example.com555-5678

AppliedJobs

ApplicantIDInfoMgmtJobIDEmployeeID
(→ InformationManagementJobs.InfoMgmtJobID)(→ Employee.EmployeeID)
111
222
331
442