CS200 Assignment 8
Page 1 of 4
CS200 Assignment 8 – SQL
Due Tuesday July 2, 11:59 pm
Reminders
Have you done a backup this week? Don’t forget Assignment 0!
Readings and Resources
On Learn:
Database Resources > Database Design
SQL Tutorial
Files
The following are located on
Learn
in
Week 8 > Assignment Files
:
ForAssign8.doc:
Download this file and put your answers for question 1 here.
universityTables.zip
:
Download this file and follow the steps in question 1.
SampleDB_Diagram
.
pdf
:
This shows a diagram of the tables used in question 1 and
will be helpful when doing question 1.
Assignment Objectives
•
To gain an understanding of a command line Database Management System.
•
To see the “backend” of a GUI Database Management System.
•
To gain a stronger understanding of database design and the importance of proper database
structure.
•
To fully understand what relational databases mean.
Assignment Strategy
You may work on question 1 with a partner. If you do, be certain that you both
understand all of what you have done. The purpose of allowing you to work in groups
is to enable you to help each other understand the assignment, not to enable you to
divide up the work. If you work with a partner, label your answer to question 1
username1_username2_A8Q1.doc.

CS200 Assignment 8
Page 2 of 4
Assignment Setup
Please follow these instructions very carefully to find the files and programs you need.
1)
Download and unzip
universityTables.zip
from
Week 8 > Assignment Files
on
Learn
.
2)
Open
Macintosh HD ° Users ° Shared
3)
Within this folder you must create a new folder called
username
.
