Part 1

Use the following business rules to create a Crows Foot ERD. Write all appropriate connectivities and cardinalities in the ERD.

A department employs many employees, but each employee is employed by one department.

An employee may be assigned many projects, and a project may have many employees assigned to it.

A project must have at least one employee assigned to it.

A project must have an employee who is the project leader. A project can only have one leader.

An employee has a first name and last name.

A department has a name.

A project has a name.

Part 2

Use the following business rules to create a Crows Foot ERD. Write all appropriate connectivities and cardinalities in the ERD.

A user writes many reviews, but each review is written by one user.

A user is not required to write a review.

A review is about only one movie.

A movie may have zero or more reviews.

A movie has a genre. Many movies may have the same genre.

A user has a first name and last name.

A review has a date and time, and it is related to a movie.

A movie has a title, year, and a genre.

A genre has a name.