The store hired you to design a database management system to assist in keeping track of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The store hired you to design a database management system to assist in keeping track of its customers and rental inventory. Draw your EER diagram based on the following narrative about a computer store. Be sure to indicate: • the various attributes of each entity and the relationships (including supertype and subtype relationships if any); • specify the values for subtype discriminators (if any); • underline the identifier of each entity; specify the cardinalities and cardinality constraints for each relationship; and breakdown a many-to-many relationship (if any) into two one-to-many relationships The store rents to its customers who are businesses and individuals (these are the only types of customers that the store has). A unique customer number is assigned by the store to each of its customers. The store also wants to know the customer's first and last name, email address, phone number, mailing address (including city, state, and zip), and the customer type (i.e. business or individual). For each business customer, the store wants to keep the data about the contact person, while each of individual customer the store wants to know his or her title (e.g. Mr., Mrs., etc.) Each customer can have multiple outstanding rentals at the same time or not at all. However, each rental can only be associated with one customer. Each rental is identified by a rental ID, and it also has rental date and rental time. Each rental may contain a single or multiple items from the store's inventory, however, each item in the inventory may or may not be included in any rentals. Each item is identified using item ID. Each item also has data related to purchase date, manufacturer, brand, description, the type of items, and daily, weekly, and monthly rental fees. The type of items that the store rents to its customers are computers, printers, scanners, network equipment, and games. These are the only items available for rent. For all computers, the store wants to keep the data about the amount of RAM, hard disk space, and processor type. For all printers, the store wants to keep the data about the total number of copies printed. For all scanners, the data is the type of connectivity. For all network equipment, the data are the number of ports and the type of ports. For all games, the data is the age rating. Each game may have multiple copies or no copy at all. And for each game copy, the store keeps data about the copy ID and its medium (e.g. DVD, Blu-ray etc.) Each rental must be associated with at least one type of payment and can be multiple types of payments. Each payment has a payment ID, amount and type (e.g. cash, credit card, and PayPal). More information is needed regarding the relationship between rental and the item(s) included in the rental. Specifically, it is important for the store to record when each item is due to be returned, and when it's actually returned by the customer (each item may have a different due date and a different returned date). The store hired you to design a database management system to assist in keeping track of its customers and rental inventory. Draw your EER diagram based on the following narrative about a computer store. Be sure to indicate: • the various attributes of each entity and the relationships (including supertype and subtype relationships if any); • specify the values for subtype discriminators (if any); • underline the identifier of each entity; specify the cardinalities and cardinality constraints for each relationship; and breakdown a many-to-many relationship (if any) into two one-to-many relationships The store rents to its customers who are businesses and individuals (these are the only types of customers that the store has). A unique customer number is assigned by the store to each of its customers. The store also wants to know the customer's first and last name, email address, phone number, mailing address (including city, state, and zip), and the customer type (i.e. business or individual). For each business customer, the store wants to keep the data about the contact person, while each of individual customer the store wants to know his or her title (e.g. Mr., Mrs., etc.) Each customer can have multiple outstanding rentals at the same time or not at all. However, each rental can only be associated with one customer. Each rental is identified by a rental ID, and it also has rental date and rental time. Each rental may contain a single or multiple items from the store's inventory, however, each item in the inventory may or may not be included in any rentals. Each item is identified using item ID. Each item also has data related to purchase date, manufacturer, brand, description, the type of items, and daily, weekly, and monthly rental fees. The type of items that the store rents to its customers are computers, printers, scanners, network equipment, and games. These are the only items available for rent. For all computers, the store wants to keep the data about the amount of RAM, hard disk space, and processor type. For all printers, the store wants to keep the data about the total number of copies printed. For all scanners, the data is the type of connectivity. For all network equipment, the data are the number of ports and the type of ports. For all games, the data is the age rating. Each game may have multiple copies or no copy at all. And for each game copy, the store keeps data about the copy ID and its medium (e.g. DVD, Blu-ray etc.) Each rental must be associated with at least one type of payment and can be multiple types of payments. Each payment has a payment ID, amount and type (e.g. cash, credit card, and PayPal). More information is needed regarding the relationship between rental and the item(s) included in the rental. Specifically, it is important for the store to record when each item is due to be returned, and when it's actually returned by the customer (each item may have a different due date and a different returned date).
Expert Answer:
Answer rating: 100% (QA)
Based on the provided narrative about the computer store here is the EntityRelationship EER diagram ... View the full answer
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these general management questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
For this milestone, you will frame the entity relationship model (ERM) and define the entities and attributes for the business. Your next steps will be to normalize your entities, define primary and...
-
Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: Wally Los Gatos...
-
Q4. a- In a uniform electric field, what factors does the electrical potential energy depend on? b- What is the difference between APE electric and PE electric?
-
What is the formula for calculating return on investment (ROI)?
-
A spaceship flies past an experimenter who measures its length to be one-half the length he had measured when the spaceship was at rest. An astronaut aboard the spaceship notes that his clock ticks...
-
Cumene process with drag (purge) streams. In Example 8.7, a process for producing cumene by the alkylation of benzene with propylene is described. The flowsheet for the process is given in Figure...
-
Thornton Inc. had the following operating balances for 2011: Additional information for Thornton is as follows: (a) All purchases of inventory were on account. (b) Depreciation Expense of $96,000 was...
-
Activity-based costing (ABC) is not just a cost collection mechanism, but rather more of an inventory valuation method. The main purpose for implementing an activity-based cost system is to try to...
-
John Fuji (birthdate June 6, 1981) moved from California to Washington in December 2018. His earnings and income tax withholding for 2019 for his job as a manager at a Washington apple-processing...
-
A forward rate agreement (FRA) exchanges a fixed 4.5% interest (quarterly compounded) for 3 months starting in 0.5 years on a principal of $200 million with a floating rate tied to the rates observed...
-
Chemistry is taught at five high schools in the Santa Rosa Unified School District. The district has just received a grant of 100 microscopes which are to be apportioned to the five high schools...
-
In Problems 15-18, use Hamilton's plan to apportion the new seats to the existing states. Then increase the number of seats by one and decide whether the Ala bama paradox occurs. Assume that the...
-
Use Adams' plan in Problems 8-10. Show that it violates the quota rule. State: A 160 Population: Number of seats: 100 B 347 C 685 D 95
-
In Problems 19-22, apportion the indicated number of representatives to three states, A, B, and C, using Hamilton's plan. Next, use the revised populations to reapportion the representatives. Decide...
-
Consider a vote for four candidates with the following results: Use this information for Problems 9-11. If there is a tie, break the tie by having a runoff of the tied candidates. Who wins by the...
-
Retained earnings at the beginning of the year is zero. Supplies = 1810 Service revenue = 32000 Unearned revenue = 2500 Prepaid expense = 4040 Rent expense = 13450 Intangibles = 13000 Wages payable =...
-
d. The characteristic equation of a control system is given by s+2s+8s+12s+20s+16+16=0. Determine the number of the roots of the equation which lie on the imaginary axis of s-plane
-
How would Fitchwood's security have to be different if the data mart were made available to customers via the Internet?
-
Write an SQL query to answer the following question: Which instructors are qualified to teach ISM 3113?
-
What are the benefits of enforcing the integrity constraints as part of the database design and implementation process (instead of doing it in application design)?
-
LDDS continued to publicly report increasing profits and sales in the financial statements, which allowed it to acquire more companies with no limit to the growth of its stock price. True/False
-
LDDS suffered from high fixed costs coupled with a lack of technical knowledge and expertise in optimizing the configuration of circuits, which resulted in high line costs. True/False
-
WorldCom overstated its earnings by improper accounting for multiple element contracts. True/False
Study smarter with the SolutionInn App