Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

design an entity relationship diagram that describes the content of a typical online sales database each transaction is made by a registered customer each

design an entity relationship diagram that describes the content of a typical online sales database each

design an entity relationship diagram that describes the content of a typical online sales database each transaction is made by a registered customer each transaction has a transaction id and the date of purchase under each transaction there is a list of items purchased and the quantity of each in that transaction. each unique type of item appears only once in a transaction. The actual price of each item in that transaction should be included as well, which may be different from the current price. each transaction has a shipping address and the payment information, one of the credit cards of the customer. each type of item has a unique identifier, as description, the quantity available in the warehouse, its original price, and its current price, again: the purchase price of an item in a transaction can be different from the current price which may change from day to day. each customer assumes the database contain his/her id and name, shipping address, billing address, credit card, information, and phone number. Note: A customer may have more than one shipping billing address and credit card provide the entity er diagram as follows: for each entity set E: E(key)other entity set attribute indicate if it is a weak ES. For each relationship R: R(multiplicity of R from X to Y where X and Y are entity sets e.g. R(1-m from X to Y) also indicate whether R is supporting relationship and whether R carries any attributes of its own. You are not expected to use any ISA hierchey for this question, please give correct diagram I don't want texual representation diagram

Step by Step Solution

3.50 Rating (153 Votes )

There are 3 Steps involved in it

Step: 1

In Customer entity the attributes are EmailidCusstomaridPassword customer can login using id and pas... 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

Modern Systems Analysis And Design

Authors: Joseph Valacich, Joey George

8th Edition

0134204921, 978-0134204925

More Books

Students also viewed these Computer Network questions

Question

Understand the importance of strategic planning? LO.1

Answered: 1 week ago

Question

Describe how self-defeating attitudes create a vicious cycle.

Answered: 1 week ago

Question

What are the objectives of Human resource planning ?

Answered: 1 week ago

Question

Explain the process of Human Resource Planning.

Answered: 1 week ago