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.
Comments
Leave a comment