Essays24.com - Term Papers and Free Essays
Search

Comparission

Essay by 24  •  November 9, 2010  •  331 Words (2 Pages)  •  504 Views

Essay Preview: Comparission

Report this essay
Page 1 of 2

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',

...

...

Download as:   txt (3.5 Kb)   pdf (77.3 Kb)   docx (10.5 Kb)  
Continue for 1 more page »
Only available on Essays24.com
Citation Generator

(2010, 11). Comparission. Essays24.com. Retrieved 11, 2010, from https://www.essays24.com/essay/Comparission/9712.html

"Comparission" Essays24.com. 11 2010. 2010. 11 2010 <https://www.essays24.com/essay/Comparission/9712.html>.

"Comparission." Essays24.com. Essays24.com, 11 2010. Web. 11 2010. <https://www.essays24.com/essay/Comparission/9712.html>.

"Comparission." Essays24.com. 11, 2010. Accessed 11, 2010. https://www.essays24.com/essay/Comparission/9712.html.