index_003 - CS348: Project #2 Overview In this project,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CS348: Project #2 Overview In this project, you'll create a simple Oracle database & perform some common database operations. The schema and sample data of the database are provided. The project should be done and submitted in podn-n workstations. Information about getting your Oracle account and general initial configuration is available in: http://www.cs.purdue.edu/oracle Due date : Oct 13, 2011 @11:59 pm Step 1: Create the tables The schema for the database is as follows: 1. STUDENT(*snum: integer, sname: string, major: string, slevel: string, age: integer) 2. CLASS(*name: string, meets_at: date, room: string, fid: integer) 3. ENROLLED(*snum:integer, *cname: string ) 4. FACULTY(*fid: integer, fname: string, deptid: integer) 5. DEPARTMENT (*deptid: integer,dname: string, Location:string) The fields with '*' are primary key. The meaning of these relations is straightforward: STUDENT contains one record per student identified by snum; CLASS contains one record per class uniquely defined by its name; the fid field of class gives the instructor of the class; ENROLLED contains a record for each student enrolled in each course; and FACULTY contains one record per faculty member uniquely identified by the fid. DEPARTMENT contains one record per department....
View Full Document

This note was uploaded on 02/23/2012 for the course CS 348 taught by Professor Staff during the Fall '08 term at Purdue University-West Lafayette.

Page1 / 4

index_003 - CS348: Project #2 Overview In this project,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online