USE [KudlerFineFoods2] 
GO
CREATE TABLE JobTitle
(
JobTitle INT PRIMARY KEY NOT NULL,
EmployerInformationReport varchar(2000) NOT NULL,
JobDescription varchar(2000) NOT NULL,
ExemptOrNonExemptStatus varchar(25) NOT NULL,
)
GO
CREATE TABLE Employee
(
EmployeeID INT PRIMARY KEY NOT NULL,
LastName varchar(100) NOT NULL,
FirstName varchar(100) NOT NULL,
Address varchar(25) NULL,
City varchar(25) NULL,
State char(2) NULL,
TelephoneAreaCode smallint NULL,
TelephoneNumber int NULL,
EmployeeInformationReport varchar(250) NULL,
HireDate date NULL,
Salary money NULL,
Gender char(1) NOT NULL,
Age smallint NULL,
JobTitle INT FOREIGN KEY REFERENCES JobTitle(JobTitle)
)
GO

INSERT INTO Employee (LastName ,FirstName,....)
VALUES...

....
INSERT INTO JobTitle(jobTitle,...)
VALUES....

.....

DECLARE @JobTitleID int

INSERT INTO JobTitle 
VALUES('Bagger', 'Sales Workers', 'Places customer orders in bags. Performs carryout duties for customers.', 'Exempt')

SET @JobTitleID =SCOPE_IDENTITY()

INSERT INTO Employee 
VALUES (1,'McMullen', 'Eric', '763 Church St.', 'Lemon Grove', 'Ca', '619', '5550123', 'Sales Workers', '6/1/2002', '48,000', 'M', '26', @JobTitleID)

CREATE TABLE JobTitle
(
JobID int PRIMARY KEY NOT NULL,
JobTitle varchar(100) NOT NULL,
EmployerInformationReport varchar(2000) NOT NULL,
JobDescription varchar(2000) NOT NULL,
ExemptOrNonExemptStatus varchar(25) NOT NULL
)

GO

INSERT INTO JobTitle(JobID,JobTitle,EmployerInformationReport,JobDescription,ExemptOrNonExemptStatus)
VALUES (1,'Accounting Clerk','Office/Clerical','Computes, classifies, records, and verifies numerical data for use in maintaining accounting records.','Exempt'),
(2,'Assistant Manager','Officials & Managers','Supervises and coordinates activities of workers in department of food store. Assists store manager in daily operations of store.','Non Exempt'),
(3,'Bagger','Sales Workers','Places customer orders in bags. Performs carryout duties for customers.','Exempt'),
(4,'Cashier','Sales Workers','Operates cash register to itemize and total customer’s purchases in grocery store.','Exempt'),
(5,'Computer Support Specialist','Technician','Installs, modifies, and makes minor repairs to personal computer hardware and software systems, and provides technical assistance and training to system users.','Non Exempt'),
(6,'Director of Finance and Accounting','Officials & Managers','Plans and directs the finance and accounting activities for Kudler Fine Foods.','Non Exempt'),
(7,'Retail Assistant Bakery and Pastry','Operatives (Semi Skilled)','Plans and directs the finance and accounting activities for Kudler Fine Foods.','Exempt'),
(8,'Retail Assistant Butchers and Seafood Specialists','Operatives (Semi Skilled)','Plans and directs the finance and accounting activities for Kudler Fine Foods.','Exempt'),
(9,'Stocker','Office/Clerical','Stores, prices and restocks merchandise displays in store.','Exempt');
GO

CREATE TABLE Employee
(
EmployeeID INT PRIMARY KEY NOT NULL,
LastName varchar(100) NOT NULL,
FirstName varchar(100) NOT NULL,
Address varchar(100) NULL,
City varchar(25) NULL,
State char(2) NULL,
TelephoneAreaCode smallint NULL,
TelephoneNumber int NULL,
HireDate date NULL,
Salary money NULL,
Gender char(1) NOT NULL,
Age smallint NULL,
JobID int NOT NULL
FOREIGN KEY REFERENCES JobTitle(JobID)
)
GO
INSERT INTO Employee (EmployeeID,LastName,FirstName,Address,City,State,TelephoneAreaCode,TelephoneNumber,HireDate,Salary,Gender,Age,JobID)
VALUES (1001,'McMullen','Eric','763 Church St.','Lemon Grove','Ca',619,5550123,'6/1/2002', '48,000', 'M', 26,1),
(1002,'Slentz','Raj','123 Torrie Dr.','North Clairmont','Ca',619,5550123,'6/1/2002','48,000','M',34,2),
(1003,'Broun','Erin','2045 Parkway Apt2B','Encinitas','Ca',760,5550100,'3/12/2003','10,530','F',24,3),
(1004,'Carpenter','Donald','927 Second St.','Encinitas','Ca',619,5550154,'11/1/2003','15,500','M',18,9),
(1005,'Esquivez','David','10983 N. Coast Hwy Apt. 902','Encinitas','Ca',760,5550108,'7/25/2003','18,500','M',25,8),
(1006,'Sharp','Nancy','10793 Montecino Rd.','Ramona','Ca',858,'5550135','7/12/2003','21,000','F',24,4);
GO

quote:

---

Originally posted by topconlacj

Hi,

I agreed with you. Any way, your points of view make me thinking about some thing for my project.

Pls try to keep posting. Tks and best regards

---