Question 1 (30 marks) MARTRIC NAME PROGRAM YEAR INTAKE hk100001 ALi HK20 2020 hk200000 John HK20 2011 hk200001 Damai HK02 2015 hk200002 Micle HK08 2011 Table 1: Student Record a) Based on table 1, design the database tables in MSSQL to store the following data. (10 marks) b) Write a MSSQL stored procedure to insert a new student record into the student's table. (10 marks) C) Write a MSSQL select statement to join all the tables and display the list like in Table 1. (10 marks)