Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started