An employment agency needs to convert its basic one-table
management system into a modern information management
system/database that can hold its improving business. You are hired
to create this IMS and the first step you are carrying out is
normalization. The table that the agency originally uses is the
following:
APPLICATION(ApplicantName, AppicantPhone1, ApplicantPhone2,
ApplicantAddress, ApplicantFieldOfInterest,
ApplicanHighestLevelOfEducation, EmployerBusinessName,
EmployerAddress, EmployerPhoneNumber, EmployerCity, EmployerEmail,
JobPostingID, JobPostingTitle, JobYearlySalary, InterviewId,
InterviewDate, NamesOfInterviewers, OfferDetailsIfApplicable)
Rules:
- Applicants can be identified by their phone number(s)
- No...