This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: . . Fall 2007 CSC/CPE 365: Database Systems Alexander Dekhtyar . . Lab 1: Why Databases? Part I Due date: Tuesday, October 9 , before the Lab period starts!!! Extra Credit: Lab assignments submitted by the end of the October 4 (Thursday) lab period will be assessed 15% extra credit. Lab Assignment Assignment Preparation This is an individual lab. Each student has to complete all work required in the lab, and submit all required materials exactly as specified in this assignment. For this assignment, you will be using your Oracle account. The accounts have been assigned in class on Tuesday, October 2. If you have not recieved your Oracle account information, please contact the instructor. You will be using Oracle’s SQL*plus client and the Oracle DBMS server ora10g . Please refer to your SQL*plus handout for more information about starting SQL*plus and working with it. For the purposes of this, and future assignments, and SQL script is a text file which contains a sequence of SQL statements and SQL*plus commands. Typically, these files should recieve a .sql extension. You will be required to prepare and submit a number of SQL scripts for this lab. The Datasets Starting with this lab, and for most of the remaining labs in the course you will be working with several datasets created specifically for this course. These datasets are not large, but they are sufficiently diverse in content, scope and structure. All datasets are available from the course web page: 1 http://www.csc.calpoly.edu/ ∼ dekhtyar/365-Fall2007 Each dataset comes with a README file, which contains the exact spec- ifications of all data files included in the dataset, and briefly explains the meaning of the dataset. Before starting your work on a dataset, please study carefully the README file and make sure you understand the structure of the dataset! All data files in each dataset are stored in the CSV (comma-separated values) format. All text values are enclosed in single quotes. All dates are given in default Oracle’s format. A .zip file for each dataset is avilable. Brief descriptions of each of the course datasets is given below. CSU dataset. Type: multidimensional statistical data. This dataset con- tains various statistics about the California State University system. Historic information, such as annual enrollments and graduations is included, as well as information about enrollments by discipline at all campuses in a single year, and information about faculty lines and campus fees. CARS dataset. Type: normalized 1 dataset. This database stores infor- mation about the properties (such as number of cylinders, milage per gallon, engine displacement, etc) for over 400 domestic and import cars produced between 1970 and 1982. In formation is split into sev- eral files: starting with lists of continents and countries, going onto the lists of automakers and the models and makes they were producing....
View Full Document
This note was uploaded on 05/19/2008 for the course CSC 365 taught by Professor Dekhtyar during the Spring '08 term at Cal Poly.
- Spring '08