CIS336_lab_3_Solutions

CIS336_lab_3_Solutions - Lab Solution A. Lab #3 B. Lab...

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

View Full Document Right Arrow Icon
A. Lab #3 B. Lab Type: Application Server Experimental C. Lab Title: Going from Logical to Physical Design D. Date Developed: 10/01/2004 Lab Developer/Campus: William McClure. DeVry Dallas Date Revised: Lab Reviser/Campus: E. Desired (Lab) Learning Outcome: After completing the lab, students should be able to successfully identify the processes required to develop a physical database schema to include valid table structures, constraints, and indices and be able to define the processes needed to populate the schema with data. F. Solution: /*********************************************** || CIS349 iOptimize lab #3 Solutions || First Created - October 2004 || || Solution based on the supporting documentation || given to students for this lab. || ************************************************/ --DROP STATEMENTS DROP TABLE ENROLLMENT; DROP TABLE COURSE_SECTION; DROP TABLE COURSE; DROP TABLE TERM; DROP TABLE STUDENT; DROP TABLE FACULTY; DROP TABLE LOCATION; --CREATE STATEMENTS CREATE TABLE LOCATION ( LOCID NUMBER(5) CONSTRAINT PK_LOCATION_LOCID PRIMARY KEY, BLDG_CODE VARCHAR2(10) NOT NULL, ROOM VARCHAR2(6) NOT NULL, CAPACITY NUMBER(5) ); CREATE TABLE FACULTY ( FID NUMBER(4) CONSTRAINT PK_FACULTY_FID PRIMARY KEY, Lab Solution
Background image of page 1

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

View Full DocumentRight Arrow Icon
FLNAME VARCHAR2(25) NOT NULL, FFNAME VARCHAR2(25) NOT NULL, FMI CHAR(1), LOCID NUMBER(5), FPHONE NUMBER(10), F_RANK VARCHAR2(4), F_PIN
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 06/24/2011.

Page1 / 4

CIS336_lab_3_Solutions - Lab Solution A. Lab #3 B. Lab...

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

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