For this Milestone you will creating and populating a database in the MS SQL Server you installed during Milestone 2.   In order to upload the needed scripts to your Amazon AWS instance  You will also need to download the zip file that contains the two SQL Scripts we will be using to create the database and import the data. This file is listed below  Once you have this file downloaded you will need to follow the instructions in the linked document to complete the milestone.   Remember to keep screenshots and notes on everything and update you final document 

sample-data.sql
SET IDENTITY_INSERT Supplier ON
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(1,’Exotic Liquids’,’Charlotte Cooper’,’London’,’UK’,'(171) 555-2222′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(2,’New Orleans Cajun Delights’,’Shelley Burke’,’New Orleans’,’USA’,'(100) 555-4822′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(3,’Grandma Kelly”s Homestead’,’Regina Murphy’,’Ann Arbor’,’USA’,'(313) 555-5735′,'(313) 555-3349′)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(4,’Tokyo Traders’,’Yoshi Nagase’,’Tokyo’,’Japan’,'(03) 3555-5011′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(5,’Cooperativa de Quesos ”Las Cabras”’,’Antonio del Valle Saavedra’,’Oviedo’,’Spain’,'(98) 598 76 54′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(6,’Mayumi”s’,’Mayumi Ohno’,’Osaka’,’Japan’,'(06) 431-7877′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(7,’Pavlova, Ltd.’,’Ian Devling’,’Melbourne’,’Australia’,'(03) 444-2343′,'(03) 444-6588′)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(8,’Specialty Biscuits, Ltd.’,’Peter Wilson’,’Manchester’,’UK’,'(161) 555-4448′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(9,’PB Knäckebröd AB’,’Lars Peterson’,’Göteborg’,’Sweden’,’031-987 65 43′,’031-987 65 91′)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(10,’Refrescos Americanas LTDA’,’Carlos Diaz’,’Sao Paulo’,’Brazil’,'(11) 555 4640′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(11,’Heli Süßwaren GmbH & Co. KG’,’Petra Winkler’,’Berlin’,’Germany’,'(010) 9984510′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(12,’Plutzer Lebensmittelgroßmärkte AG’,’Martin Bein’,’Frankfurt’,’Germany’,'(069) 992755′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(13,’Nord-Ost-Fisch Handelsgesellschaft mbH’,’Sven Petersen’,’Cuxhaven’,’Germany’,'(04721) 8713′,'(04721) 8714′)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(14,’Formaggi Fortini s.r.l.’,’Elio Rossi’,’Ravenna’,’Italy’,'(0544) 60323′,'(0544) 60603′)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(15,’Norske Meierier’,’Beate Vileid’,’Sandvika’,’Norway’,'(0)2-953010′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(16,’Bigfoot Breweries’,’Cheryl Saylor’,’Bend’,’USA’,'(503) 555-9931′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(17,’Svensk Sjöföda AB’,’Michael Björn’,’Stockholm’,’Sweden’,’08-123 45 67′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(18,’Aux joyeux ecclésiastiques’,’Guylène Nodier’,’Paris’,’France’,'(1) 03.83.00.68′,'(1) 03.83.00.62′)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(19,’New England Seafood Cannery’,’Robb Merchant’,’Boston’,’USA’,'(617) 555-3267′,'(617) 555-3389′)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(20,’Leka Trading’,’Chandra Leka’,’Singapore’,’Singapore’,’555-8787′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(21,’Lyngbysild’,’Niels Petersen’,’Lyngby’,’Denmark’,’43844108′,’43844115′)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(22,’Zaanse Snoepfabriek’,’Dirk Luchte’,’Zaandam’,’Netherlands’,'(12345) 1212′,'(12345) 1210′)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(23,’Karkki Oy’,’Anne Heikkonen’,’Lappeenranta’,’Finland’,'(953) 10956′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(24,’G”day, Mate’,’Wendy Mackenzie’,’Sydney’,’Australia’,'(02) 555-5914′,'(02) 555-4873′)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(25,’Ma Maison’,’Jean-Guy Lauzon’,’Montréal’,’Canada’,'(514) 555-9022′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(26,’Pasta Buttini s.r.l.’,’Giovanni Giudici’,’Salerno’,’Italy’,'(089) 6547665′,'(089) 6547667′)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(27,’Escargots Nouveaux’,’Marie Delamare’,’Montceau’,’France’,’85.57.00.07′,NULL)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(28,’Gai pâturage’,’Eliane Noz’,’Annecy’,’France’,’38.76.98.06′,’38.76.98.58′)
INSERT INTO [Supplier] ([Id],[CompanyName],[ContactName],[City],[Country],[Phone],[Fax])VALUES(29,’Forêts d”érables’,’Chantal Goulet’,’Ste-Hyacinthe’,’Canada’,'(514) 555-2955′,'(514) 555-2921′)
SET IDENTITY_INSERT Supplier OFF
SET IDENTITY_INSERT Product ON
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(1,’Chai’,1,18.00,’10 boxes x 20 bags’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(2,’Chang’,1,19.00,’24 – 12 oz bottles’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(3,’Aniseed Syrup’,1,10.00,’12 – 550 ml bottles’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(4,’Chef Anton”s Cajun Seasoning’,2,22.00,’48 – 6 oz jars’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(5,’Chef Anton”s Gumbo Mix’,2,21.35,’36 boxes’,1)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(6,’Grandma”s Boysenberry Spread’,3,25.00,’12 – 8 oz jars’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(7,’Uncle Bob”s Organic Dried Pears’,3,30.00,’12 – 1 lb pkgs.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(8,’Northwoods Cranberry Sauce’,3,40.00,’12 – 12 oz jars’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(9,’Mishi Kobe Niku’,4,97.00,’18 – 500 g pkgs.’,1)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(10,’Ikura’,4,31.00,’12 – 200 ml jars’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(11,’Queso Cabrales’,5,21.00,’1 kg pkg.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(12,’Queso Manchego La Pastora’,5,38.00,’10 – 500 g pkgs.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(13,’Konbu’,6,6.00,’2 kg box’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(14,’Tofu’,6,23.25,’40 – 100 g pkgs.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(15,’Genen Shouyu’,6,15.50,’24 – 250 ml bottles’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(16,’Pavlova’,7,17.45,’32 – 500 g boxes’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(17,’Alice Mutton’,7,39.00,’20 – 1 kg tins’,1)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(18,’Carnarvon Tigers’,7,62.50,’16 kg pkg.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(19,’Teatime Chocolate Biscuits’,8,9.20,’10 boxes x 12 pieces’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(20,’Sir Rodney”s Marmalade’,8,81.00,’30 gift boxes’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(21,’Sir Rodney”s Scones’,8,10.00,’24 pkgs. x 4 pieces’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(22,’Gustaf”s Knäckebröd’,9,21.00,’24 – 500 g pkgs.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(23,’Tunnbröd’,9,9.00,’12 – 250 g pkgs.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(24,’Guaraná Fantástica’,10,4.50,’12 – 355 ml cans’,1)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(25,’NuNuCa Nuß-Nougat-Creme’,11,14.00,’20 – 450 g glasses’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(26,’Gumbär Gummibärchen’,11,31.23,’100 – 250 g bags’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(27,’Schoggi Schokolade’,11,43.90,’100 – 100 g pieces’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(28,’Rössle Sauerkraut’,12,45.60,’25 – 825 g cans’,1)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(29,’Thüringer Rostbratwurst’,12,123.79,’50 bags x 30 sausgs.’,1)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(30,’Nord-Ost Matjeshering’,13,25.89,’10 – 200 g glasses’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(31,’Gorgonzola Telino’,14,12.50,’12 – 100 g pkgs’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(32,’Mascarpone Fabioli’,14,32.00,’24 – 200 g pkgs.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(33,’Geitost’,15,2.50,’500 g’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(34,’Sasquatch Ale’,16,14.00,’24 – 12 oz bottles’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(35,’Steeleye Stout’,16,18.00,’24 – 12 oz bottles’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(36,’Inlagd Sill’,17,19.00,’24 – 250 g jars’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(37,’Gravad lax’,17,26.00,’12 – 500 g pkgs.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(38,’Côte de Blaye’,18,263.50,’12 – 75 cl bottles’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(39,’Chartreuse verte’,18,18.00,’750 cc per bottle’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(40,’Boston Crab Meat’,19,18.40,’24 – 4 oz tins’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(41,’Jack”s New England Clam Chowder’,19,9.65,’12 – 12 oz cans’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(42,’Singaporean Hokkien Fried Mee’,20,14.00,’32 – 1 kg pkgs.’,1)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(43,’Ipoh Coffee’,20,46.00,’16 – 500 g tins’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(44,’Gula Malacca’,20,19.45,’20 – 2 kg bags’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(45,’Rogede sild’,21,9.50,’1k pkg.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(46,’Spegesild’,21,12.00,’4 – 450 g glasses’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(47,’Zaanse koeken’,22,9.50,’10 – 4 oz boxes’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(48,’Chocolade’,22,12.75,’10 pkgs.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(49,’Maxilaku’,23,20.00,’24 – 50 g pkgs.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(50,’Valkoinen suklaa’,23,16.25,’12 – 100 g bars’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(51,’Manjimup Dried Apples’,24,53.00,’50 – 300 g pkgs.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(52,’Filo Mix’,24,7.00,’16 – 2 kg boxes’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(53,’Perth Pasties’,24,32.80,’48 pieces’,1)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(54,’Tourtière’,25,7.45,’16 pies’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(55,’Pâté chinois’,25,24.00,’24 boxes x 2 pies’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(56,’Gnocchi di nonna Alice’,26,38.00,’24 – 250 g pkgs.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(57,’Ravioli Angelo’,26,19.50,’24 – 250 g pkgs.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(58,’Escargots de Bourgogne’,27,13.25,’24 pieces’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(59,’Raclette Courdavault’,28,55.00,’5 kg pkg.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(60,’Camembert Pierrot’,28,34.00,’15 – 300 g rounds’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(61,’Sirop d”érable’,29,28.50,’24 – 500 ml bottles’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(62,’Tarte au sucre’,29,49.30,’48 pies’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(63,’Vegie-spread’,7,43.90,’15 – 625 g jars’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(64,’Wimmers gute Semmelknödel’,12,33.25,’20 bags x 4 pieces’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(65,’Louisiana Fiery Hot Pepper Sauce’,2,21.05,’32 – 8 oz bottles’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(66,’Louisiana Hot Spiced Okra’,2,17.00,’24 – 8 oz jars’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(67,’Laughing Lumberjack Lager’,16,14.00,’24 – 12 oz bottles’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(68,’Scottish Longbreads’,8,12.50,’10 boxes x 8 pieces’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(69,’Gudbrandsdalsost’,15,36.00,’10 kg pkg.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(70,’Outback Lager’,7,15.00,’24 – 355 ml bottles’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(71,’Flotemysost’,15,21.50,’10 – 500 g pkgs.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(72,’Mozzarella di Giovanni’,14,34.80,’24 – 200 g pkgs.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(73,’Röd Kaviar’,17,15.00,’24 – 150 g jars’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(74,’Longlife Tofu’,4,10.00,’5 kg pkg.’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(75,’Rhönbräu Klosterbier’,12,7.75,’24 – 0.5 l bottles’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(76,’Lakkalikööri’,23,18.00,’500 ml’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(77,’Original Frankfurter grüne Soße’,12,13.00,’12 boxes’,0)
INSERT INTO [Product] ([Id],[ProductName],[SupplierId],[UnitPrice],[Package],[IsDiscontinued])VALUES(78,’Stroopwafels’,22,9.75,’24 pieces’,0)
SET IDENTITY_INSERT Product OFF

sample-model.sql
/*==============================================================*/
/* Table: Product */
/*==============================================================*/
create table Product (
Id int identity,
ProductName nvarchar(50) not null,
SupplierId int not null,
UnitPrice decimal(12,2) null default 0,
Package nvarchar(30) null,
IsDiscontinued bit not null default 0,
constraint PK_PRODUCT primary key (Id)
)
go

/*==============================================================*/
/* Table: Supplier */
/*==============================================================*/
create table Supplier (
Id int identity,
CompanyName nvarchar(40) not null,
ContactName nvarchar(50) null,
ContactTitle nvarchar(40) null,
City nvarchar(40) null,
Country nvarchar(40) null,
Phone nvarchar(30) null,
Fax nvarchar(30) null,
constraint PK_SUPPLIER primary key (Id)
)
go

For this Milestone we will be building the actual database on the MS SQL Server you installed during milestone 2. In order to complete this milestone you will need to be able to transfer files from your local PC to your AWS instance. You should have already downloaded and install WinSCP from the directions in IvyLearn. Now you will need to configure WinSCP to connect to your server.

Configuring WinSCP

First launch WinSCP and configure the Login page as indicated below

File Protocol: SCP

Host Name: Your Amazon Instance name

Username: Ubuntu

Then you need to configure WinSCP to use your keypair to authenticate. You do this by clickin on the Advanced button and selecting Authentication under the SSH heading as shown below

From this window browse and select the private key you converted and have been using with PuTTY for your terminal connection. Once you have located that .ppk key file click OK. You are now ready to click login.

You should end up with a window that looks similar to the one below. In the right hand pane you have you local PC in the right your Linux Server in AWS.

Transferring the files

Once you are connected to your Linux box you will want to browse in the left hand pane to the location where you downloaded and extracted the .sql files from the Module Assignment page. Then drag the two files to the right hand pane to upload them to your Linux Instance. When the upload has completed you will see the files in the right hand pane. You can now close WinSCP.

Creating the Database

With the script files uploaded it is now time to connect via PuTTY to your AWS instance and create the database. The files you uploaded will be in your home directory which can be accessed at the path of /home/Ubuntu

In order to create the database we will use the sqlcmd utility. Use the command below to enter into the sqlcmd utility

/opt/mssql-tools/bin/sqlcmd –S localhost –U SA –P YOURPASSWORD

This should bring you to a prompt that looks like the image below

From here you are ready to build your database using the command below

CREATE DATABASE sample

Once you have typed the command hit enter to get a new line. Then type GO and press enter again. Include a screenshot of the result, then type Exit to leave SQLCMD

Build the Tables in the database

In order to create the tables in the database we will need to execute the sample_model.sql file. This file contains a series or SQL commands that will build the tables. We will again be using SQLCMD but this time we will be passing the it SQL Script file that you uploaded earlier in the lab. The command below should be executed in your PuTTY window while you are in your home directory. If you need to navigate to your home directory you can do so with the command
cd ~

/opt/mssql-tools/bin/sqlcmd –S localhost –U SA –P YourPassword –I sample-model.sql

Once this command has completed include a screenshot below of the output.

Load the Data into the Tables

Now that your database has tables in it we need to load data into the tables. The sample data we are going to use is in the sample-data.sql file that you uploaded to your server with WinSCP. In order to execute this script we will use the same command as when we built the tables and simply replace the sample-model.sql filename with the filename sample-data.sql.

Once the script has finished include a screenshot of the output here.

Test Query

Congratulations, if all of your scripts ran as expected you now have a working database server complete with 2 populated tables. The last step for this milestone is to execute a simple query against of the tables to show that it contains data. For that you will need to log into SQLCMD again with the command below

/opt/mssql-tools/bin/sqlcmd –S localhost –U SA –P YourPassword

Once you are at the prompt type in the following command

Select * from product

Go

Take a screenshot of the results and paste it here. Don’t forget to upload this document for your instructor to review.

image1

image2

image3

image4