CREATE TABLE [dbo].[Regions]( [region_id] [int] NOT NULL, [region_name] [varchar](50) NOT NULL, CONSTRAINT [PK_Region_s] PRIMARY KEY CLUSTERED
(
[region_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Locations] Script Date: 12/02/2012 16:45:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Locations]( [location_id] [int] NOT NULL, [street_address] [varchar](50) NOT NULL, [postal_code] [varchar](50) NOT NULL, [city] [varchar](50) NOT NULL, [state_province] [varchar](50) NOT NULL, [country_id] [int] NOT NULL, CONSTRAINT [PK_Locations] PRIMARY KEY CLUSTERED
(
[location_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Jobs] Script Date: 12/02/2012 16:45:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Jobs]( [job_id] [int] NOT NULL, [job_title] [varchar](50) NOT NULL, [min_salary] [decimal](18, 0) NOT NULL, [max_salary] [decimal](18, 0) NOT NULL, CONSTRAINT [PK_Jobs] PRIMARY KEY CLUSTERED
(
[job_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Job_history] Script Date: 12/02/2012 16:45:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Job_history]( [employee_id] [int] NOT NULL, [start_date] [date] NOT NULL, [end_date] [date] NOT NULL, [job_id]