Q.5 Given that we have the follewing datahase tables with four entities EMPLOYEE, PROJECT, ASSICINMENT and 1OB (a) Identify primary keys and foreien keys for each table. (4 marks) (b) Create the relational diagram for this database. ( 4 marks) (c) Write the SQL code that will create the table structure for a table named EMP_. This table is a subset of the EMPLOYEE table. The basic EMP_ 1 table structure is summarized in the following fable (3 marks) (d) Having created the table structure in Q.5(c). write the SQL code to enter the first two rows for the table shown in the following table. (2.marks) (c) Write the SQL code to count the number of employees from the EMPLOYEE table. ( 2 marks) (f) Write the SQL code to count the number of employees whose employee years are longer than 10 years from the EMPLOYEE table. (2 marks) (g) Draw the table to show the result of the following query. SELECT ASSIGNMENT.PROJ_NUM, MIN(ASSIGNMENT_ASSIGN_CHG_HR) FROM ASSIGNMENT GROUP BY PROJ_NUM; (4 marks) (h) Draw the table to show the result of the following query. SELECT PROJECT NUM, PROJ_NAME, PROJECT.EMP_NUM, EMP_LNAME,EMP FNAME FROM PROJECT, EMPLOYEE WHERE PROJECT.EMP_NUM = EMPLOYEE.EMP_NUM: (4 marks)