Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need help with this question how was the working out done for this answer ? the answer is provided below Solution: Given, A set of

need help with this question

how was the working out done for this answer ? the answer is provided below

image text in transcribedimage text in transcribed
Solution: Given, A set of data in ONF We need to normalize the data to 3NF Zero Normal Form . This is simply a set of data that has not gone through the process of normalization. First Normal Form . In first normal form every attribute must be singled valued attribute. So, we need to remove repeating groups from the table. Since the given table doesn't have any repeating group, it is already in first normal form. So, after 1" normal form the table is same as the given table. Second Normal Form It has to be in 1" normal form. a Table should not contain partial dependency. A table is said to have partial dependency if a non-prime attribute/column depend only on a part of primary key. Since the table in in 1$ normal form and doesn't have any partial dependency, 2NF is also same as INF which is same as the given table.Third Normal Form It has to be in 2"d normal form. There should be no transitive dependency for non-prime attributes. Eliminating the transitive dependency for non-prime attributes we have CarRero Manufacturer ID Service Date Serviced FranchiD MechaniciD Servicelo CIWE23 MI 3/5/2020 Branch1 MI 51 Primary Key CIWE23 MI 3/9/2020 Branch1 MI 52 CIWEX MI 3/9/2020 Branch M3 GIDEWI 3/5/2021 Branch1 M2 GIDEWI 12 4/6/2021 Branch2 MR 51 PWEZIG MI 2/3/2020 Branch MI PWEZIG 3/9/2021 Branch4 MI 8/9/2021 Branch4 M3 Manufacturer ID Manufacturer Serviced BranchiD Serviced MechaniciD MechanicName Name BranchName MI Holden Branch1 Nowtown Harry Potter Toyota Branch2 Haberfield Hermoing Granger Aud Branch3 Marsfield Ronald Weasley Branch Epping Manufacturer ID Car Model ServicelD TypeofService MI Baring 51 Changed exhaust M2 Corolla 152 Yearly Service ME 153 Fuel tank service Yearly Service Now we have the data after normalizing from ONF to 3NF

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

Cost Accounting A Managerial Emphasis

Authors: Charles T. Horngren, Srikant M.Dater, George Foster, Madhav

13th Edition

8120335643, 136126634, 978-0136126638

More Books

Students also viewed these Accounting questions