Answered step by step
Verified Expert Solution
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 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...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