Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Imagine the following scenario: The Public Safety office at Millennium College maintains a list of parking tickets issued to vehicles parked illegally on the campus.
Imagine the following scenario: The Public Safety office at Millennium College maintains a list of parking tickets issued to vehicles parked illegally on the campus. The table below shows a portion of this list for the fall semester. As an experienced database designer, you are asked to help the Public Safety office create a better database design in order to eliminate data redundancy. Hint: a primary key is not identified in the table below. As a first step, find the attribute that uniquely identifies each row in the table of data. A single attribute can serve as the primary key for this table. In other words, the table of data provided does not need a composite primary key. Table 1. Parking Tickets STID LName, FName PhoneNg St Lic LicNo. TicketNo Date Code Fine 38249 Brown, Thomas 111-7804 | FL BRY 123 15634 09/17/17 2 $25 38249 Brown, Thomas 111-7804 FL BRY 123 16017 09/13/17 $15 82453 Green, Sally 391-1689 TRE 141 14987 09/05/17 $100 Green, Sally 391-1689 TRE 141 16293 09/18/17 $15 82453 Green, Sally 391-1689 AL TRE-141 17892 09/13/17 2 $25 1 3 AL AL 82453 1 Please examine the table of data and perform the following tasks: 1. Depict the full key, partial and transitive functional dependencies in the data table using the written notation (e.g., ID Name, Address)
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