Add on to the below ER diagram to finish the below requirements:

a.Wally wants to be able to suggest products for customers to buy. Augment your answer to part a of this assignment, to present the following new requirements in the database.

Wally knows that most of the products he sells have similar alternatives that a

customer might want to consider. Similarity is fairly subtle, so he or his staff would

like to be able to identify each product is similar to what other products, if any.

Wally also thinks that he can improve sales by reminding customer about products

they have previously considered or viewed when on his online marketplace.

C.) In the next phase, you will extend the database design to begin to handle shipment and delivery. Augment your answer to part b of this assignment, to present the following new requirements in the database.

Some customers may have multiple homes or properties for which they order products. Different orders for the same customer may go to different addresses, but several orders for the same customer often go to the same address. Other information regarding the address such as whether the address is primary or secondary address, address active start data, and address inactive date should also be stored. Include any other attributes you believe should benefit the organization in your ERD.

Customers also like to see what other people think about products they are considering to buy. So, the database needs to be able to allow customers to rate and to write review for any products they buy, and for other customers considering purchasing a product to see the reviews and ratings from those who have already purchased the product being considered. Wally also wants to know what reviews customers have viewed, so he can tell which reviews might be influencing purchases.

Products Product ID Product name Product description Standard Price Customer Customer Gender Customer Name (first, last) Customer DOB Age Customer Mailing address (street, city, state, zip) Customer Email Address Customer Phone Number) Order Details Quantity Color Order Order ID Order Date Order Time Order Total Method of Payment Products Product ID Product name Product description Standard Price Customer Customer Gender Customer Name (first, last) Customer DOB Age Customer Mailing address (street, city, state, zip) Customer Email Address Customer Phone Number) Order Details Quantity Color Order Order ID Order Date Order Time Order Total Method of Payment