CSC 472A - Introduction to Database Systems Assignment 1 - Normalization/Functional Dependencies 5 Points A) If you have two attributes (you can choose) then explain what it means for one of the attributes to be functionally dependent upon the other attribute. (.5 B) Using a snapshot of data for a table disprove a functional dependency between two specific attributes. (.5 pt.) C) TABLE1 (L, M, O, P, R) with functional dependencies Answer the following questions (.25 pt each) 1) What would be the option(s) for the primary key of TABLE1? 2) Currently what normal form is TABLE1 in based upon the functional dependencies given? 3) If NOT 3NF then give an explanation why it is not 4) If not 3NF then normalize TABLE1 and give the 3NF design D) Normalize the following schema with the given constraints to 3NF (actually 4NF). Indicate the normalized schema. (2 pts) Books(accessionno, isbn, title, author, publisher) Users(userid, name, deptid, deptname) Accessionnoisbn Isbn title Isbn publisher Isbn author Userid name Userid - deptid Deptiddeptname E) Given the normalized schema you created in problem D answer the following questions (5 pt. each) 1) Indicate the foreign keys in the tables where they exist 2) Do you see any problems with the design (if this was the total database design)? If so, what is the problem(s)