CS200 Assignment 8
Page 1 of 4
CS200 Assignment 8 – SQL
Due Tuesday July 3
rd
2018, 11:59 pm
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
yHC1_yHC2_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
yHC
.
4)
Drag a copy of the
universityTables
folder (which contains
university.db
) to
yHC.
You've reached the end of your free preview.
Want to read all 4 pages?
- Spring '17
- Database management system, yhc
