Question 1 (4 Marks)\ In a database that has many tables we have these tables\ EMPLOVEE (Salary, Name, Address, BDate, Specialization)\ DEPARTMENT (Dept_Name, Dept_Num, Managr_ID, Dept_Location)\ Choose a suitable primary key for EMPLOYEE\ Choose a suitable primary key for DEPARTMENT\ Choose a candidate key for DEPARTMENT\ Re-designing the tables to maintain the relation between them.\ Question 2 (10 Marks)\ a) Write SQL statement to create a new table named STUDENT to hold students names,\ student ID, email address, Major and GPA. Student's name and Major can consist of\ maximum 75 letters, student's ID are between 0 up to 1000 with no fractions, and\ Email follows the standard email formula, while GPA is a numerical value more than 0\ and less than 4. All information are must have within each record.\ [2Marks]\ b) Write statement to add your information to the table you created above.

In a database that has many tables we have these tables EMPLOYEE (Salary, Name, Address, BDate, Specialization) [4 Marks] DEPARTMENT (Dept_Name, Dept_Num, Managr_ID, Dept_Location) Choose a suitable primary key for EMPLOYEE Choose a suitable primary key for DEPARTMENT Choose a candidate key for DEPARTMENT Re-designing the tables to maintain the relation between them. Question 2 (10 Marks) a) Write SQL statement to create a new table named STUDENT to hold students names, student ID, email address, Major and GPA. Student's name and Major can consist of maximum 75 letters, student's ID are between 0 up to 1000 with no fractions, and Email follows the standard email formula, while GPA is a numerical value more than 0 and less than 4 . All information are must have within each record. [2Marks] b) Write statement to add your information to the table you created above. [2Marks]