At Westonci.ca, we make it easy to get the answers you need from a community of informed and experienced contributors. Get accurate and detailed answers to your questions from a dedicated community of experts on our Q&A platform. Explore comprehensive solutions to your questions from a wide range of professionals on our user-friendly platform.

The Public Safety office at Millennium College maintains a list of parking tickets issuedtovehicles parked illegally on the campus. The above table shows a portion of this list for thefall semester. (Attribute names are abbreviated to conserve space.) Page 2of 2a) Convert this table to a relation in first normal form by entering appropriatedatainthe table. What are the determinants in this relation? b) Give an example of one or more anomalies that can result in using this relation. c) Identify the functional dependencies represented by the attributes showninthetable. State any assumptions that you make about the data and the attributes shownin this table. d) Develop a set of relations in third normal form. Identify the primary, alternate, andforeign keys in your 3NF relations.