I need help determining the following normalization and functional dependency problems

2. Normalization (worth 35 points). Answer the questions below about the Customer-Sales Representative table of data. SalesRep SalesRap Cust Customer Cust RegionlD Region ID Name ID Name StartDate Name 5001 Robinson $5002 Tire World 10/1/2005 21 Eastern 5001 Robinson C5003 Auto SuperStore 6/22/2006 R1 Eastern 5002 Martin C5004 Monster Tires 8/10/2005 R1 Eastern 5002 Martin 25005 Truck Mart 10/9/2005 R1 Eastern 5003 Thompson C5006 Tire Carnival 10/1/2005 R2 Western a) List the attribute(s) that should serve as the primary key for this table of data. (10) b) State the current normal form of the table of data above, and list the three types of functional dependencies that exist in the table. (10) 4 Problems and Short Essay Questions c) Normalize the table of data above to 3rd normal (step by step) form and draw keys. (15) the resulting relational schema. Don't forget to specify primary keys and foreign3. Normalization (worth 35 points). Answer the questions below about the Project table of data. EmpliD EmpIName ProjectID ProjectClient Hours Billing Worked Rate 111 Joe P1 Bank of America 15 $60 111 Joe P2 People's Bank 27 $65 222 Bob P1 Bank of America 10 $70 222 Bob P3 MetLife 18 $68 222 Bob P4 Hanover Ins 22 $65 333 Lisa P1 Bank of America 15 $70 333 Lisa P3 MetLife 5 $80 a) List the attribute(s) that should serve as the primary key for this table of data. (10) EmpllD ProjectID, b) State the current normal form of the table of data above, and explain why the table is in that normal form. (15) c) Normalize the table of data above to 3rd normal form (step by step) and draw the resulting tables with data included. Please draw the tables and data, not the relational schema. Don't forget to include primary keys and foreign keys, and underline the attribute(s) which serve as primary keys. (15)