Imagine that you are designing an online shopping system, including basic functions such as item searching...

   

Transcribed Image Text:

Imagine that you are designing an online shopping system, including basic functions such as item searching and item collection. To design the system efficiently, you are required to determine the entities in a function and the relationships between functions. For each User of the system, we have his/her customerID, name, username, contact no., and password. When the user search an Item, the system should display the related items and also the item attributes, such as the itemID, name, photo, price. Each item also indicates a CurrentState, which includes (available, wait for several days, or wait for months) as attributes. Moreover, each item belongs to multiple Category, indexed by categoryID. Items can be inserted into users' unique Collection. The collection should list all the items (whose attributes can be ignored here) and the dates when collected. Draw an ER Diagram based on the above description. Imagine that you are designing an online shopping system, including basic functions such as item searching and item collection. To design the system efficiently, you are required to determine the entities in a function and the relationships between functions. For each User of the system, we have his/her customerID, name, username, contact no., and password. When the user search an Item, the system should display the related items and also the item attributes, such as the itemID, name, photo, price. Each item also indicates a CurrentState, which includes (available, wait for several days, or wait for months) as attributes. Moreover, each item belongs to multiple Category, indexed by categoryID. Items can be inserted into users' unique Collection. The collection should list all the items (whose attributes can be ignored here) and the dates when collected. Draw an ER Diagram based on the above description.

Answer rating: 100% (QA)

Solution for the ab... View the full answer