Using the business rules and completed ER Diagrams. complete a Transaction Analysis and a CRUD Diagram for
Question:
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
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.
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George