Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

What are the role of supervisors ?

Answered: 1 week ago