Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

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

image text in transcribed
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 her title (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 mutiple 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

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_step_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students explore these related Databases questions

Question

=+50. Now deduce Theorem 3.3 from part (a).

Answered: 3 weeks ago