Make sure you put your name in cell E2 on the Dashboard sheet. This way we can ensure you get credit for your good work.

computer science

Description

ASSIGNMENT 3.1 INSTRUCTIONS:   

In this Assignment, you prove your skills in data management and SQL.  It is worth a substantial portion of your grade, so you are encouraged to work accordingly.

Make sure you put your name in cell E2 on the Dashboard sheet.  This way we can ensure you get credit for your good work.

There is an SQL template in the "SQL template" tab.  Use it as your base for SQL submissions.

There is a "University" SQL script that accompanies this assignment.  Follow the instructions in the "Setup" tab to get the script running properly.

For the problems which require SQL code,

1.Put your SQL code in the proper place in the SQL template.
2.Paste screen shot(s) of execution in this document.  Make sure your results are easily visible.  We need to be able to see all the SQL you are executing in your screen shots.  Feel very free to use more than one screen shot if necessary.

When you have completed your assignment, you will submit:

1.The SQL template, containing your SQL code.
2.This spreadsheet, which will include screen shots.
3.Any additional attachments, such as the .erd file from Problem 1, that you deem useful.

You are encouraged to review the SQL rubric for how to write good SQL code from Week 1.

Background/Setup:  You will need to log into the Cloud Computing Labs and run the script mentioned on the "Setup" tab to create your "University" database.  It should have tables in it for courses, enrollments, faculty, offerings, and students.

Once you have created and activated the database, complete the problems on the following "Problem" sheets. Make sure you complete the problems in order, so if a record is added in an earlier problem (for example), it remains added throughout your work.

OPTIONAL: To confirm your database is working correctly, you can run the following SQL statements in MySQL Developer (note: nothing to turn in here; this is just to help verify your database works):

select count(course.crsDesc) from course;

# The above should return a count of 11 if working correctly.

select sum(course.crsUnits) from course;

# The above should return a count of 34 if working correctly.

Instruction Files

Related Questions in computer science category


Disclaimer
The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.