Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Secured Finance Transactions Key Assets And Emergin Markets

Authors: Paul U Ali

1st Edition

1905783108, 978-1905783106

More Books

Students also viewed these Finance questions

Question

socialist egalitarianism which resulted in wage levelling;

Answered: 1 week ago

Question

soyuznye (all-Union, controlling enterprises directly from Moscow);

Answered: 1 week ago