Resources
Data Access has been discontinued. Please refer to this page for more information.

Creating the SofiaCarRental Sample Database

In this task, you will create the schema for the SofiaCarRental_v2.2 database and will load data into the database. In order to do this, you use SQL Server Management Studio or SQL Server Management Studio Express to execute the SQL script. The resulting SofiaCarRental_v2.2 database is used as the relational data source in the rest quickstart.

To create the SofiaCarRental_v2.2 database

  1. On the File menu, point to New, and then Database Engine Query.
  2. In the Connect to Database Engine dialog box, type either localhost or the name of the local SQL Server instance, and then click Connect.
  3. Paste the following Transact-SQL script in the query window and then click Execute.
USE [master]
GO
IF EXISTS(SELECT * FROM sys.databases WHERE NAME = 'SofiaCarRental_v2.2')
BEGIN
DROP DATABASE [SofiaCarRental_v2.2]
END
GO
USE [master]
GO
CREATE DATABASE [SofiaCarRental_v2.2]
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
BEGIN
EXEC [SofiaCarRental_v2.2].[dbo].[sp_fulltext_database] @ACTION = 'enable'
END
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET ANSI_NULLS OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET ANSI_PADDING OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET ARITHABORT OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET AUTO_CLOSE ON
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET  ENABLE_BROKER
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET  READ_WRITE
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET RECOVERY SIMPLE
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET  MULTI_USER
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [SofiaCarRental_v2.2] SET DB_CHAINING OFF
GO
USE [SofiaCarRental_v2.2]
GO
/****** Object:  Table [dbo].[Employees]    Script Date: 02/08/2012 12:50:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Employees](
[EmployeeID] [INT] IDENTITY(1,1) NOT NULL,
[EmployeeNumber] [NCHAR](5) NULL,
[FirstName] [varchar](32) NULL,
[LastName] [varchar](32) NOT NULL,
[FullName]  AS (([LastName]+', ')+[FirstName]),
[Title] [varchar](80) NULL,
[HourlySalary] [smallmoney] NULL,
CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
[EmployeeID] 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
SET IDENTITY_INSERT [dbo].[Employees] ON
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (1, N'88798', N'James', N'Robinson', N'janitor', 2.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (2, N'78965', N'John', N'Martinez', N'sales man', 7.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (3, N'14856', N'Robert', N'Garcia', N'sales man', 7.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (4, N'65823', N'Michael', N'Thompson', N'sales man', 7.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (5, N'13526', N'William', N'Martin', N'sales man', 7.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (6, N'25558', N'David', N'Harris', N'sales man', 7.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (7, N'69856', N'Richard', N'White', N'sales man', 7.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (8, N'14785', N'Charles', N'Jackson', N'manager', 9.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (9, N'13689', N'Joseph', N'Thomas', N'driver', 5.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (10, N'10585', N'Thomas', N'Anderson', N'driver', 5.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (11, N'45896', N'Christopher', N'Taylor', N'driver', 5.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (12, N'36985', N'Daniel', N'Moore', N'supervisor', 11.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (13, N'18745', N'Paul', N'Wilson', N'dealer', 12.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (14, N'12563', N'Mark', N'Miller', N'dealer', 12.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (15, N'85963', N'Donald', N'Davis', N'janitor', 2.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (16, N'15368', N'George', N'Brown', N'janitor', 2.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (17, N'69853', N'Kenneth', N'Jones', N'QA', 15.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (18, N'25478', N'Steven', N'Williams', N'chairman', 55.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (19, N'15789', N'Edward', N'Johnson', N'driver', 5.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (20, N'87596', N'Brian', N'Smith', N'driver', 5.0000)
INSERT [dbo].[Employees] ([EmployeeID], [EmployeeNumber], [FirstName], [LastName], 
[Title], [HourlySalary]) 
VALUES (21, N'12126', N'Internet', N'Internet', N'Internet', 5.0000)
SET IDENTITY_INSERT [dbo].[Employees] OFF
/****** Object:  Table [dbo].[Customers]    Script Date: 02/08/2012 12:50:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Customers](
[CustomerID] [INT] IDENTITY(1,1) NOT NULL,
[DrvLicNumber] [varchar](50) NULL,
[FullName] [varchar](80) NULL,
[Address] [varchar](100) NOT NULL,
[Country] [varchar](100) NOT NULL,
[City] [varchar](50) NULL,
[State] [varchar](50) NULL,
[ZIPCode] [varchar](20) NULL,
CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED
(
[CustomerID] 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
SET IDENTITY_INSERT [dbo].[Customers] ON
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (1, N'240-573-885', N'John Wattson', N'4024 Locktar Drive', N'USA', 
N'Silver Spring', N'MD', N'20904')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (2, N'264-72-6663', N'Charles Calhoun', N'10630 Leila Rd #D4', N'USA', 
N'Alexandria', N'VA', N'22231')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (3, N'802-46-4006', N'Jeannine Pons', N'802 Mimosa Road NW', N'USA', 
N'Washington', N'DC', N'20006')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (4, N'264-72-6663', N'Charles Calhoun', N'10630 Leila Rd #D4', N'USA', 
N'Alexandria', N'VA', N'22231')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (5, N'386-32-3456', N'Jarmein Defoe', N'Historic Road 66', N'USA', 
N'Tuskegee', N'TS', N'34612')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (6, N'568-17-9875', N'James White', N'Minnehaha AND Hiawatha Avenue', 
N'USA', N'Trussville', N'TR', N'22114')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (7, N'288-14-5423', N'William King', N'889 Lake D4', N'USA', 
N'Southside', N'ST', N'20897')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (8, N'978-27-1145', N'Jeff Lewis', N'4451 Willow', N'USA', 
N'Smiths', N'SM', N'20999')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (9, N'879-13-7798', N'Ronald Young', N'4412 Mill', N'USA', 
N'Prichard', N'PR', N'22665')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (10, N'147-22-6663', N'Kevin Allen', N'19676 Lakeview', N'USA', 
N'Guntersville', N'GR', N'22566')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (11, N'725-12-3498', N'Joseph Harris', N'55878 Broadway', N'USA', 
N'Fort Payne', N'FP', N'22967')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (12, N'778-13-6871', N'Michael Smith', N'17896 Sycamore', N'USA', 
N'Craig-Tyler', N'CT', N'22643')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (13, N'123-56-3567', N'Thomas Wilson', N'57878 Hillcrest', N'USA', 
N'Attalla', N'AT', N'22123')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (14, N'546-61-1878', N'Anthony Moore', N'77485 Madison', N'USA', 
N'Birmingham', N'BR', N'22309')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (15, N'745-66-9863', N'George Martinez', N'68598 Taylor', N'USA', 
N'Chehalis', N'CH', N'22576')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (16, N'124-33-3568', N'Jason Baker', N'77748 Woodland', N'USA', 
N'Everett', N'EV', N'22138')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (17, N'665-38-8745', N'Mark Hernandez', N'11478 Dogwood', N'USA', 
N'Lake Stevens', N'LS', N'22265')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (18, N'453-32-8777', N'John Brown', N'88798 Spruce', N'USA', 
N'Spokane', N'SP', N'22731')
INSERT [dbo].[Customers] ([CustomerID], [DrvLicNumber], [FullName], [Address], 
[Country], [City], [State], [ZIPCode]) 
VALUES (19, N'489-89-1744', N'Whyne Rooney', N'74256 Franklin', N'USA', 
N'Washougal', N'WS', N'22311')
SET IDENTITY_INSERT [dbo].[Customers] OFF
/****** Object:  Table [dbo].[Categories]    Script Date: 02/08/2012 12:50:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Categories](
[CategoryID] [INT] IDENTITY(1,1) NOT NULL,
[CategoryName] [varchar](50) NOT NULL,
[ImageFileName] [varchar](256) NULL,
CONSTRAINT [PK_Categories] PRIMARY KEY CLUSTERED
(
[CategoryID] 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
SET IDENTITY_INSERT [dbo].[Categories] ON
INSERT [dbo].[Categories] ([CategoryID], [CategoryName], [ImageFileName]) 
VALUES (1, N'Hatchback', N'hatchback.png')
INSERT [dbo].[Categories] ([CategoryID], [CategoryName], [ImageFileName]) 
VALUES (2, N'Saloon', N'saloon.png')
INSERT [dbo].[Categories] ([CategoryID], [CategoryName], [ImageFileName]) 
VALUES (3, N'People Carrier', N'peoplecarrier.png')
INSERT [dbo].[Categories] ([CategoryID], [CategoryName], [ImageFileName]) 
VALUES (4, N'SUV', N'suv.png')
INSERT [dbo].[Categories] ([CategoryID], [CategoryName], [ImageFileName]) 
VALUES (5, N'Limousine', N'limousine.png')
SET IDENTITY_INSERT [dbo].[Categories] OFF
/****** Object:  Table [dbo].[RentalRates]    Script Date: 02/08/2012 12:50:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RentalRates](
[RentalRateID] [INT] IDENTITY(1,1) NOT NULL,
[CategoryID] [INT] NULL,
[Daily] [smallmoney] NULL,
[Weekly] [smallmoney] NULL,
[Monthly] [smallmoney] NULL,
CONSTRAINT [PK_RentalRates] PRIMARY KEY CLUSTERED
(
[RentalRateID] 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 IDENTITY_INSERT [dbo].[RentalRates] ON
INSERT [dbo].[RentalRates] ([RentalRateID], [CategoryID], [Daily], [Weekly], [Monthly]) 
VALUES (1, 2, 2.0000, 12.0000, 44.0000)
INSERT [dbo].[RentalRates] ([RentalRateID], [CategoryID], [Daily], [Weekly], [Monthly]) 
VALUES (2, 1, 1.0000, 6.0000, 22.0000)
INSERT [dbo].[RentalRates] ([RentalRateID], [CategoryID], [Daily], [Weekly], [Monthly]) 
VALUES (3, 4, 5.0000, 3.0000, 11.0000)
INSERT [dbo].[RentalRates] ([RentalRateID], [CategoryID], [Daily], [Weekly], [Monthly]) 
VALUES (4, 3, 1.0000, 9.0000, 33.0000)
INSERT [dbo].[RentalRates] ([RentalRateID], [CategoryID], [Daily], [Weekly], [Monthly]) 
VALUES (5, 5, 5.0000, 12.0000, 36.0000)
SET IDENTITY_INSERT [dbo].[RentalRates] OFF
/****** Object:  Table [dbo].[Cars]    Script Date: 02/08/2012 12:50:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Cars](
[CarID] [INT] IDENTITY(1,1) NOT NULL,
[TagNumber] [varchar](20) NOT NULL,
[Make] [varchar](50) NULL,
[Model] [varchar](50) NOT NULL,
[CarYear] [SMALLINT] NULL,
[CategoryID] [INT] NULL,
[Mp3Player] [BIT] NULL,
[DVDPlayer] [BIT] NULL,
[AirConditioner] [BIT] NULL,
[ABS] [BIT] NULL,
[ASR] [BIT] NULL,
[Navigation] [BIT] NULL,
[Available] [BIT] NULL,
[Latitude] [FLOAT] NULL,
[Longitude] [FLOAT] NULL,
[ImageFileName] [varchar](256) NULL,
[Rating] [DECIMAL](9, 2) NULL,
[NumberOfRatings] [INT] NULL,
CONSTRAINT [IX_Cars_TagNumber] UNIQUE ([TagNumber]),
CONSTRAINT [PK_Car] PRIMARY KEY CLUSTERED
(
[CarID] 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
SET IDENTITY_INSERT [dbo].[Cars] ON
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (1, N'TE 3445 IK', N'Opel', N'Corsa', 2004, 1, 1, 0, 1, 1, 0, 0, 1, 
42.697872, 23.321583, N'opel_corsa_2004.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (2, N'TE 2312 IK', N'Honda', N'Civic', 1993, 1, 1, 0, 0, 1, 0, 0, 1, 
48.139126, 11.580186, N'honda_civic_2006.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (3, N'TE 6645 IK', N'Hyundai', N'I30', 2008, 1, 0, 0, 0, 0, 0, 0, 1, 
48.873974, 2.324701, N'hyundai_i30_2008.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (4, N'TE 3455 IK', N'Audi', N'A3', 2003, 1, 1, 1, 1, 1, 0, 0, 0, 
48.873974, 2.324701, N'audi_a3_2003.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (5, N'TE 3789 IK', N'Mercedez', N'Aclass', 2007, 1, 1, 0, 1, 1, 0, 0, 1, 
48.201763, 16.379904, N'mercedesbenz_aclass.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (6, N'TE 3445 IM', N'Mercedez', N'Bclass', 2007, 1, 1, 0, 1, 1, 0, 0, 1, 
43.210134, 27.920162, N'mercedesbenz_bclass_lorinzer.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (7, N'TE 8934 IK', N'Alfaromeo', N'147', 2006, 1, 1, 1, 1, 0, 1, 1, 1, 
48.201763, 16.379904, N'alfaromeo_147_2006.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (8, N'TE 5484 IK', N'Volvo', N'c30', 2009, 1, 1, 0, 1, 1, 0, 0, 1, 
48.201763, 16.379904, N'volvo_c30_2009.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (9, N'TE 9876 IK', N'Lancia', N'Ypsilon', 2006, 1, 1, 0, 1, 1, 0, 0, 1, 
48.873974, 2.324701, N'lancia_ypsilon_2006.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (10, N'TE 1254 IK', N'Honda', N'CR-Z', 2010, 1, 1, 0, 0, 1, 0, 0, 1, 
49.177862, -0.379726, N'honda_cr-z_2010.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (11, N'TE 5317 IK', N'Renault', N'Laguna', 2008, 1, 1, 0, 1, 1, 0, 0, 1, 
43.210134, 27.920162, N'renault_laguna_2008.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (12, N'TE 4567 IK', N'VW', N'Golf', 2008, 1, 1, 1, 1, 1, 1, 1, 1, 
42.697872, 23.321583, N'vw_golf_2008.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (13, N'TE 7856 IK', N'Volvo', N'S60', 2010, 2, 1, 0, 1, 1, 0, 0, 1, 
48.139126, 11.580186, N'volvo_s60_2010.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (14, N'TE 3454 IK', N'Audi', N'A4', 2002, 2, 1, 0, 1, 1, 1, 1, 0, 
48.873974, 2.324701, N'audi_a4_2002.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (15, N'TE 5434 IK', N'BMW', N'535d', 2006, 2, 1, 1, 1, 1, 1, 1, 1, 
48.873974, 2.324701, N'bmw_535d_2005.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (16, N'TE 7656 IK', N'BMW', N'320d', 2006, 2, 1, 1, 0, 0, 1, 1, 1, 
48.201763, 16.379904, N'bmw_320d_2006.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (17, N'TE 1221 IK', N'VW', N'Passat', 2005, 2, 0, 0, 0, 0, 0, 0, 1, 
43.210134, 27.920162, N'vw_passat_2005.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (18, N'TE 2232 IK', N'Peugeot', N'407', 2006, 2, 1, 0, 1, 1, 0, 0, 1, 
48.201763, 16.379904, N'peugeot_407_2006.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (20, N'TE 3498 IK', N'Honda', N'Accord', 2008, 2, 1, 0, 0, 1, 0, 0, 1, 
48.873974, 2.324701, N'honda_accord_2008.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (21, N'TE 9009 IK', N'Alfaromeo', N'159', 2008, 2, 0, 0, 0, 1, 1, 1, 1, 
49.177862, -0.379726, N'alfaromeo_159_2008.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (22, N'TE 4132 IK', N'Toyota', N'Corolla', 2007, 3, 1, 0, 1, 1, 0, 0, 1, 
43.210134, 27.920162, N'toyota_corolla_spacio_2007.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (23, N'TE 9383 IK', N'Audi', N'Q7', 2007, 4, 1, 0, 1, 1, 0, 0, 1, 
42.697872, 23.321583, N'audi_Q7_2007.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (24, N'TE 2010 IK', N'Hyundai', N'Santafe', 2007, 4, 1, 0, 1, 1, 0, 0, 1, 
48.139126, 11.580186, N'hyundai_santafe_2007.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (25, N'TE 1992 IK', N'Nissan', N'Qashqai', 2007, 4, 1, 0, 1, 1, 0, 0, 1, 
48.873974, 2.324701, N'nissan_qashqai_2008.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (26, N'TE 6677 IK', N'Toyota', N'Landcruiser', 2005, 4, 1, 0, 1, 1, 0, 0, 1, 
48.873974, 2.324701, N'toyota_landcruiser100_2005.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (27, N'TE 6987 IK', N'Volvo', N'xc90', 2006, 4, 1, 0, 1, 1, 0, 0, 1, 
48.201763, 16.379904, N'volvo_xc90_2006.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (28, N'TE 1766 IK', N'VW', N'Touareg', 2010, 4, 1, 0, 1, 1, 0, 0, 1, 
43.210134, 27.920162, N'vw_touareg_2010.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (29, N'TE 9880 IK', N'VW', N'Touran', 2010, 3, 1, 0, 1, 1, 0, 0, 1, 
48.201763, 16.379904, N'vw_touran_2008.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (31, N'TE 0001 IK', N'Nissan', N'Almera', 2001, 2, 1, 0, 1, 1, 0, 0, 1, 
48.873974, 2.324701, N'nissan_almera_2001.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (32, N'TE 1000 IK', N'BMW', N'x3', 2007, 4, 1, 1, 1, 1, 1, 1, 1, 
49.177862, -0.379726, N'bmw_x3_2007.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (33, N'TE 6666 IK', N'Lincoln', N'TownCar', 2006, 5, 1, 1, 1, 1, 1, 1, 1, 
43.210134, 27.920162, N'lincoln_towncar_2006.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (36, N'TE 5656 IK', N'Lincoln', N'TownCar', 2010, 5, 1, 0, 0, 1, 0, 0, 1, 
48.873974, 2.324701, N'lincoln_2011towncar_2010.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (37, N'TE 8778 IK', N'Mitsubishi', N'Lancer', 2008, 2, 1, 0, 0, 1, 0, 0, 1, 
48.873974, 2.324701, N'mitsubishi_lancer_2008.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (38, N'TE 5555 IK', N'Opel', N'Vectra', 2008, 2, 1, 0, 1, 1, 0, 0, 1, 
48.201763, 16.379904, N'opel_vectra_2008.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (39, N'TE 8989 IK', N'Toyota', N'Avensis', 2008, 2, 1, 0, 1, 1, 0, 0, 1, 
43.210134, 27.920162, N'toyota_avensis_2008.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (40, N'TE 0000 IK', N'Chrysler', N'300', 2006, 5, 1, 0, 1, 1, 0, 0, 1, 
48.201763, 16.379904, N'chrysler_300_2006.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (41, N'TE 0290 IK', N'Mercedez', N'S600', 2009, 5, 1, 0, 1, 1, 0, 0, 1, 
48.201763, 16.379904, N'mercedesbenz_S600_pullman_guard.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (42, N'TE 4554 IK', N'VW', N'Phaeton', 2005, 5, 1, 0, 1, 1, 0, 0, 1, 
48.873974, 2.324701, N'vw_phaeton_2005.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (43, N'TE 4288 IK', N'Citroen', N'Evasion', 1998, 3, 1, 0, 1, 1, 0, 0, 1, 
49.177862, -0.379726, N'citroen_evasion_1998.jpg', NULL, 0)
INSERT [dbo].[Cars] ([CarID], [TagNumber], [Make], [Model], [CarYear], [CategoryID], 
[Mp3Player], [DVDPlayer], [AirConditioner], [ABS], [ASR], [Navigation], [Available], 
[Latitude], [Longitude], [ImageFileName], [Rating], [NumberOfRatings]) 
VALUES (44, N'TE 7227 IK', N'Ford', N'Galaxy', 1998, 3, 1, 0, 1, 1, 0, 0, 1, 
43.210134, 27.920162, N'ford_galaxy_2008.jpg', NULL, 0)
SET IDENTITY_INSERT [dbo].[Cars] OFF
/****** Object:  Table [dbo].[RentalOrders]    Script Date: 02/08/2012 12:50:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[RentalOrders](
[RentalOrderID] [INT] IDENTITY(1,1) NOT NULL,
[DateProcessed] [datetime] NULL,
[EmployeeID] [INT] NOT NULL,
[CustomerID] [INT] NOT NULL,
[CarID] [INT] NOT NULL,
[TankLevel] [varchar](40) NULL,
[MileageStart] [INT] NULL,
[MileageEnd] [INT] NULL,
[RentStartDate] [datetime] NOT NULL,
[RentEndDate] [datetime] NOT NULL,
[Days]  AS (CONVERT([INT],[RentEndDate]-[RentStartDate],(0))),
[RateApplied] [money] NULL,
[OrderTotal]  AS (CONVERT([money],[RateApplied]*CONVERT([INT],
[RentEndDate]-[RentStartDate],(0)),(0))),
[OrderStatus] [varchar](50) NULL,
CONSTRAINT [PK_RentalOrder] PRIMARY KEY CLUSTERED
(
[RentalOrderID] 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
SET IDENTITY_INSERT [dbo].[RentalOrders] ON
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (1, CAST(0x000095E400000000 AS DateTime), 1, 1, 1, N'FULL', 100000, 102000, 
CAST(0x000095E500000000 AS DateTime), CAST(0x000095EA00000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (2, CAST(0x00009B7200000000 AS DateTime), 2, 2, 2, N'FULL', 3500, 3700, 
CAST(0x0000973300000000 AS DateTime), CAST(0x00009B7F00000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (3, CAST(0x000095B100000000 AS DateTime), 3, 3, 3, N'FULL', 310000, 310200, 
CAST(0x000095E500000000 AS DateTime), CAST(0x000095EA00000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (4, CAST(0x0000944800000000 AS DateTime), 4, 4, 4, N'FULL', 250000, 250000, 
CAST(0x0000951A00000000 AS DateTime), CAST(0x0000952200000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (5, CAST(0x0000989500000000 AS DateTime), 5, 5, 5, N'FULL', 250000, 260000, 
CAST(0x000097D500000000 AS DateTime), CAST(0x000097DB00000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (6, CAST(0x00009A6200000000 AS DateTime), 5, 5, 5, N'FULL', 100000, 100012, 
CAST(0x000095E500000000 AS DateTime), CAST(0x000095E800000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (7, CAST(0x00009B5200000000 AS DateTime), 5, 5, 5, N'FULL', 1000, 1050, 
CAST(0x000095E500000000 AS DateTime), CAST(0x000095E800000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (8, CAST(0x00009B3300000000 AS DateTime), 6, 6, 6, N'FULL', 1000, 1070, 
CAST(0x000095E500000000 AS DateTime), CAST(0x000095E800000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (9, CAST(0x00009B1500000000 AS DateTime), 7, 7, 7, N'FULL', 1000, 1560, 
CAST(0x000095E500000000 AS DateTime), CAST(0x000095E800000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (10, CAST(0x00009AF600000000 AS DateTime), 8, 8, 8, N'FULL', 1000, 1300, 
CAST(0x000095E500000000 AS DateTime), CAST(0x000095E800000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (11, CAST(0x00009AD700000000 AS DateTime), 9, 9, 9, N'FULL', 1000, 1287, 
CAST(0x000095E500000000 AS DateTime), CAST(0x000095E800000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (12, CAST(0x00009AB900000000 AS DateTime), 10, 10, 10, N'FULL', 1000, 1388, 
CAST(0x000095E500000000 AS DateTime), CAST(0x000095E800000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (13, CAST(0x00009A9800000000 AS DateTime), 11, 11, 11, N'FULL', 1000, 1458, 
CAST(0x000095E500000000 AS DateTime), CAST(0x000095E800000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (14, CAST(0x00009A8300000000 AS DateTime), 12, 12, 12, N'FULL', 1000, 1658, 
CAST(0x000095E500000000 AS DateTime), CAST(0x000095E800000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (15, CAST(0x00009A5F00000000 AS DateTime), 13, 13, 13, N'FULL', 1000, 1458, 
CAST(0x000095E500000000 AS DateTime), CAST(0x000095E800000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (16, CAST(0x00009A4D00000000 AS DateTime), 14, 14, 14, N'FULL', 1000, 1689, 
CAST(0x000095E500000000 AS DateTime), CAST(0x000095E800000000 AS DateTime), 
1.0000, N'completed')
INSERT [dbo].[RentalOrders] ([RentalOrderID], [DateProcessed], [EmployeeID], 
[CustomerID], [CarID], [TankLevel], [MileageStart], [MileageEnd], [RentStartDate], 
[RentEndDate], [RateApplied], [OrderStatus]) 
VALUES (17, CAST(0x00009A2100000000 AS DateTime), 15, 15, 15, N'FULL', 1000, 1333, 
CAST(0x000095E500000000 AS DateTime), CAST(0x000095E800000000 AS DateTime), 
1.0000, N'completed')
SET IDENTITY_INSERT [dbo].[RentalOrders] OFF
/****** Object:  Default [DF__Categorie__Image__0425A276]    Script Date: 02/08/2012 12:50:54 ******/
ALTER TABLE [dbo].[Categories] ADD  DEFAULT (NULL) FOR [ImageFileName]
GO
/****** Object:  Default [DF__Cars__Latitude__7D78A4E7]    Script Date: 02/08/2012 12:50:54 ******/
ALTER TABLE [dbo].[Cars] ADD  DEFAULT (NULL) FOR [Latitude]
GO
/****** Object:  Default [DF__Cars__Longitude__7E6CC920]    Script Date: 02/08/2012 12:50:54 ******/
ALTER TABLE [dbo].[Cars] ADD  DEFAULT (NULL) FOR [Longitude]
GO
/****** Object:  Default [DF__Cars__ImageFileN__7F60ED59]    Script Date: 02/08/2012 12:50:54 ******/
ALTER TABLE [dbo].[Cars] ADD  DEFAULT (NULL) FOR [ImageFileName]
GO
/****** Object:  Default [DF__Cars__Rating__00551192]    Script Date: 02/08/2012 12:50:54 ******/
ALTER TABLE [dbo].[Cars] ADD  DEFAULT (NULL) FOR [Rating]
GO
/****** Object:  Default [DF__Cars__NumberOfRa__014935CB]    Script Date: 02/08/2012 12:50:54 ******/
ALTER TABLE [dbo].[Cars] ADD  DEFAULT ((0)) FOR [NumberOfRatings]
GO
/****** Object:  ForeignKey [FK_RentalRateCategory]    Script Date: 02/08/2012 12:50:54 ******/
ALTER TABLE [dbo].[RentalRates]  WITH CHECK 
ADD  CONSTRAINT [FK_RentalRateCategory] FOREIGN KEY([CategoryID])
REFERENCES [dbo].[Categories] ([CategoryID])
GO
ALTER TABLE [dbo].[RentalRates] CHECK CONSTRAINT [FK_RentalRateCategory]
GO
/****** Object:  ForeignKey [FK_Categories]    Script Date: 02/08/2012 12:50:54 ******/
ALTER TABLE [dbo].[Cars]  WITH CHECK 
ADD  CONSTRAINT [FK_Categories] FOREIGN KEY([CategoryID])
REFERENCES [dbo].[Categories] ([CategoryID])
GO
ALTER TABLE [dbo].[Cars] CHECK CONSTRAINT [FK_Categories]
GO
/****** Object:  ForeignKey [FK_Cars]    Script Date: 02/08/2012 12:50:54 ******/
ALTER TABLE [dbo].[RentalOrders]  WITH CHECK 
ADD  CONSTRAINT [FK_Cars] FOREIGN KEY([CarID])
REFERENCES [dbo].[Cars] ([CarID])
GO
ALTER TABLE [dbo].[RentalOrders] CHECK CONSTRAINT [FK_Cars]
GO
/****** Object:  ForeignKey [FK_Customers]    Script Date: 02/08/2012 12:50:54 ******/
ALTER TABLE [dbo].[RentalOrders]  WITH CHECK 
ADD  CONSTRAINT [FK_Customers] FOREIGN KEY([CustomerID])
REFERENCES [dbo].[Customers] ([CustomerID])
GO
ALTER TABLE [dbo].[RentalOrders] CHECK CONSTRAINT [FK_Customers]
GO
/****** Object:  ForeignKey [FK_Employees]    Script Date: 02/08/2012 12:50:54 ******/
ALTER TABLE [dbo].[RentalOrders]  WITH CHECK 
ADD  CONSTRAINT [FK_Employees] FOREIGN KEY([EmployeeID])
REFERENCES [dbo].[Employees] ([EmployeeID])
GO
ALTER TABLE [dbo].[RentalOrders] CHECK CONSTRAINT [FK_Employees]
GO
/****** Object:  StoredProcedure [dbo].[GetProfitFromCar]    Script Date: 1/18/2013 15:56:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[GetProfitFromCar]
@CarID INT
AS
BEGIN
SET NOCOUNT ON;
SELECT SUM(OrderTotal) AS Profit FROM dbo.RentalOrders
WHERE CarID = @CarID
END
GO
/****** Object:  StoredProcedure [dbo].[GetRentalOrdersForCar]    Script Date: 1/18/2013 16:01:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[GetRentalOrdersForCar]
@CarID INT
AS
BEGIN
SET NOCOUNT ON;
SELECT * FROM dbo.RentalOrders
WHERE CarID = @CarID
END
GO

To review the tables in the SofiaCarRental_v2.2 database:

  1. On the File menu, click Connect Object Explorer.
  2. In the Connect to Database Engine dialog box, type either localhost or the name of the local SQL Server instance, and then click Connect.
  3. In the Object Explorer window, expand the node for the connected instance, then expand Databases, expand SofiaCarRental_v2.2, expand Tables, and review the list of table objects in the database.