CS200 Assignment 8 Page 1 of 4CS200 Assignment 8 – SQL Due Tuesday July 3rd2018, 11:59 pm Readings and Resources On Learn: Database Resources > Database Design SQL Tutorial Files The following are located on Learnin 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 4Assignment Setup Please follow these instructions very carefully to find the files and programs you need. 1)Download and unzip universityTables.zipfrom Week 8 > Assignment Fileson Learn. 2)Open Macintosh HD àUsers àShared3)Within this folder you must create a new folder called yHC. 4)Drag a copy of the universityTablesfolder (which contains university.db) to yHC.