Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the data requirements for an eTailer, such as Amazon. Here are the kinds of information that the eTailer wishes to maintain: Their suppliers,
Consider the data requirements for an "eTailer, " such as Amazon. Here are the kinds of information that the eTailer wishes to maintain: Their suppliers, including supplier names, addresses, and a logo to display The items made by each supplier (e.g., HP), including the type of item (e.g., printer), the model number (e.g., 693C), and the retail price. Note that different suppliers may use the same model number for different items, even if those items are of the same type and price. However, one supplier will not use the same model number for two different items. Customers, including their name, address, and email. Credit cards, including the company (e.g., Visa), number, and expiration date Each customer may have several credit cards on file, but each credit card belongs to only one customer Orders. Each order has a unique ID, has a single customer who placed the order One of the customer's credit cards was used to pay for the order, and the order must tell which. A customer can place several orders and use different credit cards for each. An order is for some set of items, and there is an associated quantity for each. There are several ways to represent orders, but try to use a design that does not allow an order to be placed for a customer who does not own the credit card used to pay for the order Give an E/R, design for this database. Briefly explain your reasoning, including the intuitive meaning of any relationships you use and any entity sets you use other than suppliers, items, customers, and orders. Do not forget to indicate keys, many-one relationships, and weak entity sets in the appropriate ways
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started