y entering my name above I certify that I completed this SQL part of the Mid Term Exam without any
assistance from any other person.
This SQL Take Home Portion of the Final Exam is worth 30 Points. NOTE: This exam is b
...
y entering my name above I certify that I completed this SQL part of the Mid Term Exam without any
assistance from any other person.
This SQL Take Home Portion of the Final Exam is worth 30 Points. NOTE: This exam is based on 100
points, then multiplied by .3, then added to the written final (worth 70 points) for your Mid Term Exam
grade. You can use any resource including your textbook, notes, posted solutions from your homework,
and online help BUT you cannot have any other person assist you. Any honor code violation on this
exam will result in failure of the course. You are to go into your class section of SQL Server and execute
each of the instructions below.
NOTE: All code and data MUST be copy and pasted from SQLServer for credit.
SECTION 1: (DDL) Creating Tables, Inserting Data, and Making Modifications (35 Points)
PLEASE NOTE: Be sure to be careful with each part of this exam as it builds as you execute your code. If
you get results that you know are not correct or have made errors you might consider deleting all your
tables and starting over. The textbook should cover how to do each part but be careful when applying it
to the actual requirement(s). Be sure to show both your code (CODE:) and the data (DATA:) as
requested and be sure it is a copy/paste from the SQL Server ONLY. Your code should be properly
indented for ease of grading. If the data is more than 10 lines just show the first 10 lines of the data
returned.
This section deals with SQL coding of creating, modifying, deleting, and altering tables, fields, and data.
It is referred to as the DDL (Data Definition Language) portion of a database. Please follow the
instructions below for this section.
[Show More]
