Video rental database | Computer Science homework help

a. Write the proper sequence of activities in the design of a video rental database. The initial ERD is shown in textbook Figure 9.9. The design must support all rental activities, customer payment tracking, and employee work schedules, as well as track which employees checked out the videos to the customers.
b. After you finish writing the design activity sequence, complete the ERD to ensure that the database designcan be successfully implemented. (Make sure that the design is normalized properly and that it can support the required transactions.