Accounting Information Systems 9th Edition by James Hall

Exercise 35

DATABASE DESIGN
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 homeimprovement 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 Lestor'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; (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.