Parking Tickets Table St ID L Name F Name Phone No St Lic Lic No Ticket# Date 38249 Brown Thomas 111-7804 FL BRY 123 15634 10/17/06 38249 Brown Thomas 111-7804 FL BRY 123 16017 11/13/06 82453 Green Sally 391-1689 AL TRE 141 14987 10/05/06 82453 Green Sally 391-1689 AL TRE 141 16293 11/18/06 82453 Green Sally 391-1689 AL TRE 141 17892 12/13/06 121312 Code Fine $25 $15 $100 $15 $25 Functional dependencies FD A - St_ID → L_Name, F_Name, Phone_No, St_Lic, Lic_No FD B-St_Lic → Lic_No FD C Code → Fine FD D-St_ID, Ticket_# → Date

Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter7: String Manipulation
Section: Chapter Questions
Problem 14E
icon
Related questions
Question

- Is FD A a partial or transitive dependency?
- Is FD B a partial or transitive dependency?
- Is FD C a partial or transitive dependency?
- In what normal form is the relation Parking Tables?
- Convert the relation Parking Tables to a set of 3NF relations.

Parking Tickets Table
St ID L Name F Name Phone No St Lic
Lic No
Ticket# Date
38249 Brown
Thomas
111-7804
FL
BRY 123
15634
10/17/06
38249 Brown
Thomas
111-7804 FL
BRY 123
16017
11/13/06
82453 Green
Sally
391-1689 AL
TRE 141
14987
10/05/06
82453 Green Sally
391-1689 AL
TRE 141
16293 11/18/06
82453 Green Sally
391-1689 AL
TRE 141
17892 12/13/06
121312
Code
Fine
$25
$15
$100
$15
$25
Functional dependencies
FD A - St_ID → L_Name, F_Name, Phone_No, St_Lic,
Lic_No
FD B-St_Lic → Lic_No
FD C Code → Fine
FD D-St_ID, Ticket_# → Date
Transcribed Image Text:Parking Tickets Table St ID L Name F Name Phone No St Lic Lic No Ticket# Date 38249 Brown Thomas 111-7804 FL BRY 123 15634 10/17/06 38249 Brown Thomas 111-7804 FL BRY 123 16017 11/13/06 82453 Green Sally 391-1689 AL TRE 141 14987 10/05/06 82453 Green Sally 391-1689 AL TRE 141 16293 11/18/06 82453 Green Sally 391-1689 AL TRE 141 17892 12/13/06 121312 Code Fine $25 $15 $100 $15 $25 Functional dependencies FD A - St_ID → L_Name, F_Name, Phone_No, St_Lic, Lic_No FD B-St_Lic → Lic_No FD C Code → Fine FD D-St_ID, Ticket_# → Date
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Microsoft Visual C#
Microsoft Visual C#
Computer Science
ISBN:
9781337102100
Author:
Joyce, Farrell.
Publisher:
Cengage Learning,