BuslerLAB3

BuslerLAB3 - IST 210 Lab #3 Chelsea Busler 06/21/11 1....

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

View Full Document Right Arrow Icon
IST 210 Lab #3 Chelsea Busler 06/21/11 1. Create the five tables. CREATE TABLE customer ( CustomerNo Numeric ( 6 )NOT NULL, CustomerName Varchar ( 30 ), City Varchar ( 30 ), State Varchar ( 2 ), Region_id Char ( 6 )); Command(s) completed successfully. CREATE TABLE region ( Region_id Char ( 6 )NOT NULL, Region_desc Varchar ( 20 )); Command(s) completed successfully. CREATE TABLE OrderLine ( ProductID Varchar ( 12 )NOT NULL, OrderNo Numeric ( 10 )NOT NULL, Qty Numeric ( 8 ), UnitPrice Numeric ( 8 , 2 ), ShipDate DateTime ); Command(s) completed successfully. CREATE TABLE Product ( ProductID Varchar ( 12 )NOT NULL, Description Varchar ( 20 ), ListPrice Numeric ( 8 , 2 )); Command(s) completed successfully. CREATE TABLE Orders ( OrderNo Numeric ( 10 )NOT NULL, CustomerNo Numeric ( 6 ), OrderDate DateTime ); Command(s) completed successfully. 2. Alter the tables to include the primary and foreign keys. ALTER
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 / 3

BuslerLAB3 - IST 210 Lab #3 Chelsea Busler 06/21/11 1....

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