Submitted by: Submitted by muhoilya
Views: 273
Words: 356
Pages: 2
Category: Science and Technology
Date Submitted: 01/26/2013 10:57 PM
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...