Phil has been asked to create a database for his company.The database is to trac

Phil has been asked to create a database for his company.The database is to track employees and the projects on which theemployees work. A project can have between 3 and 7 employeesassigned to it. He has determined that he needs the followingtables:Employee (Social Security Number Employee Name StreetAddress City State Postal Code Date Hired Hourly Pay RateProject Code)Project (Project Code Project Name CompletionDate)a. Which field in the Employee table should be the primarykey and why?b. Which field in the Project table should be the primary keyand why?Now that Phil has created the tables and determined theprimary and foreign keys he needs to determine the data types forthe fields in each table.c. What data type should Phil use for the Hourly Pay Ratefield? Why?d. What data type should Phil use for the Social SecurityNumber field? Why?