ER DIAGRAM for E$-$Shopping

Consider the following information about an e$-$shopping database:

E$-$shopping is often preferred by many users for buying and selling products and

services in the shopping domain. Users who have not previously registered on the platform

must create a membership account in the system. If a membership record exists, the user

should log in with their username and password. There are two types of users in this

system: customers and sellers. After customers log into the system, they can perform

tasks such as product search, favoriting items, creating collections, adding items to their

cart, and completing purchases. Users have the ability to see the products they've marked

as favorites and get notified when the prices of those items decrease. Popular products,

most favorited items, and reviewed products are presented to the user in list format for

specific categories. During the checkout process, if there is a discount coupon available for

a product, the user can apply this coupon to their shopping cart. After completing the

purchase process, users can view their orders from the account menu in their profile.

Additionally, users can track their orders, learn about the shipping company and delivery

date, and initiate returns and exchanges by selecting shipping details from the same menu.

Users can also add written$/$visual comments and ratings for the products they have

purchased.

Design and draw an ER diagram using

a$)$ Chen's