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 PhoneNo 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 1 $15 82453 Green, Sally 391-1689 AL TRE 141 14987 09/05/17 3 $100 82453 Green, Sally 82453 391-1689 AL TRE 141 Green, Sally 391-1689 AL TRE-141 16293 17892 09/18/17 1 $15 09/13/17 2 $25 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);

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 PhoneNo 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 1 $15 82453 Green, Sally 391-1689 AL TRE 141 14987 09/05/17 3 $100 82453 Green, Sally 82453 391-1689 AL TRE 141 Green, Sally 391-1689 AL TRE-141 16293 17892 09/18/17 1 $15 09/13/17 2 $25 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);

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 43P

See similar textbooks