Using the business rules and completed ER Diagrams. complete a Transaction Analysis and a CRUD Diagram for the case. If additional assumptions are made for your case to complete any aspect of this assignment, be sure to document the additional business rules and update the ER Diagram, if needed.

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

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

Full Name

Address

Phone

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.

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