Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 S4

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

Excel As Your Database

Authors: Paul Cornell

1st Edition

1590597516, 978-1590597514

Students also viewed these Databases questions

Question

Determine the roles of spatial layout and functionality.

Answered: 1 week ago