Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

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

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: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

MySQL/PHP Database Applications

Authors: Jay Greenspan, Brad Bulger

1st Edition

978-0764535376

More Books

Students also viewed these Databases questions