ORACLE#2_Spool_CHEN_JASON

ORACLE#2_Spool_CHEN_JASON - - script to create part of...

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

View Full Document Right Arrow Icon
-- script to create part of NORTHWOODS database structure SQL> -- BMIS441 SQL> --File name: 2Case1.sql SQL> --created 9/11/2006 Jason Chen, Row:1 SQL> SQL> DROP TABLE enrollment CASCADE CONSTRAINTS; S Table dropped. T SQL> DROP TABLE course_section CASCADE CONSTRAINTS; S Table dropped. T SQL> DROP TABLE term CASCADE CONSTRAINTS; S Table dropped. T SQL> DROP TABLE course CASCADE CONSTRAINTS; S Table dropped. T SQL> DROP TABLE student CASCADE CONSTRAINTS; S Table dropped. T SQL> DROP TABLE faculty CASCADE CONSTRAINTS; S Table dropped. T SQL> DROP TABLE location CASCADE CONSTRAINTS; S Table dropped. T SQL> SQL> CREATE TABLE location 2 (loc_id NUMBER(6), 3 bldg_code VARCHAR2(10), 4 room VARCHAR2(6), 5 capacity NUMBER(5), 6 CONSTRAINT location_loc_id_pk PRIMARY KEY (loc_id)); Table created. T SQL> SQL> CREATE TABLE faculty 2 (f_id NUMBER(6), 3 f_last VARCHAR2(30), 4 f_first VARCHAR2(30), 5 f_mi CHAR(1), 6 loc_id NUMBER(5), 7 f_phone VARCHAR2(10), 8 f_rank VARCHAR2(9), 9 f_super NUMBER(6), 10
Background image of page 1

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

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

This note was uploaded on 03/26/2010 for the course ITS 26 taught by Professor Jack during the Spring '10 term at Staten Island.

Page1 / 3

ORACLE#2_Spool_CHEN_JASON - - script to create part of...

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