Comparission
Essay by 24 • November 9, 2010 • 331 Words (2 Pages) • 1,114 Views
SQL Server database for Kudler Fine Foods
Individual Assignment #1
Katrina Griffin
SQL FOR BUSINESS POS/410
University of Phoenix
Raj Kayathi
09/13/06
Flow Chart
CREATE TABLE employee
(
id_num VARCHAR(5),
l_name VARCHAR (15) NOT NULL,
f_name VARCHAR(15) NOT NULL,
address VARCHAR (25) NOT NULL,
city VARCHAR (10) NOT NULL,
state VARCHAR (2) NOT NULL,
tele_area_code INT NOT NULL,
tele_number INT NULL,
eeo_1_classification VARCHAR NOT NULL,
hire_date DATETIME NOT NULL,
salary DECIMAL (10,2),
gender CHAR(1) NOT NULL,
race CHAR(16) NOT NULL,
age INT NOT NULL,
PRIMARY KEY
);
GO
CREATE TABLE JOB_TITLE
(
eeo_1_classification VARCHAR (20) NOT NULL,
title_id INT PRIMARY KEY,
title VARCHAR (20) NOT NULL,
j_description VARCHAR (70) NOT NULL,
e_id_num VARCHAR (5) NULL,
exempt VARCHAR (4) NOT NULL
);
GO
INSERT INTO EMPLOYEE VALUES
'Edelman','Glenn',
'175 Bishops Lane',
'La_Jolla',
'CA',
'619',
'555-0199',
'Sales Workers',
'07-OCT-2003',
21500.75,
'M',
'Caucasian',
'64',084);
INSERT INTO EMPLOYEE VALUES
(
'82442','McMullen','Eric',
'763 Church St',
'Lemon Grove',
'CA',
'619',
'555-0135',
'Sales Workers',
'1-NOV-2002',
13500.00,
'M',
'Caucasian',
'20');
INSERT INTO EMPLOYEE VALUES
('83443','Slentz',
'Raj',
'123 Torrey Dr.',
'North Clairmont',
'CA',
'619',
'555-0123',
'Officials & Managers',
'1-JUN-2000',
48000.00,
'M',
'Asian',
'34');
INSERT INTO EMPLOYEE VALUES
('84444','Broun',
'Erin',
'2045 Parkway Apt.2B',
'Encinitas',
'CA',
'760',
'555-0100',
'Sales Workers',
'12-MAR-2003',
...
...