Draw the dependency diagram and identify the functional dependencies. Show the process of converting this table to 3NF

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Draw the dependency diagram and identify the functional dependencies. Show the process of converting this table to 3NF

 

Service Booking Record
Service_id
Ser_Cat Ser_Wk_hrs| Ser_Cost Client_name |Cl_cont
Truck_no Truck_Cap BKG_date
HV10258
2
4
$550.00 Bill Jones
463552583 25145
6 TΝ
2/01/2020
BV35015
$975.00 Kelly Payne |478965242| 23123
$1,015.00 Dan Wong
7/11/2019
20/01/2020
4
5
7 TN
MR2547
| 421112223 25122
8 TN
CV54442
3
5
$750.00 Tim Kane
526411852 25111
7 TN
15/04/2020
$550.00 Lorry Brown 457896235 25145
$800.00 Anu Manta
HV10259
2
4
6 TN
13/06/2020
BV35020
3.5
5
464552543 25111
7 TN
25/07/2020
Transcribed Image Text:Service Booking Record Service_id Ser_Cat Ser_Wk_hrs| Ser_Cost Client_name |Cl_cont Truck_no Truck_Cap BKG_date HV10258 2 4 $550.00 Bill Jones 463552583 25145 6 TΝ 2/01/2020 BV35015 $975.00 Kelly Payne |478965242| 23123 $1,015.00 Dan Wong 7/11/2019 20/01/2020 4 5 7 TN MR2547 | 421112223 25122 8 TN CV54442 3 5 $750.00 Tim Kane 526411852 25111 7 TN 15/04/2020 $550.00 Lorry Brown 457896235 25145 $800.00 Anu Manta HV10259 2 4 6 TN 13/06/2020 BV35020 3.5 5 464552543 25111 7 TN 25/07/2020
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Normalization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education