This preview shows pages 1–2. 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 3: One more dataset (dates and more) 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 Oracles 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. The Task You will be working with a new course dataset, MARATHON . The MARATHON dataset consists of a single CSV file documenting the performance of par- ticipants of a half-marathon race. The performance is tracked for the entire race, as well as within each gender/age category. The dataset is available for download from the course web page: http://www.csc.calpoly.edu/ dekhtyar You will have to perform the same three tasks as in Lab 2: build an Oracle database and insert data into it, perform some changes in the structure of the database, and produce some formatted output....
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