*NURSING > A-Level Question Paper > SQL (with Complete Solutions) (All)

SQL (with Complete Solutions)

Document Content and Description Below

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]

Last updated: 1 year ago

Preview 1 out of 20 pages

Buy Now

Instant download

We Accept: