Answer to Question #331158 in Databases | SQL | Oracle | MS Access for Elijah Jones

Question

Case 2: JOB APPLICATION

DBD Sports has decided to allow applicants to apply for jobs online. Using the following business rules, create an ERD:

1. When a person applies for a job, the following information is required:

a. Full Name b. Address c. Phone

d. Email

2. An open position is assigned to a job category.

3. A person may apply for more than 1 job, but can apply for each job only once.

4. Each job applicant is assigned to an HR representative who processes the application and helps the applicant with any

questions.

5. Once an HR representative has been assigned to a job applicant, the same HR representative will be assigned to the

job applicant each time he/she applies for a job.

6. Job applications older than 1 year will be deleted.

7. Applications for an open job will be accepted until the position is filled.

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order