Answered step by step
Verified Expert Solution
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
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 3NFStep 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