Question: Draw an EER diagram for the following problem using the diagram notation explained in the lecture notes (similar to Microsoft Visio 2016 notation) RentQuality Computers

 Draw an EER diagram for the following problem using the diagram

Draw an EER diagram for the following problem using the diagram notation explained in the lecture notes (similar to Microsoft Visio 2016 notation) RentQuality Computers (RQC) is a computer store that specializes in renting computers, printers, scanners, network equipment, game consoles, and games. RQC rents to businesses, nonprofit organizations, and individuals. RQC wants to keep better track of its customers and inventory. A unique customer number is assigned by the store to each of its customers. The store also needs to know the last and first names, e-mail address, phone number, mailing address (including city, state, and zip), and customer type for each customer. Each nonprofit organization and business customer has a contact person, and for each individual customer, RQC wants to know his or hertitle (Mr./Mrs./Ms./Dr.). The store has about 500 laptops, 200 tablets, 50 printers, 30 scanners, 20 routers, 40 switches, 500 game consoles, and 1,600 games in its inventory, each individually identified. RQC maintains about 200 different game titles and thus, on average, there are eight copies of each game in the inventory. For each individual item, the store needs to know its ID, manufacturer, brand name, serial number, type. purchase date, a brief description, and daily, weekly, and monthly rental fees. For all computers, the company wants to store the amount of RAM, hard drive/SSD space, and processor type: for printers, the total number of copies printed; for scanners, the type of connectivity: for network equipment, the number and types of ports; and for games, the age rating for each title and for each copy of a game, its medium (DVD, Blu-Ray proprietary, etc.). For each rental, the store needs to know what items were included, when they were rented, and when they are due to be retumed (each item may have a different due date). Each customer can have multiple outstanding rentals at the same time. The acceptable forms of payment are cash, credit card, and PayPal, which must be retained about each rental

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!