Database design

Normalization Workshop Review the following excerpt of a Parket Ticket Report produced at a local college.

STID LName FName PhoneNo St Lic LicNo Ticket# Date Code Fine ----- ----- ------ -------- ------ ------- ------- -------- ---- ---- 38249 Brown Thomas 111-7804 FL BRY 123 15634 10/17/10 2 $25 

 16017 11/13/10 1 $15 

82453 Green Sally 391-1689 AL TRE 141 14987 10/05/10 3 $100 16293 11/18/10 1 $15 17892 12/13/10 2 $25 

(1) Assume that this the information in this report is stored in a table that is in 1st normal form. Show the complete contents of this table.

(2) Given the contents of this table, identify the determinants and indicate what is functionally dependent on each determinant.

(3) Identify anomalies that can result from using this table.

(4) Apply the normalization process to develop a set of tables in third normal form. Add a new column with the heading Violation in the appropriate table to explain the reason for each ticket. Values in this column are expired parking meter (ticket code 1), no parking permit (ticket code 2), and handicap violation (ticket code 3).