QUESTION 7 Consider the SQL database that implments the following ERD: Enrolment Student Paper e Student ID e Student User Code e Paper Code Student ID e Paper Code Year First Name Last Name DOB e Paper Name e Points Mark e Absent A user wishes to query the database returning a list of students' IDs, First and Last Names against their paper enrolments (specifically, the paper code year and semester of enrolment). For any given student that has not yet enrolled in a paper, the user wishes them to remain in the query, but the paper code, year and semester values for that corresponding student will be blank (NULL). Fill in the missing values to complete the following SQL SELECT statement and enable this query: SELECT Student ID, First Name, Last Name, Paper Code, Year, Semester FROM Student JOIN Enrolment LUSING Be sure to follow the convention laid out in lectures when declaring table and/or columns names in SQL (esp. replacing spaces with underscores) QUESTION8 Consider the following ERD: Enrolment Student Paper Paper Code Student ID . Year e Semester e Student ID Paper Code e Student User Code e First Name . Paper Name e Points Last Name DOB Mark Absent The relationship between Student and Enrolment is now to be implemented using the following (incomplete) SQL statement: ALTER TABLE Fill in the missing values to complete the SQL statement. Be sure to follow the convention laid out in lectures when declaring table and/or columns names in SQL (esp. replacing spaces with underscores) FOREIGN KEY REFERENCES