Kudler Fine Foods Database

Create an SQL server database for the Kudler Fine Foods Virtual Organization.

USE [Kudler_Fine_Foods]

GO

CREATE TABLE [dbo].[Jb_Title](

[Jb_Id] [int] IDENTITY(1,1) NOT NULL,

[Jb_Title] [char](30) NOT NULL,

[Jb_Descript] [char](255) NOT NULL,

[Jb_Exempt] [bit] NOT NULL,

PRIMARY KEY (Jb_Id)

)

GO

CREATE TABLE [dbo].[Employees](

[Emp_Id] [int] IDENTITY(1,1) NOT NULL,

[L_Name] [char](10) NOT NULL,

[F_Name] [char](10) NOT NULL,

[Addr] [text] NOT NULL,

[Cty] [text] NOT NULL,

[Sta] [char](2) NOT NULL,

[Area_Cd] [numeric](18, 0) NOT NULL,

[Tele] [numeric](18, 0) NOT NULL,

[Hire_Dt] [datetime] NOT NULL,

[Sal] [money] NOT NULL,

[M_F] [char](1) NOT NULL,

[Age_Of] [int] NOT NULL,

[Jb_Id] [int] NOT NULL,

PRIMARY KEY (Emp_Id),

FOREIGN KEY (Jb_Id)

REFERENCES Jb_Title(Jb_Id)

)

GO

INSERT INTO [dbo].[Jb_Title]

([Jb_TITLE]

,[Jb_Descript]

,[Jb_Exempt])

VALUES

('Accounting Clerk','Clerk','False'),('Assistant Manager','Manager','True'), ('Bagger','Bagger','False'),

('Cashier','Cashier','False'), ('Computer Support Specialist','Specialist','True'),('Director of Finance and Acc','Director','False'),

('Retail Assistant Bakery','Retail Assistant Bakery','True'),('Retail Assistant Butcher','Retail Assistant Butcher','True'),('Stocker','Stocker','False'),

('Sales Workers','Sales Workers','False')

GO

INSERT INTO [dbo].[Employees]

([L_Name]

,[F_Name]

,[Addr]

,[Cty]

,[Sta]

,[Area_Cd]

,[Tele]

,[Hire_Dt]

,[Sal]

,[M_F]

,[Age_Of]

,[Jb_Id])

VALUES

('Carpenter ','Donald','927 Second St','Ecinitas','CA','619','5550154','2003-10-15 00:00:00.000','15000.0000','M','18','5'),

('Edelman','Glen','175 Bishops Ln','La Jolla','CA','619','5550199','2003-09-15 00:00:00.000','21500.0000','M','64','14'),

('Esquives','David','10983 N. Coast Hwy Apt 902','Encinitas','CA','760','5550108','2003-07-25 00:00:00.000','18500.0000','M','25','5'),

('McMullen','Eric','763 Church St','Lemon Grove','CA','619','5550133','2002-10-01...