Sandra, owner of Sandra’s Walls has hired you to design a DBMS for her new online marketplace for home decorating, wallpaper, home decorating accessories and draperies. She wants to track sales, potential sales, and customers. During a meeting with Sandra, you and Sandra developed requirements to begin the design of an ER-model. Draw an ERD described by the following: (3 ERDs)
Customers: both who have bought and those as prospective buyers. Wanda has identified based on her prior brick-and-motar business outlets. Customers: identified by customer ID. Record info like name, birthday, sex, address, phone number, and email. Provide any other attributes with potential value.
Product: object currently being manufactured/sold, identified by an ID. Name, description and price should also be stored. Provide any other attributes with potential value.
Customer: in the database even if the customer has never bought products. May place any amount of orders. Every order may vary in product numbers.
Sandra wants to provide suggestions on products. Expand your previous answer to do the following:
Sandra says most of her products have similar alternatives customers can think about. She wants it to show that every product is similar to others.
Sandra wants to increase sales by customer reminders on products they have previously thought about or looked at when online her marketplace.
Is about changing the design to provide shipment and delivery. Expand your previous answer to do the following:
Different customers have multiple properties/homes they order for. Orders for the same customer may go to multiple addresses, but normally several orders go to the same address. Other infor talking about address: if it’s primary/secondary; active start data, and inactive date should be included. Provide any other attributes with potential value.
Customers want to know what people think about the products they may purchase. The DB has to let customers rate and review any products they buy, and allow prospective customers thinking about buying a product see reviews and ratings from people who already bought the product. Sandra wants to see what reviews have been looked at, so she can decide which reviews are a deciding factor in purchases.