Question
5. Police Department maintains a list of parking tickets issued to vehicles parked illegally on campus. The following table shows a portion of this list
5. Police Department maintains a list of parking tickets issued to vehicles parked illegally on campus. The following table shows a portion of this list for part of the fall semester.
SID | L_Name | F_Name | Phone | Tag_State | Tag_# | Ticket_# | Date | Code | Fine |
38249 | Hurryup | Janna | 294-03221 | IA | BRB_333 | 14356 | 9/24/17 | 2 | $50 |
15442 | 10/1/17 | 3 | $75 | ||||||
58871 | Lazee | Ina | 296-8898 | IL | SLO_223 | 13258 | 9/15/17 | 1 | $24 |
13554 | 9/17/17 | 1 | $24 | ||||||
14434 | 9/26/17 | 3 | $75 |
a. Convert this table to a relation in 1NF by entering appropriate data in the table.
b. Draw a dependency diagram showing all functional dependencies in the relation, based on the sample data provided.
c. Develop a set of relations in 3NF. Include a new column with the heading Violation in the appropriate relation to explain the reason for each ticket. Values are: 1 = Expired parking meter; 2 = no parking permit; 3 = handicap space violation.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started