RentQualityComputers is a computer company that specializes in renting computers, printers, scanners, network equipment, game consoles, and games. They rent to businesses, nonprofit organizations and individuals. They want to keep better track of its customers and inventory. A unique customers number is assigned by the store to each of the customers. The store also need to know last and first names, e-mail address, phone number, mailing address (including city, state and zip code) and customer type for each customer. Each non-profit organization and business customer has a contact person and for each individual customer the store wants to know his or her title(Mr./Mrs./Ms./Dr.). The store has 500 laptops, 200 tablets, 50 printers, 30 scanners, 20 routers, 40 switches, 500 game consoles and 1600 games in the inventory, each individually identified. The store maintains 200 game titles, so in average there are eight copies of each game in the inventory. For each indivdual item the store needs to know its ID, manufacturer, brand name, serial number, type, purchase date, description, daily, weekly and monthly rental fees. For all the computers the company wants to store the amount of RAM, hard drive/SSD space and processor type; for the printers the total number of copies printed, for scanners the type of connectivity; for network equipment the number and type of ports; and for games the age rating for each title and for each copy of the game its medium (DVD, Blue-Ray or proprietary). For each rental the store needs to know what items were included, when they were rented, and when are they due to be returned (each item may have a different due date). Each customer can have many outstanding rentals at the same time. The acceptable forms of payment are: cash, credit card and Paypal which must be retained about each rental.   Develop an EERD diagram that will satisfy the following requirements: Include entities, attributes, identifiers, and cardinality rules: optional and mandatory when applied Break down many-to-many relationships using associative entities with minimum of two attributes In this model, include all primary keys, and foreign keys. If there is no obvious primary key given in the text you may create one.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

RentQualityComputers is a computer company that specializes in renting computers, printers, scanners, network equipment, game consoles, and games. They rent to businesses, nonprofit organizations and individuals. They want to keep better track of its customers and inventory. A unique customers number is assigned by the store to each of the customers. The store also need to know last and first names, e-mail address, phone number, mailing address (including city, state and zip code) and customer type for each customer. Each non-profit organization and business customer has a contact person and for each individual customer the store wants to know his or her title(Mr./Mrs./Ms./Dr.).

The store has 500 laptops, 200 tablets, 50 printers, 30 scanners, 20 routers, 40 switches, 500 game consoles and 1600 games in the inventory, each individually identified. The store maintains 200 game titles, so in average there are eight copies of each game in the inventory. For each indivdual item the store needs to know its ID, manufacturer, brand name, serial number, type, purchase date, description, daily, weekly and monthly rental fees. For all the computers the company wants to store the amount of RAM, hard drive/SSD space and processor type; for the printers the total number of copies printed, for scanners the type of connectivity; for network equipment the number and type of ports; and for games the age rating for each title and for each copy of the game its medium (DVD, Blue-Ray or proprietary). For each rental the store needs to know what items were included, when they were rented, and when are they due to be returned (each item may have a different due date). Each customer can have many outstanding rentals at the same time. The acceptable forms of payment are: cash, credit card and Paypal which must be retained about each rental.

 

Develop an EERD diagram that will satisfy the following requirements:

  • Include entities, attributes, identifiers, and cardinality rules: optional and mandatory when applied
  • Break down many-to-many relationships using associative entities with minimum of two attributes
  • In this model, include all primary keys, and foreign keys. If there is no obvious primary key given in the text you may create one.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Probability Problems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education