Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Do normalization based on this diagram. Do Normalization Customer Customer ID M001 M002 M003 M004 M005 Last Name Hakimi Hamid First Name Azrul Atikah Amira

Do normalization based on this diagram.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Do Normalization Customer Customer ID M001 M002 M003 M004 M005 Last Name Hakimi Hamid First Name Azrul Atikah Amira Immran Ain Phone Number 0182376455 0123193872 0132817334 0137827766 0175449720 Azira Email azrul@gmail.com atikah@gmail.com amira@gmail.com immran@gmail.com ain@gmail.com Johari Asri Orders Order ID Weight (kg) of Customer ID Staff Name 0001 0002 0003 0004 0005 3.5 2.3 2.1 1.5 Type Cleaning Hand Machine Hand Hand Machine M001 M002 M003 M004 M005 Izzah Adam Idris Hawa Nur Invoice Number 10001 10002 10003 10004 10005 3.0 Invoice Invoice Number Date Out Order ID Total Amount 10001 10002 10003 10004 10005 Customer Date In Phone Number 0182376455 31 Dec 2021 0123193872 1 Jan 2022 0132817334 3 Jan 2022 0137827766 10 Jan 2022 0175449720 15 Jan 2022 2 Jan 2022 4 Jan 2022 7 Jan 2022 14 Jan 2022 17 Jan 2022 RM 15.00 RM 8.00 RM 7.50 RM 5.00 RM 13.00 0001 0002 0003 0004 0005 Payment Payment ID of Price Tax PAYO1 PAYO2 PAYO3 Type Payment Credit Cash Wire Transfer Cash Cash RM 15.00 RM 8.00 RM 7.50 6% 6% 6% Total Payment RM 15.90 RM 8.48 RM 7.95 Invoice Number 10001 10002 10003 PAY04 PAY05 RM 5.00 RM 13.00 6% 6% RM 5.30 RM 13.98 10004 10005 Staff Staff ID Shift In Shift Out Order ID Stock ID Service ID S001 S002 S003 S004 S005 Staff Name Izzah Adam Idris Hawa Nur 8:00 a.m. 12:00 p.m. 0001 12:00 p.m. 6:00 p.m. 0002 12:00 p.m. 6:00 p.m. 0003 8:00 a.m. 12:00 p.m. 0004 8:00 a.m. 12:00 p.m. 0005 ST01 STO2 STO3 ST04 ST05 SE01 SE02 SEO3 SE04 SE05 Stock Stock ID STO1 STO2 STO3 Type of Stock Softener Hanger Detergent Stock Quantity 20 100 50 Supplier ID SUP01 SUP01 SUPO1 Staff ID S002 S003 S004 Supplier Supplier ID Supplier Name Supplier Price Delivery Date Supplier Contact 0198314644 SUP01 Ahchong RM 900 31 Dec 2021 Services Details Type of services Pickup Pickup Delivery Delivery Pickup Service ID SE01 SE02 SE03 SE04 SE05 Staff ID S001 S002 S003 S004 S005 FoodTruck FoodTruck ID FT01 FT02 Staff ID S004 S005 Menu Food ID F01 Food Price RM 2.00 Food Truck ID FT01 FO2 RM. 10.00 FTO2 Food Desc Food Name Rice, Boiled Nasi Lemak Egg, Anchovies, Peanut, Sambal Chicken, Black Chicken Chop Pepper sauce Keropok, Sauce Keropok Lekor Chocolate chip, Cookies Seasalt cookies. Bottle, Water Mineral Water Orange, Water Fresh Orange FO3 F04 RM 3.00 RM 15.00 FT01 FTO2 F05 F06 RM 1.00 RM 2.50 FT01 FTO2

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

Step: 3

blur-text-image

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

Fundamentals Of Database System

Authors: Elmasri Ramez And Navathe Shamkant

7th Edition

978-9332582705

More Books

Students also viewed these Databases questions

Question

In an Excel Pivot Table, how is a Fact/Measure Column repeated?

Answered: 1 week ago