Question
Read the following scenario carefully and answer the question a and b. Alatool Sohar Souq is an online shopping website. The main entities for online
Read the following scenario carefully and answer the question a and b.
Alatool Sohar Souq is an online shopping website. The main entities for online shopping are Customer, Web User, Account, Shopping Cart, Product, Order, Payment, etc. and relationships between them.
Each customer has unique id and is linked to exactly one account. Account owns shopping cart and orders. Customer could register as a web user to be able to buy items online. Customer is not required to be a web user because purchases could also be made by phone or by ordering from catalogues. Web user has login name which also serves as unique id. Web user could be in several states - new, active, temporary blocked, or banned, and be linked to a shopping cart. Shopping cart belongs to account.
Account owns customer orders. Customer may have no orders. Customer orders are sorted and unique. Each order could refer to several payments, possibly none. Every payment has unique id and is related to exactly one account.
Each order has current order status. Both order and shopping cart have line items linked to a specific product. Each line item is related to exactly one product. A product could be associated to many line items or no item at all.
From the above scenario identify the major entities and draw a ER diagram for the same. Take a picture of your diagram and paste in word file.
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