ERD Problems Given the following business rules, create the appropriate Crow's Foot ERD. (10 points) a....

Transcribed Image Text:

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) 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)