Using the Lucidchart online tool, create a Crows Foot ERD for each of the following descriptions. (Note that the word "many" is meant to mean "more than one" in a database modelling environment.)

a) Each of the MegaCo Corporations divisions is composed of many departments. Each of the departments has many employees assigned to it, but each employee works for only one department. Each department is managed by one employee, and each of these managers can manage only one department at a time.

Solution: Copy the ERD diagram of section a here:

b) During some period of time, a customer can rent many videotapes from the BigVid store. Each of the BigVids videotapes can be rented to many customers during that period of time.

Solution: Copy the ERD diagram of section b here:

c) An airline can be assigned to fly many flights, but each flight is flown by only one airline.

Solution: Copy the ERD diagram of section c here:

d) The KwikTite Corporation operates many factories. Each factory is located in a region. Each region can be "home" to many of KwikTites factories. Each factory employs many employees, but each of these employees is employed by only one factory.

Solution: Copy the ERD diagram of section d here:

e) An employee may have earned many degrees, and each degree may have been earned by many employees.

Solution: Copy the ERD diagram of section e here: