Can I get help with both parts of #2.

1. The following table (relation) is in 1NF, proceed to 3NF. Be specific for the process of Normalization. (2 points) AuName AuPhone ISBN 0321321321 0321321321 Title Balloon 13 Balloon 11 PublD PubName PubPhon Price 21-3211 3 Smal Hous 456-7896 $34 Smal Hous 456-7896 $34 Smal Hous 456-7896 BigHouse 123-5542 BigHouse 123-5542 $25 BigHouse 123-5542 BigHouse 123-5542 38 321-2222 3 1321321 1-3333 123-4444 123-5555 2 0551234569 0551234569 0847896521 0847896521 Python13Sleepy 10 Jones Smith Bronte Python1 321-3211 2. An agency called Instant Cover supplies part-time/temporary staff to hotels within Scotland. The table displays sample data, which lists the time spent by agency staff working at various hotels. The National Insurance Number (NIN) is unique for every member of staff (3 points) (a) Identify the functional dependencies represented by the attributes shown in the table. Identify primary keys in your relations. (b) Describe and illustrate the process of normalizing the table to 3NF. Be specific for the process NIN contractNo hours eName hNo hLoc 135 C1024 1057 C1024 1068 C1025 1135 C1025 16 Smith H25 East Kilbride 24 28 White TH4 Glasgovw 15 Smith J H4 Glasgovw Hocine D H25 East Kilbride