Question: Please help create two functional dependency diagrams for the relational database (Human Resource). 1. Diagram five possible entities that will be required to sustain a
Please help create two functional dependency diagrams for the relational database (Human Resource).
1. Diagram five possible entities that will be required to sustain a personnel solution. Include the dependency diagrams in your diagram.
2. Diagram five possible entities that will be required to sustain a personnel solution. Include multivalued dependencies in your diagram.
Five entities are: 1-employee (attr.: e_ID, e_first name, e_last name); 2-job history (j_ID, j-start date, j_end date); 3-training history (e_ID, tc_ID, t_start date, t_end date); 4-job (j_ID, j_title, j_salary), 5-training course (tc_ID, tc_title, tc_description).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
