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.
