Database normaliazaion

Normalization (50 pts) For each question, part b refers to the results of part a, and part c refers to the results of part b- any changes made during the previous steps should be considered in the ones that follow. Answers to the questions should be submitted via Blackboard as a PDF with your name and ction at the top of each page. Each question is worth I. Pharmacy(patient id, patient name, address, (Rxnum, trademark name, generic_name, (filldate, num_refills left), num refills) Functional Dependencies: patient_id-> patient name, address . patient-id, Rx-num trademark-name, generic-name Rx-num num-refills Rx num, filldate num refills_left (a) Is this relation in INF? If not, write an explanation of why it isn't, then make the changes necessary to fix it (b) Is this relation in 2NF? If not, write an explanation of why it isn't, then make the changes necessary to fix it (c) Is this relation in 3NF? If not, write an explanation of why it isn't, then make the changes necessary to fix it 2. CompanyEmpID, EmpName, EmpAddr, (ProjID, ProjName, MgrID, MgrName, Hours Worked)) Functional Dependencies: . EmpID EmpName, EmpAddr, ProjlD * Proj! D ProName, MgrID, MgrName . EmpID, Proj! D HoursWorked MgrIDMgrName (a) Is this relation in INF? If not, write an explanation of why it isn't, then make the changes necessary to fix it (b) Is this relation in 2NF? If not, write an explanation of why it isn't, then make the changes necessary to fix it (c) Is this relation in 3NF? If not, write an explanation of why it isn't, then make the changes necessary to fix it 3. Property(id, county, lotNum, lotArea, price, taxRate, (datePaid, amount) Functional Dependencies: . id county, lotNum, lotArea, price, taxRate * otArea price county-taxRate . datePaidamount (a) Is this relation in INF? If not, write an explanation of why it isn't, then make the changes necessary to fix it (b) Is this relation in 2NF? If not, write an explanation of why it isn't, then make the changes necessary to fix it (c) Is this relation in 3NF? If not, write an explanation of why it isn't, then make the changes necessary to fix it 4. StockExchange(Company, Symbol, HQ, Date, ClosePrice) Functional Dependencies: Symbol, Date Company, HQ, ClosePrice SymbolCompany, HQ * Symbol HQ (a) Is this relation in INF? If not, write an explanation of why it isn't, then make the changes necessary to fix it (b) Is this relation in 2NF? If not, write an explanation of why it isn't, then make the changes necessary to fix it (c) Is this relation in 3NF? If not, write an explanation of why it isn't, then make the changes necessary to fix it