lab2.365 - Fall 2007 CSC/CPE 365 Database Systems Alexander...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
. . 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
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
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.
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern