Question: ERD Problems Given the following business rules, create the appropriate Crow's Foot ERD. (10 points) a. A company operates many departments. b. Each department

ERD Problems Given the following business rules, create the appropriate Crow's Foot ERD. (10 points) a. A company operates many departments. b. Each department employs one or more employees. C. Each of the employees may or may not have one or more dependents. d. Each employee may or may not have an employment history. 2. Write the SQL, create table for the Employee table, assign primary key and foreign key according to the ERD (10 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
