close

Pos-410 - Week 2 - Table Questions Sql Storage space Database -- Kudler Fine Foods

 Essay about Pos-410 -- Week a couple of - Stand Queries Sql Server Database - Kudler Fine Foods

Table Inquiries SQL Hardware Database -- Kudler Fine Foods

Week two

POS/410\

The spring, 09 2012

Create Repository

USE [master]

GO

/****** Object: Data source [Jeff Thompson Sr - POS 410 -- IA - KVO] Script Time: 03/27/2012 2009: 23: 56 ******/ PRODUCE DATABASE [Jeff Thompson Sr -- POS 410 - IA - KVO] ON PRIMARY ( NAME sama dengan N'Jeff Thompson Sr - POS 410 - IA - KVO', FILENAME = N'D: \MSSQL10_50. MSSQLSERVER\MSSQL\DATA\Jeff Thompson Sr -- POS 410 - IA - KVO. mdf', SIZE = 2048KB, MAXSIZE sama dengan UNLIMITED, FILEGROWTH = 1024KB ) LOGIN

( NAME = N'Jeff Thompson Sr -- POS 410 - IA - KVO_log', FILENAME = N'D: \MSSQL10_50. MSSQLSERVER\MSSQL\DATA\Jeff Thompson Sr - POS 410 - IA - KVO_log. ldf', SIZE = 1024KB, MAXSIZE = 2048GB, FILEGROWTH = 10%) GO

WORK WITH [master]

PROCEED

/****** Object: Database [Jeff Thompson Sr -- POS 410 - IA - KVO] Screenplay Date: 03/27/2012 09: 23: 56 ******/ CREATE DATABASES [Jeff Thompson Sr - POS 410 - IA -- KVO] ON MAIN ( TERM = N'Jeff Thompson Sr - DETRAS 410 -- IA - KVO', FILENAME = N'D: \MSSQL10_50. MSSQLSERVER\MSSQL\DATA\Jeff Thompson Sr - DETRAS 410 -- IA -- KVO. mdf', SIZE sama dengan 2048KB, MAXSIZE = UNRESTRICTED, FILEGROWTH = 1024KB ) LOG ON

( IDENTITY = N'Jeff Thompson Sr - DETRAS 410 - IA - KVO_log', FILENAME = N'D: \MSSQL10_50. MSSQLSERVER\MSSQL\DATA\Jeff Thompson Sr - POS 410 -- IA - KVO_log. ldf', SIZE sama dengan 1024KB, MAXSIZE = 2048GB, FILEGROWTH sama dengan 10%) MOVE

Create Staff Table/Columns

WORK WITH [Jeff Thompson Sr - DETRAS 410 - IA -- KVO]

GO

/****** Object: Table [dbo].[Employee] Script Particular date: 03/27/2012 12: 39: fifty-five ******/ ESTABLISHED ANSI_NULLS UPON

GO

ESTABLISHED QUOTED_IDENTIFIER IN

GO

GENERATE TABLE [dbo].[Employee](

[EmployeeID] [int] NOT REALLY NULL,

[LastName] [nvarchar](50) NULL,

[FirstName] [nvarchar](50) NULL,

[Address] [nvarchar](30) NULL,

[City] [nvarchar](30) NULL,

[State] [nvarchar](20) NULL,

[AreaCode] [nvarchar](20) NULL,

[TelephoneNumber] [nvarchar](20) NULL,

[EmployerInformationReportClassification] [nvarchar](max) NULL,

[HireDate] [date] NULL,

[Salary] [money] NULL,

[Gender] [nvarchar](10) NULL,

[Age] [nvarchar](5) NULL,

)

GO

USE [Jeff Thompson Sr - DETRAS 410 - IA - KVO]

GO

/****** Object: Stand [dbo].[Employee] Script Date: 03/27/2012 twelve: 39: 55 ******/ ARRANGED ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER IN

GO

PRODUCE TABLE [dbo].[Employee](

[EmployeeID] [int] CERTAINLY NOT NULL,

[LastName] [nvarchar](50) NULL,

[FirstName] [nvarchar](50) NULL,

[Address] [nvarchar](30) NULL,

[City] [nvarchar](30) NULL,

[State] [nvarchar](20) NULL,

[AreaCode] [nvarchar](20) NULL,

[TelephoneNumber] [nvarchar](20) NULL,

[EmployerInformationReportClassification] [nvarchar](max) NULL,

[HireDate] [date] NULL,

[Salary] [money] NULL,

[Gender] [nvarchar](10) NULL,

[Age] [nvarchar](5) NULL,

)

GO

Create Job Title Table/Columns

USE [Jeff Thompson Sr - DETRAS 410 - IA - KVO]

GO

/****** Object: Table [dbo].[JobTitle] Script Time: 03/27/2012 twelve: 35: goal ******/ ESTABLISHED ANSI_NULLS IN

GO

SET QUOTED_IDENTIFIER IN

GO

GENERATE TABLE [dbo].[JobTitle](

[JobTitleID] [int] CERTAINLY NOT NULL,

[JobTitleName] [nvarchar](50) NULL,

[JobDescription] [nvarchar](max) NULL,

[Exempt_Non_ExemptStatus] [nvarchar](10) NULL,

[EEO_1Classification] [nvarchar](50) NULL,

)

GO

USE [Jeff Thompson Sr -- POS 410 - IA - KVO]

GO

/****** Object: Table [dbo].[JobTitle] Software Date: 03/27/2012 10: 35: 03 ******/ SET ANSI_NULLS ON

GET

SET QUOTED_IDENTIFIER ON

PROCEED

CREATE TABLE [dbo].[JobTitle](

[JobTitleID] [int] NOT NULL,

[JobTitleName] [nvarchar](50) NULL,

[JobDescription] [nvarchar](max) NULL,

[Exempt_Non_ExemptStatus] [nvarchar](10) NULL,

[EEO_1Classification] [nvarchar](50) NULL,

)

GO

Employee and Job Title Tables/Relationships

CREATE STAND [dbo].[Employee](

[JobTitleID] [int] NULL,

RESTRICTION [PK_Employee] MAJOR KEY CLUSTERED

(

[EmployeeID] ASC

)WITH (PAD_INDEX = AWAY, STATISTICS_NORECOMPUTE sama dengan OFF, IGNORE_DUP_KEY = AWAY, ALLOW_ROW_LOCKS sama dengan ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) UPON [PRIMARY]

PROCEED

CREATE TABLE [dbo].[JobTitle](...

 Essay regarding Vegetarians vs . Meat Predators

Essay regarding Vegetarians vs . Meat Predators

Vegetarians versus meat predators According to Kathy Freston, the New You are able to Times bestselling author of " The Lean, Veganist, and Segment Wellness", vegans and vegans have substantially…...

Read
 Essay about Teen Pregnant state: Statistics, Causes, Prevention

Essay about Teen Pregnant state: Statistics, Causes, Prevention

п»їPregnancy remains more prevalent among older teens than younger kinds, with 69 percent of teen pregnancies occurring amongst 18- to 19-year-olds, in line with the report. More mature teens…...

Read