using lucidichart

66 Part 1 Database Concepts 16. Create a Crow's Foot ERD for each of the following descriptions. (Note that the word many merely means more than one in the database modeling environment.) Each of the MegaCo Corporation's divisions is composed of many departments. Each department has many employees assigned to it, but each employee works for only one department. Each department is managed by one employee, and each of those managers can manage only one department at a time. b. During some period of time, a customer can download many ebooks from BooksOnline. Each of the ebooks can be downloaded by many customers during that period of time. An airliner can be assigned to fly many flights, but each flight is flown by only one airliner. d. The KwikTite Corporation operates many factories. Each factory is located in a region, and each region can be "home" to many of Kwik Tite's factories. Each fac- tory has many employees, but cach employee is employed by only one factory c. An employee may have earned many degrees, and each degree may have been earned by many employees. 17. Write the business rules that are reflected in the ERD shown in Figure P2.17. FIGURE P2.17 THE CROW'S FOOT ERD FOR PROBLEM 17 THEATER MOVIE shows redes REVIEWER REVIEW writes