Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Data Mining

Authors: Pang Ning Tan, Michael Steinbach, Vipin Kumar

1st Edition

321321367, 978-0321321367

More Books

Students also viewed these Databases questions

Question

2. Compare the sales and service departments at Auto World.

Answered: 1 week ago