Is about changing design to provide shipment and delivery

Assignment Help Operation Management

Reference no: EM132083740

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.

Reference no: EM132083740

Questions Cloud

Customer satisfactions and repurchase behavior : Explain the correlation between customer satisfactions and repurchase behavior.

What is performance management : What is performance management? How does the performance management approach relate to performance appraisal?

Where do you fall on the diffusion of innovation curve : When it comes to new technology, where do you fall on the diffusion of innovation curve?

Role of job analysis in hr selection model : Draw/reproduce the “Role of JA in HR Selection Model.”

Is about changing design to provide shipment and delivery : Sandra wants to provide suggestions on products. Is about changing the design to provide shipment and delivery.

Best way for the household to constrain consumption : What is the best way for the household to constrain consumption so that it can save more? Give specific examples.

Supply chain management and other business operations : Discuss the relationship between supply chain management and other business operations.

Sarbanes-oxley act protections to public employees : What is the reasoning behind limiting the Sarbanes-Oxley Act's protections to public employees?

Few days intentionally experience something new : Over the next few days intentionally experience something NEW.

User Account

All Pages