Lester’s Rentals is located in Cincinnati, Ohio. The company rents party equipment such as tents, tables, chairs, linens, and china for small occasions and large weddings. They also rent a variety of home-improvement tools and contractor equipment including generators, grinders, power hammers, and drills. The company serves approximately 5,000 repeat customers and has more than 1,200 different inventory items for rent in stock. Lester’s purchases replacement stock from 45 different vendors. Each vendor supplies different items, but Lester’s may purchase the same item from different vendors. Other business rules include: (1) each inventory type has multiple quantities on hand (2) customers use their telephone numbers to uniquely identify themselves for rentals; and (3) customers may rent more than one item of the same type.
Required:
Create a normalized data model for Lester’s Rentals. Include the primary keys, data attributes, and foreign keys.