rendered paste body--Paper TableInsert 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 TableInsert 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 TableInsert 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 TableInsert 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 TableInsert 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 TableInsert 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 tableInsert 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 TableInsert 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 TableInsert 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)