Consider the school database, where the primary keys are underlined:student (student_id, name, address,gender)course (u, course_name, year)department (dept_number, date, department_name)                                 i.             Write an SQL statement to add a new record into the department table. (3 Marks)                           ii.            Write an SQL statement to delete all the records from the course table. (2 Marks)Answer text Question 4EditViewInsertFormatToolsTableHelp

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?

Problem StatementIn a university's academic department, a database table named "students" that stores information about students, including their student ID, name, enrolled course, and scores obtained in different subjects.The university administration wants to analyze the performance of students and identify those who scored above a certain threshold. To facilitate this analysis, you are tasked with creating a stored procedure named "GetHighScorers".The following table is already created, and the records are inserted into the table.TABLE: students student_id INT PRIMARY KEY, student_name VARCHAR(50), course VARCHAR(50), score INT

Students(StudentID, Name, Grade)A Students table is shown above. Which of the following SQL statements could be used to remove all data from Students table?Question 14Select one:a.Remove From Students;b.Delete From Students;c.Select * From Students;d.Drop Table Students;

Question 8In the following student table, which attribute could be used as a primary key?Student first nameStudent last nameMobile numberCarl Merlo07445532123MarkNero074565323271 pointStudent last nameMobile numberStudent first name

Identify the foreign key for STUDENT relation.STUDENT (stuID, stuLName, stuAddress)ENROLLMENT (enrID, subName, className, stuID)Choose one answer. a. enrID b. subName c. stuID d. className