Question
Woolworths Online is an online shopping service provided by the Woolworths company. The Woolworths company hires you to design a small database to store the
Woolworths Online is an online shopping service provided by the Woolworths company. The Woolworths company hires you to design a small database to store the information about its online shopping service. Youre given the following requirements:
1.A customer is identified by his/her email address, and for each customer, we want to record his/her name, phone number, and address. The address is composed of street and suburb.
2. A warehouse is identified by its warehouse ID and we also record its contact number. A commodity is identified by its commodity ID, and we also need to know the name, price, and supplier. A commodity may have multiple suppliers.
3.A commodity must be stored in at least one warehouse and a warehouse must store at least one commodity. The stock level of a commodity in a warehouse is needed.
4.An order is uniquely identified by its order ID. An order must be created by one customer and a customer must have created at least one order. The time of an order created is needed. An order is composed of at least one commodity and the quantity of each ordered commodity is required. Some commodities may not be included in any orders. We also want to know the total amount of an order.
5.An order is sent to exactly one warehouse and a warehouse can process multiple orders.
6.A staff is identified by his/her staff ID. The name, birth date, phone number is also needed. A staff is either a manager or a team member. A team member must be supervised by exactly one manager and a manager can supervise multiple team members
7.There should be at least one staff works in a warehouse, and a staff should work in exactly one warehouse. There must be exactly one manager at a warehouse and a manager must manage exactly one warehouse.
Draw an ER diagram to represent this scenario, and clearly state the assumptions you make if any
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started