--Paper Table
Insert into paper(PaperName)
Values('Journal')
Insert into paper(PaperName)
Values('Sun')
Insert into paper(PaperName)
Values('National Post')
Insert into paper(PaperName)
Values('Globe and Mail')

--Carrier Table
Insert into carrier(FirstName,LastName,Phone)
values('Bub','Slug','5551245454')
Insert into carrier(FirstName,LastName,Phone)
values('Betty','Rubble','5558372716')
Insert into carrier(FirstName,LastName,Phone)
values('Luke','Skywalker','5558881212')
Insert into carrier(FirstName,LastName,Phone)
values('Princess','Leia','5558881212')
Insert into carrier(FirstName,LastName,Phone)
values('Bob','Barker','5558881212')
Insert into carrier(FirstName,LastName,Phone)
values('Rob','Tomlinson','5558881212')


--Distributor Table
Insert into Distributor(FirstName, LastName, PagerNumber, Wage)
Values ('Homer', 'Simpson',NULL, 15)
Insert into Distributor(FirstName, LastName, PagerNumber, Wage)
Values ('Marge', 'Simpson',NULL, 16)
Insert into Distributor(FirstName, LastName, PagerNumber, Wage)
Values ('Lisa', 'Simpson',NULL, 9)
Insert into Distributor(FirstName, LastName, PagerNumber, Wage)
Values ('Bart', 'Simpson',NULL, 10)

--Region Table
Insert into Region (RegionID, RegionName, RegionSupervisorName, DistributorID)
values (100,'Edmonton','Joni',1)
Insert into Region (RegionID, RegionName, RegionSupervisorName, DistributorID)
values (200,'Sherwood Park','John',2)
Insert into Region (RegionID, RegionName, RegionSupervisorName, DistributorID)
values (300,'St. Albert','Heather',4)


--Drop Site Table
Insert into DropSite(DropSiteID, DropSiteName, DropSiteAddress)
values (10, 'Sherwood Park Mall','12232 Sherwood Drive')
Insert into DropSite(DropSiteID, DropSiteName, DropSiteAddress)
values (20, 'West Edmonton Mall','Edmonton')
Insert into DropSite(DropSiteID, DropSiteName, DropSiteAddress)
values (30, 'DownTown Library','DownTown')

--Route Table
Insert into Route (RouteID, RouteName, EstimatedTime, RegionID, DropSiteID,Carrierid)
values(1,'Riverbend','90',100,20,1)
Insert into Route (RouteID, RouteName, EstimatedTime, RegionID, DropSiteID,Carrierid)
values(5,'Mills Haven','60',200,20,1)
Insert into Route (RouteID, RouteName, EstimatedTime, RegionID, DropSiteID,Carrierid)
values(10,'North St.Albert','45',300,10,3)
Insert into Route (RouteID, RouteName, EstimatedTime, RegionID, DropSiteID,Carrierid)
values(20,'Millwoods','75',100,20,2)
--customer table
Insert into Customer (CustomerID,FirstName, LastName, Address, City, Province, PostalCode, PrePaidTip, RouteID)
Values(1,'Jone', 'Simpson', '13312 121 street','Edmonton','AB','T3J 1J2',90,1)
Insert into Customer (CustomerID,FirstName, LastName, Address, City, Province, PostalCode, PrePaidTip, RouteID)
Values(2,'Lisa', 'Jones', '16512 122 street','Edmonton','AB','T3J 1J2',55,20)
Insert into Customer (CustomerID,FirstName, LastName, Address, City, Province, PostalCode, PrePaidTip, RouteID)
Values(3,'George', 'Forman', '63271 44 Avenue','St. Albert','AB','T1J 4J6',20,10)
Insert into Customer (CustomerID,FirstName, LastName, Address, City, Province, PostalCode, PrePaidTip, RouteID)
Values(4,'Rob', 'smilie', '13312 121 street','Sherwood Park','AB','T3J 1J2',10,5)
Insert into Customer (CustomerID,FirstName, LastName, Address, City, Province, PostalCode, PrePaidTip, RouteID)
Values(5,'Cyndi', 'Lauper', '13312 121 street','Sherwood Park','AB','T3J 1J2',10,5)
Insert into Customer (CustomerID,FirstName, LastName, Address, City, Province, PostalCode, PrePaidTip, RouteID)
Values(6,'Bob', 'Marley', '13312 121 street','Edmonton','AB','T3J 1J2',95,1)
Insert into Customer (CustomerID,FirstName, LastName, Address, City, Province, PostalCode, PrePaidTip, RouteID)
Values(7,'Elvis', 'Presely', '13312 121 street','Edmonton','AB','T3J 1J2',15,1)
Insert into Customer (CustomerID,FirstName, LastName, Address, City, Province, PostalCode, PrePaidTip, RouteID)
Values(8,'Eric', 'Clapton', '13312 121 street','Sherwood Park','AB','T3J 1J2',75,5)
Insert into Customer (CustomerID,FirstName, LastName, Address, City, Province, PostalCode, PrePaidTip, RouteID)
Values(9,'Dennis', 'Johnson', '13312 121 street','St. Albert','AB','T3J 1J2',45,10)
Insert into Customer (CustomerID,FirstName, LastName, Address, City, Province, PostalCode, PrePaidTip, RouteID)
Values(10,'James', 'Douglas', '13312 121 street','Edmonton','AB','T3J 1J2',20,20)
Insert into Customer (CustomerID,FirstName, LastName, Address, City, Province, PostalCode, PrePaidTip, RouteID)
Values(11,'Jay', 'Leno', '13312 121 street','Edmonton','AB','T3J 1J2',1,1)
Insert into Customer (CustomerID,FirstName, LastName, Address, City, Province, PostalCode, PrePaidTip, RouteID)
Values(12,'Ethan', 'Little', '13312 121 street','Edmonton','AB','T3J 1J2',5,1)
Insert into Customer (CustomerID,FirstName, LastName, Address, City, Province, PostalCode, PrePaidTip, RouteID)
Values(13,'Nathan', 'Tyler', '13312 121 street','Sherwood Park','AB','T3J 1J2',0,5)
Insert into Customer (CustomerID,FirstName, LastName, Address, City, Province, PostalCode, PrePaidTip, RouteID)
Values(14,'Susan', 'McDonald', '13312 121 street','St. Albert','AB','T3J 1J2',0,10)
Insert into Customer (CustomerID,FirstName, LastName, Address, City, Province, PostalCode, PrePaidTip, RouteID)
Values(15,'Betty', 'Carlson', '13312 121 street','Edmonton','AB','T3J 1J2',0,20)


--DeliveryType Table
Insert into DeliveryType (DeliveryTypeID, DeliveryTypeDescription, DeliveryCharge)
values(1,'Daily',.50)
Insert into DeliveryType (DeliveryTypeID, DeliveryTypeDescription, DeliveryCharge)
values(2,'Weekends',1.00)
Insert into DeliveryType (DeliveryTypeID, DeliveryTypeDescription, DeliveryCharge)
values(3,'Friday',1.00)
Insert into DeliveryType (DeliveryTypeID, DeliveryTypeDescription, DeliveryCharge)
values(4,'Sunday',1.00)


--CustomerPaper Table
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(1,1,2)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(1,2,4)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(2,1,1)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(3,1,1)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(1,4,1)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(4,1,2)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(5,1,2)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(6,1,2)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(7,3,2)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(8,1,2)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(9,3,2)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(10,1,1)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(11,1,1)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(12,1,1)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(13,1,1)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(14,1,1)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(15,1,1)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(10,2,1)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(13,2,1)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(11,3,1)
Insert into CustomerPaper (CustomerID,PaperID, DeliveryTypeID)
values(10,4,1)