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 Practices Seen of Travel Agencies

Essay regarding Practices Seen of Travel Agencies

" Techniques Observed of Travel Organizations providing superior assistance to community and foreign clients in Competence, and Compliance Levels” Palon, Wildence Enzo Asis Edora, Czarina Mae Atienza…...

Read
 Essay about Selling Pirated CD’s and DVD’s

Essay about Selling Pirated CD’s and DVD’s

п»їINTRODUCTION BACKGROUND OF THE EXAMINE The analysts chosen theme is all about the entire ban of selling against the law CD's and DVD's in Quiapo, Manila. Despite powerful government…...

Read