1. Convert this table to a relation in first normal form by entering appropriate
ID: 3916166 • Letter: 1
Question
1. Convert this table to a relation in first normal form by entering appropriate data (hand write or type this) - 20 points
2. Now take this table from number 1 and normalize it to 3NF. Also add a new column called Violation that explains the type of violation mapped to the Code shown on the attached table: Parking Ticket (code 1), No Parking Permit (code 2), Handicap Violation (code 3). You MUST show all of your work. - 50 points
Please do this 2 steps and make sure you follow the instruction!
Table 5-6 Parking Tickets at Millennium College PARKING TICKET TABLE St ID 38249 Date 10/17/08 2 11/13/08 10/05/083 11/18/08 12/13/08 Code Fine $25 $15 $100 $15 $25 Lic No BRY 123 Ticke? 15634 16017 14987 16293 17892 L Name F_Name Brown Phone _No 111-7804 St Lic FL Thomas 82453 Green Sally 391-1689 AL TRE 141 2 Activate WindowsExplanation / Answer
1. First Normal Form
Parking Ticket Table
2. 2NF and 3NF
Functional Dependencies :
StID -> L_Name,F_Name,Phone_No,St_Lic,Lic_No
Ticket# -> Date,Code,Fine, Violation
Tables in 2NF
Student(StID , L_Name,F_Name,Phone_No,St_Lic,Lic_No)
Ticket(Ticket# , Date,Code,Fine)
Transitive Dependency :
Code -> Violation
Tables in 3NF
Student(StID , L_Name,F_Name,Phone_No,St_Lic,Lic_No)
Ticket(Ticket# , Date,Code,Fine,St_ID)
Violation(Code,Violation)
underlined are primary keys and italicised are foreign keys.
Do ask if any doubt. Please upvote.
St_ID L_Name F_Name Phone_No St_Lic Lic_No Ticket# Date Code Fine 38249 Brown Thomas 111-7804 FL BRY123 15634 10/17/08 2 $25 38249 Brown Thomas 111-7804 FL BRY123 16017 11/13/08 1 $15 82453 Green Sally 391-1689 AL TRE141 14987 10/05/08 3 $100 82453 Green Sally 391-1689 AL TRE141 16293 11/18/08 1 $15 82453 Green Sally 391-1689 AL TRE141 17892 12/13/08 2 $25Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.