Question I (80 points total) Consider the following telutical database for storing data about employees and projects employee (employee_ID ase, annual salary) project project bane. budget) participation (e-ployee ID project_nane) Assume that (1) the primary key for the employee table is employee-ID). (i) the primary key for the project table is (project.name), (m) an employee may participate in multiple projects, and (iv) multiple employees may participate in the same project. (a) (10 points) Identify an appropriate primary key for the participation table. Justify your choice of the primary key preferably in 2-3 sentences (eg, why it is a candidate key) (b) (10 points) Create the participation table ting SQL Specify the primary and foreign lys as well as appropriate constraints if any. Assume that the employee and project tables are created as follows: create table employee employee. ID char(10) name varchar(30) annual salary numeric ( 92) primary key (esployee_ID)): create table project project name varchar(30) budget numeric(11, 2). primary key project ane): (C) (10 points) Consider the following instance of the project table: project nane budget PI 1,000,000 P2 2,000,000 P3 3.000.000 Also, consider the following instance of the participation table employee ID project name P1 E2 E2 E3 P1 P3 P3 Is it possible to delete sorte records from the project tabbe (not from the participation table) without violating my referential integrity? If so, explain which records can be deleted from the project table and briefly describe the trascu. If not fire, no record can be deleted frotn project), briefly explain the reason. (d) (10 points) Write a statement in SQL to update the annual salary of each employee as follows: If the current annual salary is less than 100.000, increase the salary by 4 percent. Otherwise, increase the salary w 3 percent (c) (10 points) Write a statement in SQL to find the total amont (ie., sam) of budget to support all projects in which employee "El participates