Homework_09 - Spring 2010: ISAM 5331 / ACCT 5333 Homework...

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

View Full Document Right Arrow Icon
Spring 2010: ISAM 5331 / ACCT 5333 Copyright © 2010 Richard Meyer. All rights reserved. This material may not be reproduced, displayed, modified or distributed without the express prior written permissions of the copyright holder. 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 b. DML Statements: i. Include INSERT statements that supply new data to the new tables: 1. You should add at least one term/semester: a. Example: Spring 2010 2. You should add at least one course to the courses table:
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.

Page1 / 2

Homework_09 - Spring 2010: ISAM 5331 / ACCT 5333 Homework...

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