A08_SQL_1195.pdf - CS200 Assignment 8 \u2013 SQL Due Tuesday July 2 11:59 pm Reminders Have you done a backup this week Don\u2019t forget Assignment 0

A08_SQL_1195.pdf - CS200 Assignment 8 u2013 SQL Due...

This preview shows page 1 - 3 out of 4 pages.

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.
Image of page 1
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 .
Image of page 2
Image of page 3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture