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 returned (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 for each rental.
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 returned (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 for each rental.
Related questions
Question
Transcribed Image Text: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 returned (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 for each rental.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
