Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 3 ZZ Burger Store is still using file-based method in their operational business. They record the customer orders in Excel spreadsheet as shown

3.png


3.1.png


 
 

QUESTION 3 ZZ Burger Store is still using file-based method in their operational business. They record the customer orders in Excel spreadsheet as shown in Table 2. Customers should have customer ID, customer name and their phone number. Table 2: ORDER DATA Table Order ID Order Date Menu Name Quantity Customer Name Customer Phone Number Staff ID and Name Fish 012- 11 30/06/2022 2 William 301 Willy Burger 34567899 012- 11 30/06/2022 Benjo 2 William 34567899 301 Willy Chicken 012- 12 30/06/2022 1 Andrew 302 Wendy Burger 1122334 Mutton 012- 13 07/08/2022 Kebab 1 Zach 301 Willy 5555555 Burger Chicken Double 012- 13 07/08/2022 3 Zach 301 Willy Cheese 5555555 Burger Answer the following questions. a) State the normal form of the above table. Explain your answer with reasons. (3 marks) b) Convert the table into a relational schema. Identify the primary key(s) and partial dependencies and/or transitive dependencies. (6 marks) c) Normalize the relational schema in (b) until third normal form (3NF). Show all your work. (11 marks)

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

Recommended Textbook for

Essentials Of Services Marketing

Authors: Jochen Wirtz

4th Edition

1292425199, 9781292425191

More Books

Students also viewed these Databases questions

Question

Record Journal Entry for the above transactions.

Answered: 1 week ago

Question

What is meant by using brands to tier service levels?

Answered: 1 week ago