Answered step by step
Verified Expert Solution
Question
1 Approved Answer
question 3) typo *PKs (Primary key) and FKs (Foreign Key) Use the table below to answer these questions 1) Which normal form is this table
question 3) typo *PKs (Primary key) and FKs (Foreign Key)
Use the table below to answer these questions 1) Which normal form is this table in? 2) Decompose the table into 3NF. Show the process of conversion 3) Draw a relational model for the question-you must show the relations, PKs and Manufacturer Manufacturer Service Car Serviced Serviced CarRego ID Name Date ModelBranchID BranchName ServicelD Type of Service C1WE23 Man1 Holden 3/5/18 Baia Branch1 BurwoodS1 Exhaust change Log book service C1WE23 Man1 Holden 3/9/18 BariBranch1 Burwood S2 Log book C1WE23 Man1 Holden 3/9/19 BarinaBh Burwood S2 service Tyre G3DEW1 Man2 Toyota 3/5/18 Corolla Brnch Burwood S3 replacement Exhaust change Oil G3DEW1 Man2 Toyota 4/6/18 Corolla Brch2 Ashfield S1 PWE23G Man3 Audi 2/3/18 | C5 Branch3 Marsfield S4 check/change Log book PWE23G Man3 Audi 3/9/18 | C5 Branch4 Epping S2 service Oil check/change D96EWQ Man1 Holden 3/9/18 Barina Branch4Epping S4Step 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