A08_SQL_1191.pdf - CS200 Assignment 8 \u2013 SQL Due Wednesday March 13th 2019 11:59 pm Readings and Resources On Learn SQL Tutorial Files The following

A08_SQL_1191.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 Wednesday March 13 th 2019, 11:59 pm Readings and Resources On Learn: SQL Tutorial Files The following are located on Learn in Assignments > Assignment 8 > Assignment Files : ForAssign8.docx: 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 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 username1_username2_A8.docx.
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 Assignments > Assignment 8 > Assignment Files on Learn . 2) Open Macintosh HD à Users à Shared. This folder should appear on your desktop when you sign into a lab computer. You may also access it the Finder menu bar under Go > Computer. 3) Within this folder you must create a new folder called username . 4) Drag a copy of the universityTables folder (which contains university.db ) to username.
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 4 pages?

  • Spring '14
  • BarbaraDaly

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture