WebCT-chapter03sols-REVISED

WebCT-chapter03sols-REVISED - Answers to Chapter 3 Problems...

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

View Full Document Right Arrow Icon
1. The CREATE TABLE statement solution uses the standard SQL:2003 data types. Your DBMS may provide a different collection of data types. CREATE TABLE Customer ( CustNo CHAR(8), CustFirstName VARCHAR(20) NOT NULL, CustLastName VARCHAR(30) NOT NULL, CustCity VARCHAR(30), CustState CHAR(2), CustZip CHAR(10), CustBal currency, CONSTRAINT PKCustomer PRIMARY KEY (CustNo) ) CREATE TABLE Customer1 ( CustNo CHAR(8), CustFirstName VARCHAR(20) NOT NULL, CustLastName VARCHAR(30) NOT NULL, CustCity VARCHAR(30), CustState CHAR(2), CustZip CHAR(10), CustBal real, CONSTRAINT PKCustomer PRIMARY KEY (CustNo) ) 2. CREATE TABLE Employee ( EmpNo CHAR(8), EmpFirstName VARCHAR(20) NOT NULL, EmpLastName VARCHAR(30) NOT NULL, EmpPhone CHAR(15), EmpEMail VARCHAR(50) NOT NULL, CONSTRAINT PKEmployee PRIMARY KEY (EmpNo) ) 3. Note: I have changed the name of the table to Ordertbl-1 in order to differentiate the table created in this question from the table created in Q5. CREATE TABLE OrderTbl-1
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 / 4

WebCT-chapter03sols-REVISED - Answers to Chapter 3 Problems...

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