SQL Queries

Using the attached database, please show how to do the following:

1. Using a join, get the full details of all the students who work on the mid-term exam assignment.
2. Get the assignment names (duplicates eliminated) being worked on by students at Central University.
3. Get the last names of all the students who are working on assignment A1.
4. Get the student numbers and start dates of all the students with start dates equal to the earliest date.
5. Insert Amber Rebeck into the student table with the student number of 14420 and show as attending Central University. Then show all the records in the student table.
6. Delete Amber Rebeck by matching the student number 14420, and then show all the records in the student table.


For all parts in this problem, I am looking for SQL command being executed from Management Studio. So for inserting row into table, I need to see how a SQL command that will insert data into the table.. shows its execution.. and then shown the table with new data inserted..

Similarly, for deleting a row from a table, I want to specify a SQL command that will delete data into the table.. shows its execution.. and then shown the table with data deleted..

In addition to script file containing SQL commands for each of the subparts, we are also looking for a Word document containing screenshots of executing each of the commands successfully. Both the files can be zipped together.

Attached file(s):

Database.zip  View File