Homework_09 - Spring2010:ISAM5331/ACCT5333 Homework...

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

View Full Document Right Arrow Icon
Spring 2010: ISAM 5331 / ACCT 5333 Homework Assignment 09 Assignment Details: 1. Refer to your solution for Homework 8 for the ERD for the following: 2. Create a SQL script that implements your extension to the STU Database: Hint:  Use the studb_shema_install.sql script file from Homework 3 as an example. a. DDL Statements: i. Include all CREATE TABLE statements required to create the new tables ii. Include all diagramed constraints:  Primary keys, Foreign, keys, not null, check iii. Include all ALTER TABLE statements to modify existing STU tables 1. Adding/Removing columns 2. Adding/Removing constraints create table Instructor ( InstructorID number primary key, FirstName varchar2(20) not null, LastName varchar2(20) not null) / create table Term ( TermID number primary key, TermName varchar2(20) not null,
Background image of page 1

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

View Full DocumentRight Arrow Icon
Spring 2010: ISAM 5331 / ACCT 5333 BeginDate date not null, EndDate date not null) / create table Class ( ClassID number primary key, ClassName varchar2(20) not null) / create table Class_Instructor ( InstructorID references Instructor,
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 note was uploaded on 10/09/2010 for the course MIS 5339 taught by Professor Gercek,g during the Spring '10 term at UH Clear Lake.

Page1 / 5

Homework_09 - Spring2010:ISAM5331/ACCT5333 Homework...

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