data base management system

Part 1: Functional dependencies: Question 1: (10) Wizard WID 101 102 103 wName Harry Ron Draco Age 12 12 12 Table 2 Table 2 includes information about each wizard. a) Do you think wName is functionally dependent of ID based on functional dependency rule in another words, do you think wid + WName?) b) Do you think a wizards age is functionally dependent on a wizards name? c) What about wiD + age? d) What about WNAme - WID? Question 2: For a given relationship set, Gringotts_account = {Account_ID, Date_of_Birth, Age, Account_name} FDs are, Account_ID Date_of_Birth, Date_of_Birth - Age Find F closure of i) Account_ID. Date_of_Birth, Age) ii) (Account_ID, Date_of_Birth, Account_name) iii) Which one of i or ii is a superkey? Show all the steps that you used to calculate closure. Question 3: (+4) a) How long did it take for you to complete the assignment? b) Was there any section that you faced difficulties? You'll get 4 out of 4 if you answer this