This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: NOT NULL, CUS_INITIAL CHAR(1), CUS_AREACODE CHAR(3) NOT NULL, CUS_PHONE CHAR(7) NOT NULL,); CREATE TABLE EMPLOYEE ( EMP_NUM CHAR(2) PRIMARY KEY, EMP_LNAME VARCHAR(15) NOT NULL, EMP_FNAME VARCHAR(15) NOT NULL, EMP_INITIAL CHAR(1), EMP_AREACODE CHAR(3) NOT NULL, EMP_PHONE CHAR(7) NOT NULL,); CREATE TABLE PRODUCT ( PROD_NUM VARCHAR(2) PRIMARY KEY, PROD_NAME VARCHAR(20) NOT NULL,); Lessons learned: To use intger instead of char for numbers INSERTING IN CASES insert into cases values ('000000000004','2008-01-015','2','2','02','9','SOFTWARE','Y'); select count(distinct case_num),emp_num from cases where case_solved = 'N' group by emp_num...
View Full Document
This note was uploaded on 04/22/2008 for the course ACC 320 taught by Professor Brucebradford during the Spring '08 term at Fairfield.
- Spring '08