Description
Using the Northwind Database, add a new table called ProductGroups. It will contain four product groups - mountain, touring, road, and other. Create a relationship with the Products table such that each product belongs to a product group. Find a way to update each product with it's product group (hint: use a case statement). Submit your code in a .sql file.
Unformatted Attachment Preview
/*
** Copyright Microsoft, Inc. 1994 - 2000
** All Rights Reserved.
*/
SET NOCOUNT ON
GO
USE master
GO
if exists (select * from sysdatabases where name='Northwind')
drop database Northwind
go
DECLARE @device_directory NVARCHAR(520)
SELECT @device_directory = SUBSTRING(filename, 1, CHARINDEX(N'master.mdf', LOWER(filename)) - 1)
FROM master.dbo.sysaltfiles WHERE dbid = 1 AND fileid = 1
EXECUTE (N'CREATE DATABASE Northwind
ON PRIMARY (NAME = N''Northwind'', FILENAME = N''' + @device_directory + N'northwnd.mdf'')
LOG ON (NAME = N''Northwind_log'', FILENAME = N''' + @device_directory + N'northwnd.ldf'')')
go
--exec sp_dboption 'Northwind','trunc. log on chkpt.','true'
--exec sp_dboption 'Northwind','select into/bulkcopy','true'
GO
set quoted_identifier on
GO
/* Set DATEFORMAT so that the date strings are interpreted correctly regardless of
the default DATEFORMAT on the server.
*/
SET DATEFORMAT mdy
GO
use "Northwind"
go
if exists (select * from sysobjects where id = object_id('dbo.Employee Sales by Country') and sysstat &
0xf = 4)
drop procedure "dbo"."Employee Sales by Country"
GO
if exists (select * from sysobjects where id = object_id('dbo.Sales by Year') and sysstat & 0xf = 4)
drop procedure "dbo"."Sales by Year"
GO
if exists (select * from sysobjects where id = object_id('dbo.Ten Most Expensive Products') and sysstat &
0xf = 4)
drop procedure "dbo"."Ten Most Expensive Products"
GO
if exists (select * from sysobjects where id = object_id('dbo.Category Sales for 1997') and sysstat & 0xf =
2)
drop view "dbo"."Category Sales for 1997"
GO
if exists (select * from sysobjects where id = object_id('dbo.Sales by Category') and sysstat & 0xf = 2)
drop view "dbo"."Sales by Category"
GO
if exists (select * from sysobjects where id = object_id('dbo.Sales Totals by Amount') and sysstat & 0xf =
2)
drop view "dbo"."Sales Totals by Amount"
GO
if exists (select * from sysobjects where id = object_id('dbo.Summary of Sales by Quarter') and sysstat &
0xf = 2)
drop view "dbo"."Summary of Sales by Quarter"
GO
if exists (select * from sysobjects where id = object_id('dbo.Summary of Sales by Year') and sysstat & 0xf
= 2)
drop view "dbo"."Summary of Sales by Year"
GO
if exists (select * from sysobjects where id = object_id('dbo.Invoices') and sysstat & 0xf = 2)
drop view "dbo"."Invoices"
GO
if exists (select * from sysobjects where id = object_id('dbo.Order Details Extended') and sysstat & 0xf =
2)
drop view "dbo"."Order Details Extended"
GO
if exists (select * from sysobjects where id = object_id('dbo.Order Subtotals') and sysstat & 0xf = 2)
drop view "dbo"."Order Subtotals"
GO
if exists (select * from sysobjects where id = object_id('dbo.Product Sales for 1997') and sysstat & 0xf =
2)
drop view "dbo"."Product Sales for 1997"
GO
if exists (select * from sysobjects where id = object_id('dbo.Alphabetical list of products') and sysstat &
0xf = 2)
drop view "dbo"."Alphabetical list of products"
GO
if exists (select * from sysobjects where id = object_id('dbo.Current Product List') and sysstat & 0xf = 2)
drop view "dbo"."Current Product List"
GO
if exists (select * from sysobjects where id = object_id('dbo.Orders Qry') and sysstat & 0xf = 2)
drop view "dbo"."Orders Qry"
GO
if exists (select * from sysobjects where id = object_id('dbo.Products Above Average Price') and sysstat &
0xf = 2)
drop view "dbo"."Products Above Average Price"
GO
if exists (select * from sysobjects where id = object_id('dbo.Products by Category') and sysstat & 0xf = 2)
drop view "dbo"."Products by Category"
GO
if exists (select * from sysobjects where id = object_id('dbo.Quarterly Orders') and sysstat & 0xf = 2)
drop view "dbo"."Quarterly Orders"
GO
if exists (select * from sysobjects where id = object_id('dbo.Customer and Suppliers by City') and sysstat
& 0xf = 2)
drop view "dbo"."Customer and Suppliers by City"
GO
if exists (select * from sysobjects where id = object_id('dbo.Order Details') and sysstat & 0xf = 3)
drop table "dbo"."Order Details"
GO
if exists (select * from sysobjects where id = object_id('dbo.Orders') and sysstat & 0xf = 3)
drop table "dbo"."Orders"
GO
if exists (select * from sysobjects where id = object_id('dbo.Products') and sysstat & 0xf = 3)
drop table "dbo"."Products"
GO
if exists (select * from sysobjects where id = object_id('dbo.Categories') and sysstat & 0xf = 3)
drop table "dbo"."Categories"
GO
if exists (select * from sysobjects where id = object_id('dbo.Customers') and sysstat & 0xf = 3)
drop table "dbo"."Customers"
GO
if exists (select * from sysobjects where id = object_id('dbo.Shippers') and sysstat & 0xf = 3)
drop table "dbo"."Shippers"
GO
if exists (select * from sysobjects where id = object_id('dbo.Suppliers') and sysstat & 0xf = 3)
drop table "dbo"."Suppliers"
GO
if exists (select * from sysobjects where id = object_id('dbo.Employees') and sysstat & 0xf = 3)
drop table "dbo"."Employees"
GO
CREATE TABLE "Employees" (
"EmployeeID" "int" IDENTITY (1, 1) NOT NULL ,
"LastName" nvarchar (20) NOT NULL ,
"FirstName" nvarchar (10) NOT NULL ,
"Title" nvarchar (30) NULL ,
"TitleOfCourtesy" nvarchar (25) NULL ,
"BirthDate" "datetime" NULL ,
"HireDate" "datetime" NULL ,
"Address" nvarchar (60) NULL ,
"City" nvarchar (15) NULL ,
"Region" nvarchar (15) NULL ,
"PostalCode" nvarchar (10) NULL ,
"Country" nvarchar (15) NULL ,
"HomePhone" nvarchar (24) NULL ,
"Extension" nvarchar (4) NULL ,
"Photo" "image" NULL ,
"Notes" "ntext" NULL ,
"ReportsTo" "int" NULL ,
"PhotoPath" nvarchar (255) NULL ,
CONSTRAINT "PK_Employees" PRIMARY KEY CLUSTERED
(
"EmployeeID"
),
CONSTRAINT "FK_Employees_Employees" FOREIGN KEY
(
"ReportsTo"
) REFERENCES "dbo"."Employees" (
"EmployeeID"
),
CONSTRAINT "CK_Birthdate" CHECK (BirthDate < getdate())
)
GO
CREATE INDEX "LastName" ON "dbo"."Employees"("LastName")
GO
CREATE INDEX "PostalCode" ON "dbo"."Employees"("PostalCode")
GO
CREATE TABLE "Categories" (
"CategoryID" "int" IDENTITY (1, 1) NOT NULL ,
"CategoryName" nvarchar (15) NOT NULL ,
"Description" "ntext" NULL ,
"Picture" "image" NULL ,
CONSTRAINT "PK_Categories" PRIMARY KEY CLUSTERED
(
"CategoryID"
)
)
GO
CREATE INDEX "CategoryName" ON "dbo"."Categories"("CategoryName")
GO
CREATE TABLE "Customers" (
"CustomerID" nchar (5) NOT NULL ,
"CompanyName" nvarchar (40) NOT NULL ,
"ContactName" nvarchar (30) NULL ,
"ContactTitle" nvarchar (30) NULL ,
"Address" nvarchar (60) NULL ,
"City" nvarchar (15) NULL ,
"Region" nvarchar (15) NULL ,
"PostalCode" nvarchar (10) NULL ,
"Country" nvarchar (15) NULL ,
"Phone" nvarchar (24) NULL ,
"Fax" nvarchar (24) NULL ,
CONSTRAINT "PK_Customers" PRIMARY KEY CLUSTERED
(
"CustomerID"
)
)
GO
CREATE INDEX "City" ON "dbo"."Customers"("City")
GO
CREATE INDEX "CompanyName" ON "dbo"."Customers"("CompanyName")
GO
CREATE INDEX "PostalCode" ON "dbo"."Customers"("PostalCode")
GO
CREATE INDEX "Region" ON "dbo"."Customers"("Region")
GO
CREATE TABLE "Shippers" (
"ShipperID" "int" IDENTITY (1, 1) NOT NULL ,
"CompanyName" nvarchar (40) NOT NULL ,
"Phone" nvarchar (24) NULL ,
CONSTRAINT "PK_Shippers" PRIMARY KEY CLUSTERED
(
"ShipperID"
)
)
GO
CREATE TABLE "Suppliers" (
"SupplierID" "int" IDENTITY (1, 1) NOT NULL ,
"CompanyName" nvarchar (40) NOT NULL ,
"ContactName" nvarchar (30) NULL ,
"ContactTitle" nvarchar (30) NULL ,
"Address" nvarchar (60) NULL ,
"City" nvarchar (15) NULL ,
"Region" nvarchar (15) NULL ,
"PostalCode" nvarchar (10) NULL ,
"Country" nvarchar (15) NULL ,
"Phone" nvarchar (24) NULL ,
"Fax" nvarchar (24) NULL ,
"HomePage" "ntext" NULL ,
CONSTRAINT "PK_Suppliers" PRIMARY KEY CLUSTERED
(
"SupplierID"
)
)
GO
CREATE INDEX "CompanyName" ON "dbo"."Suppliers"("CompanyName")
GO
CREATE INDEX "PostalCode" ON "dbo"."Suppliers"("PostalCode")
GO
CREATE TABLE "Orders" (
"OrderID" "int" IDENTITY (1, 1) NOT NULL ,
"CustomerID" nchar (5) NULL ,
"EmployeeID" "int" NULL ,
"OrderDate" "datetime" NULL ,
"RequiredDate" "datetime" NULL ,
"ShippedDate" "datetime" NULL ,
"ShipVia" "int" NULL ,
"Freight" "money" NULL CONSTRAINT "DF_Orders_Freight" DEFAULT (0),
"ShipName" nvarchar (40) NULL ,
"ShipAddress" nvarchar (60) NULL ,
"ShipCity" nvarchar (15) NULL ,
"ShipRegion" nvarchar (15) NULL ,
"ShipPostalCode" nvarchar (10) NULL ,
"ShipCountry" nvarchar (15) NULL ,
CONSTRAINT "PK_Orders" PRIMARY KEY CLUSTERED
(
"OrderID"
),
CONSTRAINT "FK_Orders_Customers" FOREIGN KEY
(
"CustomerID"
) REFERENCES "dbo"."Customers" (
"CustomerID"
),
CONSTRAINT "FK_Orders_Employees" FOREIGN KEY
(
"EmployeeID"
) REFERENCES "dbo"."Employees" (
"EmployeeID"
),
CONSTRAINT "FK_Orders_Shippers" FOREIGN KEY
(
"ShipVia"
) REFERENCES "dbo"."Shippers" (
"ShipperID"
)
)
GO
CREATE INDEX "CustomerID" ON "dbo"."Orders"("CustomerID")
GO
CREATE INDEX "CustomersOrders" ON "dbo"."Orders"("CustomerID")
GO
CREATE INDEX "EmployeeID" ON "dbo"."Orders"("EmployeeID")
GO
CREATE INDEX "EmployeesOrders" ON "dbo"."Orders"("EmployeeID")
GO
CREATE INDEX "OrderDate" ON "dbo"."Orders"("OrderDate")
GO
CREATE INDEX "ShippedDate" ON "dbo"."Orders"("ShippedDate")
GO
CREATE INDEX "ShippersOrders" ON "dbo"."Orders"("ShipVia")
GO
CREATE INDEX "ShipPostalCode" ON "dbo"."Orders"("ShipPostalCode")
GO
CREATE TABLE "Products" (
"ProductID" "int" IDENTITY (1, 1) NOT NULL ,
"ProductName" nvarchar (40) NOT NULL ,
"SupplierID" "int" NULL ,
"CategoryID" "int" NULL ,
"QuantityPerUnit" nvarchar (20) NULL ,
"UnitPrice" "money" NULL CONSTRAINT "DF_Products_UnitPrice" DEFAULT (0),
"UnitsInStock" "smallint" NULL CONSTRAINT "DF_Products_UnitsInStock" DEFAULT (0),
"UnitsOnOrder" "smallint" NULL CONSTRAINT "DF_Products_UnitsOnOrder" DEFAULT (0),
"ReorderLevel" "smallint" NULL CONSTRAINT "DF_Products_ReorderLevel" DEFAULT (0),
"Discontinued" "bit" NOT NULL CONSTRAINT "DF_Products_Discontinued" DEFAULT (0),
CONSTRAINT "PK_Products" PRIMARY KEY CLUSTERED
(
"ProductID"
),
CONSTRAINT "FK_Products_Categories" FOREIGN KEY
(
"CategoryID"
) REFERENCES "dbo"."Categories" (
"CategoryID"
),
CONSTRAINT "FK_Products_Suppliers" FOREIGN KEY
(
"SupplierID"
) REFERENCES "dbo"."Suppliers" (
"SupplierID"
),
CONSTRAINT "CK_Products_UnitPrice" CHECK (UnitPrice >= 0),
CONSTRAINT "CK_ReorderLevel" CHECK (ReorderLevel >= 0),
CONSTRAINT "CK_UnitsInStock" CHECK (UnitsInStock >= 0),
CONSTRAINT "CK_UnitsOnOrder" CHECK (UnitsOnOrder >= 0)
)
GO
CREATE INDEX "CategoriesProducts" ON "dbo"."Products"("CategoryID")
GO
CREATE INDEX "CategoryID" ON "dbo"."Products"("CategoryID")
GO
CREATE INDEX "ProductName" ON "dbo"."Products"("ProductName")
GO
CREATE INDEX "SupplierID" ON "dbo"."Products"("SupplierID")
GO
CREATE INDEX "SuppliersProducts" ON "dbo"."Products"("SupplierID")
GO
CREATE TABLE "Order Details" (
"OrderID" "int" NOT NULL ,
"ProductID" "int" NOT NULL ,
"UnitPrice" "money" NOT NULL CONSTRAINT "DF_Order_Details_UnitPrice" DEFAULT (0),
"Quantity" "smallint" NOT NULL CONSTRAINT "DF_Order_Details_Quantity" DEFAULT (1),
"Discount" "real" NOT NULL CONSTRAINT "DF_Order_Details_Discount" DEFAULT (0),
CONSTRAINT "PK_Order_Details" PRIMARY KEY CLUSTERED
(
"OrderID",
"ProductID"
),
CONSTRAINT "FK_Order_Details_Orders" FOREIGN KEY
(
"OrderID"
) REFERENCES "dbo"."Orders" (
"OrderID"
),
CONSTRAINT "FK_Order_Details_Products" FOREIGN KEY
(
"ProductID"
) REFERENCES "dbo"."Products" (
"ProductID"
),
CONSTRAINT "CK_Discount" CHECK (Discount >= 0 and (Discount 0),
CONSTRAINT "CK_UnitPrice" CHECK (UnitPrice >= 0)
)
GO
CREATE INDEX "OrderID" ON "dbo"."Order Details"("OrderID")
GO
CREATE INDEX "OrdersOrder_Details" ON "dbo"."Order Details"("OrderID")
GO
CREATE INDEX "ProductID" ON "dbo"."Order Details"("ProductID")
GO
CREATE INDEX "ProductsOrder_Details" ON "dbo"."Order Details"("ProductID")
GO
create view "Customer and Suppliers by City" AS
SELECT City, CompanyName, ContactName, 'Customers' AS Relationship
FROM Customers
UNION SELECT City, CompanyName, ContactName, 'Suppliers'
FROM Suppliers
--ORDER BY City, CompanyName
GO
create view "Alphabetical list of products" AS
SELECT Products.*, Categories.CategoryName
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.Discontinued)=0))
GO
create view "Current Product List" AS
SELECT Product_List.ProductID, Product_List.ProductName
FROM Products AS Product_List
WHERE (((Product_List.Discontinued)=0))
--ORDER BY Product_List.ProductName
GO
create view "Orders Qry" AS
SELECT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate,
Orders.RequiredDate,
Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipName, Orders.ShipAddress,
Orders.ShipCity,
Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry,
Customers.CompanyName, Customers.Address, Customers.City, Customers.Region,
Customers.PostalCode, Customers.Country
FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID
GO
create view "Products Above Average Price" AS
SELECT Products.ProductName, Products.UnitPrice
FROM Products
WHERE Products.UnitPrice>(SELECT AVG(UnitPrice) From Products)
--ORDER BY Products.UnitPrice DESC
GO
create view "Products by Category" AS
SELECT Categories.CategoryName, Products.ProductName, Products.QuantityPerUnit,
Products.UnitsInStock, Products.Discontinued
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE Products.Discontinued 1
--ORDER BY Categories.CategoryName, Products.ProductName
GO
create view "Quarterly Orders" AS
SELECT DISTINCT Customers.CustomerID, Customers.CompanyName, Customers.City,
Customers.Country
FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE Orders.OrderDate BETWEEN '19970101' And '19971231'
GO
create view Invoices AS
SELECT Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion,
Orders.ShipPostalCode,
Orders.ShipCountry, Orders.CustomerID, Customers.CompanyName AS CustomerName,
Customers.Address, Customers.City,
Customers.Region, Customers.PostalCode, Customers.Country,
(FirstName + ' ' + LastName) AS Salesperson,
Orders.OrderID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate,
Shippers.CompanyName As ShipperName,
"Order Details".ProductID, Products.ProductName, "Order Details".UnitPrice, "Order
Details".Quantity,
"Order Details".Discount,
(CONVERT(money,("Order Details".UnitPrice*Quantity*(1-Discount)/100))*100) AS
ExtendedPrice, Orders.Freight
FROM Shippers INNER JOIN
(Products INNER JOIN
(
(Employees INNER JOIN
(Customers INNER JOIN Orders ON Customers.CustomerID =
Orders.CustomerID)
ON Employees.EmployeeID = Orders.EmployeeID)
INNER JOIN "Order Details" ON Orders.OrderID = "Order Details".OrderID)
ON Products.ProductID = "Order Details".ProductID)
ON Shippers.ShipperID = Orders.ShipVia
GO
create view "Order Details Extended" AS
SELECT "Order Details".OrderID, "Order Details".ProductID, Products.ProductName,
"Order Details".UnitPrice, "Order Details".Quantity, "Order Details".Discount,
(CONVERT(money,("Order Details".UnitPrice*Quantity*(1-Discount)/100))*100) AS
ExtendedPrice
FROM Products INNER JOIN "Order Details" ON Products.ProductID = "Order Details".ProductID
--ORDER BY "Order Details".OrderID
GO
create view "Order Subtotals" AS
SELECT "Order Details".OrderID, Sum(CONVERT(money,("Order Details".UnitPrice*Quantity*(1Discount)/100))*100) AS Subtotal
FROM "Order Details"
GROUP BY "Order Details".OrderID
GO
create view "Product Sales for 1997" AS
SELECT Categories.CategoryName, Products.ProductName,
Sum(CONVERT(money,("Order Details".UnitPrice*Quantity*(1-Discount)/100))*100) AS ProductSales
FROM (Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID)
INNER JOIN (Orders
INNER JOIN "Order Details" ON Orders.OrderID = "Order Details".OrderID)
ON Products.ProductID = "Order Details".ProductID
WHERE (((Orders.ShippedDate) Between '19970101' And '19971231'))
GROUP BY Categories.CategoryName, Products.ProductName
GO
create view "Category Sales for 1997" AS
SELECT "Product Sales for 1997".CategoryName, Sum("Product Sales for 1997".ProductSales) AS
CategorySales
FROM "Product Sales for 1997"
GROUP BY "Product Sales for 1997".CategoryName
GO
create view "Sales by Category" AS
SELECT Categories.CategoryID, Categories.CategoryName, Products.ProductName,
Sum("Order Details Extended".ExtendedPrice) AS ProductSales
FROM Categories INNER JOIN
(Products INNER JOIN
(Orders INNER JOIN "Order Details Extended" ON Orders.OrderID = "Order
Details Extended".OrderID)
ON Products.ProductID = "Order Details Extended".ProductID)
ON Categories.CategoryID = Products.CategoryID
WHERE Orders.OrderDate BETWEEN '19970101' And '19971231'
GROUP BY Categories.CategoryID, Categories.CategoryName, Products.ProductName
--ORDER BY Products.ProductName
GO
create view "Sales Totals by Amount" AS
SELECT "Order Subtotals".Subtotal AS SaleAmount, Orders.OrderID, Customers.CompanyName,
Orders.ShippedDate
FROM Customers INNER JOIN
(Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID)
ON Customers.CustomerID = Orders.CustomerID
WHERE ("Order Subtotals".Subtotal >2500) AND (Orders.ShippedDate BETWEEN '19970101' And
'19971231')
GO
create view "Summary of Sales by Quarter" AS
SELECT Orders.ShippedDate, Orders.OrderID, "Order Subtotals".Subtotal
FROM Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID
WHERE Orders.ShippedDate IS NOT NULL
--ORDER BY Orders.ShippedDate
GO
create view "Summary of Sales by Year" AS
SELECT Orders.ShippedDate, Orders.OrderID, "Order Subtotals".Subtotal
FROM Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID
WHERE Orders.ShippedDate IS NOT NULL
--ORDER BY Orders.ShippedDate
GO
create procedure "Ten Most Expensive Products" AS
SET ROWCOUNT 10
SELECT Products.ProductName AS TenMostExpensiveProducts, Products.UnitPrice
FROM Products
ORDER BY Products.UnitPrice DESC
GO
create procedure "Employee Sales by Country"
@Beginning_Date DateTime, @Ending_Date DateTime AS
SELECT Employees.Country, Employees.LastName, Employees.FirstName, Orders.ShippedDate,
Orders.OrderID, "Order Subtotals".Subtotal AS SaleAmount
FROM Employees INNER JOIN
(Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID)
ON Employees.EmployeeID = Orders.EmployeeID
WHERE Orders.ShippedDate Between @Beginning_Date And @Ending_Date
GO
create procedure "Sales by Year"
@Beginning_Date DateTime, @Ending_Date DateTime AS
SELECT Orders.ShippedDate, Orders.OrderID, "Order Subtotals".Subtotal, DATENAME(yy,ShippedDate)
AS Year
FROM Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID
WHERE Orders.ShippedDate Between @Beginning_Date And @Ending_Date
GO
set quoted_identifier on
go
set identity_insert "Categories" on
go
ALTER TABLE "Categories" NOCHECK CONSTRAINT ALL
go
INSERT "Categories"("CategoryID","CategoryName","Description","Picture") VALUES(1,'Beverages','Soft
drinks, coffees, teas, beers, and
ales',0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E
5069637475726500010500000200000007000000504272757368000000000000000000A0290000424D9
8290000000000005600000028000000AC00000078000000010004000000000000000000880B0000880B
00000800000008000000FFFFFF0000FFFF00FF00FF000000FF00FFFF000000FF0000FF0000000000000000
00100000000010000000010010000000000000010101000100001001000000010100010000001001000
00100000010101000100000100010000000000000000000001000000001000000000000001000000000
00000000000000100100100000000000000000000100100100001250707010000000100000000100010
01000000100000010000000001001001000000010010101010100000000000000000000010010001000
00101010101000000000000000000000000000000000000101020525363777777777777753530100101
00010000000000101000100100010010010000000000010000000000000000010001000100101000100
00000100100000000000001000000000000000000000000000000010143435777777777777777777777
77777770100120001010100102000000000000000000000000100100010010000000000100010000000
00000000001001000000100100101010000000000000000000000000000000102161777777777575753
53535257777777777777701501200001000101010000000000000000010000000000000010010010000
00000010010000010010010000101001001000000100000001000000000000000000000001417777737
61737637777576777170775277777777634016121030000000001000000000001000000000000000000
00000000000000000000001000000000001000000000000100001000000000000000000000000001005
03677577571705014000000101070717775777777775334101400010101010001010010101000000000
00000000000000000000100000000000000000000000000000000101000100000100000000000000000
00000000103573530000000000000000000000000001717777777774706121010000000010000010000
00010000000000000000000000000000000100010703010101210000000000000000000000000000000
00000000000000010103435000000001065343577757047747470000010775777717100000010100100
01010001010100001000000000000000000010414771101310357500200404773010001000000000000
00000000000000000000000000000010004014176577707000067777777776560404007371734361701
40000124100000100000000100002040000020000010174776777700010107377757777777537210000
00001000000000000001001000000000100000100000376764767000040005774704167174774214050
00434140343000565120510100301014002107171370701437777777775777777112103177777777777
70575777101000000010000000000000001000010000010100047044044067100747777677777761406
06007425240017777777476467767520602500030217167377777777777777747477275747770010167
77777777767173317703000101010000000010000000001000000000000420460200077427477767777
77777567777774647465660676777766574677675715125350716673777773374677757777777757277
67711005177777777677760157131410300200010000000010010000000000101000674400440477614
77767776706767777674765673470657505767375664746757777271252167717733771737776777677
56747657757712110377577777777671702775312101010100001000000000010000101000001076706
00047767477767767777567767777777770424776760677774674747476767775652565313117711773
76477777576757777747710110701777777767777401717340000000000100001000000000001000000
10100477654066605077767765777767747077477777674766460777737674747677777767771717373
53777177377477777777777747747700112710777777677777631717352101210101000000000000000
00000010000000300406767757676775077006767477774774777774747770476777656706746777657
77777777777777777773766777747657477477777100103177777777676774137177100000000001000
00000000000000000001010057074425676561760067670047704767077007677700004777477346564
46745677676777777777777777777375667777777777777777773100010777777777777771753521010
10101000000000010001000000001000777771215250300467007777476742704724777657756470007
67377476704742777777777777777773677777777657777777777774347777507577753777676767701
72773100000000001000000000000001000101007170701614204046007746040676167470774167743
65677774007777606740746567767777777777775771777773747677571616124341030307777777757
77752100000113500010010010000001010001000001000021001715256750700743406700050040767
00706570757777767770077744746466567777677777777777777777773776777610000000137775350
31777777377773775070100010102100100010000000000001010001001030006777776165060406504
76047607464047764067056567767700777647504747476777777777777777777737337477777730117
35777777777777777757777777777767412041001001000001000001000000010001000577744140000
60740670676767677677777647775676777744770077407664676477756777777777777773737373776
46777477535277777767777777777763657353535130103001203010100000000000000000010001070
00210006147767674646040404040066667767677775476777046644644044456776767777777777733
73737377677777677424477737771771277716535757753424204001001001000001000100000010001
00001003000500001466640000001010307343521011000656777670777700476047743776767777677
77777777373737333756477657075377100770770177776525271673001012101210301001030000000
10010000000100000500006004616000400012534351011010100000000000774000004774473373737
77576777777777773737373777376567577777773731016767707777177756717730010103000000210
21010000000000000100000000100077400000414021414000000000000000000000000000300000777
77777373737767767777777777737373733373567767777737771017777771777470527176734030000
00101010001000001000001001000000010140056600000007375606000000000000000000000000000
04730777773733373737777747677777777737337353761666777777737737017771677077353777574
73531001210100000001001010000010000000001000430006540000000040014125414040400000000
00000000000377377767737773737337776777777777776776467465657567477777737730170177107
65654352735770017010303031010010000000100001001010030704000660000000000000040000000
00000000000000000000777751467337337373777777747677777777747464476466677677777777271
10310761173073743574773730103410500430300121001000101001000125000000470000000000467
42000000000000000000000000077776677777377377373733737767777777777767645676507574777
65761005712110173161157477763773510527012521301005021010000107021030165000000064000
00000067764067764640000406414341777777676676147373373373737777777676777777765647674
74664667477761775271112116101002331211101052721016120140161034106010173075617770000
57004740004740044600000046777050477776717357375676777676773773777373737777677777777
77765647467654775767771767007746564747310100110000012501652147161701210120110707771
73777400063770040000760467600000000740760600777067777777676767676767337333373737377
74767777777777676774742467674767715770167767767613133121313130137131731031216152505
30730777777777000475777000000060067600006404000064740467407777777776767676767377377
77373777777767777777777674746767467477777743670175305325352527135335353170143414371
61713013121177717777777700173777000676047667704706446640004764007774777777776767676
76737733733337373737767467777777654676747047476747653756107317735737525347374170170
35303130101010030001427777777737770047777770047460704644064400004640067004767077777
77776767676767337737777373777777677777777776656566567076776777507700756315334737073
10132136170343434343070314171211777737777777402577377000274470000640000000006400640
06760777777776767767767773373333373737777476777777777746765674464747767763477027172
75371717577775775735717171717171743361616377777773573740073777340046066004600000000
00040006006767477777777767667667673773777773737377777476777777767565674677467657771
17100537153353773777777777777777777777777737757737573777773773772047777350000474044
60044000000000004004777400777770066767767763333333333373777776676777777777766747656
46574767606000073533753731777777777777777777777777777777377773777337537777400071777
70000664024640640000000000004646700477777007767667666777777777773737777777777777776
77744646756567677753537352531713717717777777777777777777777777777777537777375377173
77000767373500000004746646656466444004004640000777000676776777733333333333737377766
76777777777767777766767765677771713175217037173777777777777777777777777775375377173
75377737777370005777700400747766776476676766746760000000477000076766766667777777777
73377777756777777717777726040004040677611716131315353537177777777777777777777377537
77777777753773717735374700000500670446677777776777776777776561004661000006767767777
33313110110077777766656777756770404050514077771653635314717313537177777777777777777
75775777777777777777773537537773717000000017760404040404046060767677761700004700000
71101100100000000000110157177776777776470124100002530004777111301313017535371777777
77777177173737777377737775377371735325216537616446426570040000000000000404004007677
40004400007775007500000000000000000173477667777465641000000004003006525135307533031
70737777775777777777777737777777773777753757035353134317137313533000046440000004400
00000005377000000000007734310000000000000000000413577777567617600070000000404421305
21531153533713577773777377377757777775737577777773532135031616171635216572570000067
00060042400000005273710000000000007577000000000000000000531117777665447405244000000
04003150131303072135353773777577757775373771773777777777777703534334313130310317131
73371301000005670002000000317560000000000000000777710121001011011311171333754667474
65707047000071502161011531534353517753773737353777737777777777737537713503353170717
17356134310530703052537004701416171743370000000000000000000010101177000000640273737
37674564677777777730657735101373435313170737377737757777737775773757357375777773433
75377373673071316352731717173137000007737352713574000000000000000000000000464000000
04673373737344664777777777774000737373711031034353717177356537353757717737573777777
77777733537377171753577277537171637373577700000717353716777000000000000000000000000
00460004004676173737374745777777777777004631713112031213131317337177737777777377777
77777777777777777537773777737737171735377357174773737761777167777357000000000000000
00000000004004000000004063373334646737777777777740077333733110010131353171777377753
77377777777777777777777777737777573777377777736771773773716717535343373525773700000
00000000000000000000000000000000003733737443337377777777770000774001031313317313733
73577537777777777777777777777777777777377377753757373737173671716537357273673747537
37174000000000000000000004600000000000000000373733643773373777777777404073000000000
01213733173737777777777777777777777777777777777757777373777375757573531727335353175
75357373775763000000000000000000004244000000040000400073733757333373333777777700007
00000000000000000070477777777777777777777777777777777777737773757753757373737777775
35727367337377353573735700000000000000000000440600000000040400403733733377373773737
77777004000000000000040064040437777777737577777777777777777777777777737737377737777
77717371737357171752573473721777340000000000000000000006446400000000004004337337333
37333733733777710000470534010001650377774771771775777777777777777777777777777375775
77735771735777757775773777737773737577771777000000000006600006400476740000000040000
03737337373377337373737774040077760004000000044004737777777777777777777777777777777
77777377377357737777737737737737753717753575737353771000000000000404000464060460000
00000004000737337373373337373737777000000474774200000000004357777777777777777777777
77777777777777757777777777777777777777777777777737737377577777000000000004600000460
06460000000400000000037337333733737373737377760000000000055004361777777777777777777
77777777777777777777777737777777737777777777777777777777777777777377377770000000000
00000000000406400000004040000003373373737337373737373770040000000002777357777777777
77777777777777777777777777777577777777777377757371777577777757737777777777777775734
04000000000000000400040640000000000000000733733733373333737373777500000000000577777
77777777777777777777777777177775737577737777777735777773777773773775377377735735735
37573773700000000000000004460040606000000000000004633733733737377737373377700746000
00003777777777777777777777777777777777377377773777773777777373717753537537537777777
77777777777737717750000000000000000000000444404400400000000063733737337333337373377
77406740000000077777777777777777777777737577377775777717717737773577777777737777777
77777777777777777777777777777040000000000000000000060006660660000000044337333373373
77333377777700676004004407777777777777777777777777777757357375377777775777737777777
77777777777777777777777777777777777777201000000000000000000004000440444000000000037
37373373373373777777777046006746600777777777777777777777777777377777777777737737737
77777777777777377377777737777753777777777777777750040000000000000000000000460460000
00000046373373373373373777777777004746406700077777777777777777777777777777777777777
77777777777777717371777777573773777537777777777377577737370000000000000000000006446
40000460000000000073373733733733777777773750660760400017777777777777777777777777777
77777777777777777777777777777737377377735717377537773573777737775777724000000000000
00000006064000000000000000003733737737337777777777376047464004060577777777777777777
77777777777777777777777775775771733735377757177175737753737537777757777777777750100
00000000000000004654000000000000000000733733333377777777777177106606767476767777777
77777777777777777777777773777777773777377777757375737377363737173757737773737373777
77371200400000000000000000046000000000000000000073737373777777777777737700656476464
61777777777777777777777777777575777777757575773577373537173735773757535763573357737
75777777737777750000400000000000004406460000400000000000007337333777777777777771371
06606476400077777777777777775777757357777777757577377375777775737777577735737377371
73577375707373717577777737000000000000000004676465654640000000000000773373777753777
77777777744744074670050777777777777757777573777357377177373777777377773717737373737
73577535373437073737757577737353777700500000000000004676474266640000000000000047333
77707474777777777777656764276602777775753777577737173577777757777777757777777537777
77775775777777377775777377577573737377777757770000004000000000674076040400000000000
00000077777103716173777777737676665646470577757377775777375777777177377777777777357
35777777373777777737173573777373575373737777777357737737000400000000000066642460404
00000000000000007777770076774777777777676767674740035777777777737777777777777777737
73573777377773777777577773777777777771775773777757353753577357777770010000000000040
40640400024400000000000000077737014147756777777776247676766006777777777377777773777
37777537777777777777777777777777737777777773753673773753573677677677376734771402400
00000000000446400004660000040000000007737520077772757777770040047667767177777757777
77777777757773777775777771775371771777777775775353535777777577577777753575373575717
73570050040000000000000000404004764404640000000077734016165757777770064400047642567
77377375775375735737777777737737737773777777777773777777777777771771777777777777773
77577737757777300000004000000000040000000000006740000000007777142577736777770040006
00067653777773777773777377777777357357777777777777777777777577777777777777777777777
77777777777777377377353770070040000000000000400000404000040000000000077770525765777
77700400404044006577377571737777777737777777777777777777777777777777777777777777777
77777737373717753777737756575277775000040000000000000000004424244000640000000007777
24077576777700400600007000373757373775775375375737777777777777777777777777777777777
77773777737737357757577777757357537373377173730070000400000000000000464644000067244
00000007775075676577750004440406440477773777777737777777777577777777777777777777777
77777777757377771777375773737373737373773377753575377577400004000000000000000000400
00004044064000000477740775777770040424604460437577775773777777777777777777777377777
77777777777777777773777757735757371757171757175717572533727343727730070000400000000
00000000000004600464000000007772525677777004704064240124373777377577777777777777773
77377777757357777777777775737773737377737377773736736372737373535617173717717500040
00004000000000000000046000004000000000477104777777006760065646405777777777777777777
77737773777777577177777777777777777377735775775377757173717535357174352537737373717
71773007004000000000000000000004004600000000000007777771135704760044650007277777777
77377777773777777775735737777777777777777777777377773773771773777577737773777377773
43574356773737710060040400400000000000000000400000000000000771571715356770446002470
75777577377777737775773573577377777777777777777777777773577737777777777777773757357
71775353577737773717475277101600000000400000000000000060000000000000077713537777676
00056440042735373775377375773777777777777777777777777777777777777777777777777777757
37777377737773777773577753757737371770010400400000000000000000044000000000000007717
13577776740060642143575777757377577777777777777777777777777777777777777777773777777
77777777777777777777777777737777373777737577777300424000400000000000000000000000000
00000077717477775676540405142537373573777777777777777777777777777777777777777777777
77777777777777773777775777777777777777773757777377773537771001004000404000000000000
00000000000000007717137577764767404061777777777777737737777777777777777377777777737
53777777777777777757777777777377377773777537717757773735375373777073710040040000000
00000000000000000000000000777171777774677600300653775777777777777777777777773777777
77777777777777777777777777373735371777775777177753777777737717757775375753573536100
05004040404000000000000000000000000077171717772076700004373773773773775773777377377
77777777777777777777777777777777775777777777777377737777777777777777777737737377373
77357753000004200000004040000000000000000000047773537777504004104375777573757777371
77777777777377777777777777777777777777777737377777777777777777777777777777777777777
77577777773773737772005040404040000004000000000000000000771535777700000160753753737
77737177777717717777777777777777777777777777777777777777777777777777777777777777777
77777777777737537357717757353530010004010400400004040004004000400017735357777007000
72773777775377777537577777777777777777777777777777777777777777777777777777777577777
77773777577777775377537727576377717252734120050040400404040000040000000400007735353
77700500653535777773777177377737777777777777777777777777777777777777777777777573777
73777777173777777777737777777777537537357527717751735000070000400000040040004004000
00477717177775004353777737377773777777777777777777777777777777777777777777777777777
77373775737717371777777357773777777377777377377777377177313634370000056104040500400
04004000404007753177777003677717375775377577777777777777777777777773777777777777777
77777777775757717777777777737177577377777775777773777353717773771776535353716000047
00040400400050005001000173571777776171777757377777777777777777777777777775737577777
77777777777777777737377377737537771775777377775375377377777577777777717573725377372
71717100005252004004040604004040077531717777177777777777777737777777775777777777777
77777777777777777777777777775771775375777537773773777377777777777777777717717377773
77537707753637743200004165241000004004000047737177777777777377777777777777773773777
77777777777777777777777777777777777777737773777773777777777577757377377777777377377
77775373775377177537575737757760000010614141014340500775753777777777777737773777777
37777777777777777777777777777777777777777777777777537777377777777777777377777777777
77777777777377777573777777377373775373735373000000000400010000077377717777737777757
75757177777777777777777777777777777777777777777777777773777377777777777777777777777
77777777777777777777777777777777377757777773777757777777771616121616377777771017777
77771771773777777777777777777777777777777777777777777177577377577757777777777777777
77777777777777777773777777777777773773777577373771771777173773753777777777777777777
57171777777717777777773777737777777777777777777777777777777777777777777777777777777
77777777777377377777377777777777377577177537777777373757737737735377735737737377737
77577377737771717777777773777777777777777777737777777777777777777777777777777777777
77777777773575375377775777737757535735775775373777377537573577573575717537771717357
35775357537737571777771717577777777777375777375735377377775377777777777777777777777
77777777777777777777773777777177375375737737777773777777777777377737773773773737737
53777777375735377377537737777777771777777777757757377577377777777573777777777777777
77777777777777777777777777357777777777777777777777777777777773777777777777777777777
77777777777753771777377777777777757777771771173777717373737777737777777717737777777
77777777777777777777777777777777777777373777777777777777777777777737777777777377757
77777777757777775373737777773777377377537737777777710101417777757757377777771735377
77777777777777777777777777777777777777777777777777777737777777737737777777777777577
57757757377777177173717353775757353737571753657377777737377777777736173773737757377
73777777777777777777777777777777777777777777777777777777377757177573737777577773575
37357373773777777377373777777777777773737377717533763717357353777757771777775377577
77753777777777777777777777777777777777777777777777777777777777777777737377737775735
73753777737777777777773773777577577737353717353577175217437753577377377771737373773
77737537737537777777777777777777777777777777777777777777777777777777777777775715347
17737373737737717377717373777777777777737777375777777777773777377337173737171777377
77777577777375377777777777777777777777777777777777777777777777777777777777777777777
77373777377175757757357737771777757571737777777777737777371735371735717571757771775
37771757737735377777777777777777777777777777777777777777777777777777777777777777777
77777777777753473535377373717353717171735373737777777777777777737777777777777737737
73735373537173773777737777777777777777777777777777777777777777777777777777777777777
77777777777777777777777737777777777777777777777777777777777777777777777777777777777
77777777777777777777777777777777777777777777777777777777777777777777777777777777777
777777777777777777777777777777773535000000000000000000000105000000000000C7AD05FE)
INSERT "Categories"("CategoryID","CategoryName","Description","Picture")
VALUES(2,'Condiments','Sweet and savory sauces, relishes, spreads, and
seasonings',0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D61676500506169
6E742E5069637475726500010500000200000007000000504272757368000000000000000000A029000
0424D98290000000000005600000028000000AC00000078000000010004000000000000000000880B00
00880B00000800000008000000FFFFFF0000FFFF00FF00FF000000FF00FFFF000000FF0000FF0000000000
00007777777777371253533137317735431101053025021053133217143173437171353713731473173
17171717121135301610131217777777770146765074747776567616774776565774040371737031611
73771011010000777777777771743535735353171334303030110311216170535331735334371713537
13703177177373717341250311313521717777777140665447247677767747476577005777647743407
35757100371507530210777777777777777731737317353731704311151303112110431731305317314
17173171717135473171353537310713170301131717777777066457607656747640477614767677767
41740747405733124110021736111377777777777773531671717353371735311631253516153071731
71737171707373173733537023177373737351611010113521737777775245006047474747407777777
76765777574747741656007514120011535110307777777777777737714316173571735346310711313
13033433531713173731071773171731714771353537173707373125031735777773447605470616047
60777777777777764677776007470774033001010035212100777777777777777173563535335371731
05313070707135116534317170177341735771717713017717371771713410171335317377774764007
60474470007777777777777777756675704677607740403010101010531077777777777777737125313
35337171735301531313134334135353361371350735331737137707137353731737433731717377777
77604000040764760477777777777777777746054774356505477601100103121301007777777777777
73535617375347173371613521717127171037373351371370613735731717110735317371717103511
71735373777704740460464746777777777777777777777040667746776007751300530101301300777
77777777777737307171371371713524131103071131760511753351717107535335737373417317353
73737353737737777777704604647404067577777777777777777717776405777404577770001310353
10701007777173777777775353431613717357131630731713735311637317173737171235353353535
72537777777777777777777373777756740470642504677777777777777775777777524657777776771
13501310303113001777773577777777373507717311713375105310713516137355343171317173057
37357377373077777777777777777777777777776540060405646777777777777374777377777774767
77774777107603503111012100017373577777777353530713171737351324335731707317116335371
25717350731717335357357777777777777777777777777777046005640640775777777777777377777
77777424577756771147741121161037100017357733577777773731603521725153251071335213317
07707133537337173217737357373777777777777777773773777777777646046460404647377777777
77777777777377775677766571676474211211211030010357757373777775717116135313373533714
35135351713131471731171735716171773753777777777737777777773777777777774740405674747
77777777777777777737773717656775737047006707012112110001073353171757777737173417353
53533531071277136317353703717371735371073773737777777777737773773771713777777774440
06640464677777777777777777777777777756777774747047741137112116100305737161373777737
17310731353173535247171317117353701717371735373163753577777777777777773773773733717
77777707606504060477777777777777770777773734377777705676747760121016112100101317171
35357777713253425343525353131031717373537171617171371717750537737777777777773737737
73371353777777774440465644046777777777777777777737777157777476404477447071713107130
12101613352530777777571310353131373775347217171735373716371717337373435377777777777
77777737737753713137377777764604646560457777777777777773777373001777574777764477611
30112101000101713513131437777313171631735313531300171735335371716531737171357317377
77777777777777375735333733537177777774654040064007677777777777773777350001377760676
64707640341216131300300035253521707577135271653531161773716173371375335373531717173
75731677377777777777777377373737717131377377777046000044006675777777777777777370001
05777567641006740313113101000101031313135210737777311310527731713713107153771357371
71773353353337717777777777777777773773737333131353353777776764007640456006777777777
73737100001357664456656567134121013130001010352170317007373537173031117317137135273
53773353737253573537571771777777777777777777737373771733171737737773445640464664044
44056477777537301000373405606746764011331352171001201013523152107177735303504373171
35701700533521713530710731737133737777777777777777777337737313731713335335377770640
00044006760006406774710010001714647674445640313010521171003010017031172116171735317
13035316127331710737171717731734071737171777737777777777777777777737377735333531737
77771774665404704644004470046570001611300056444067665313017131130300101030315231134
02171736135304353135135312107173136135353121317137717775777777777777777773737353333
37113713131377777344660240404740064000007003012446064000065641301430121217100303010
11721434130503071352177003531215343134031525170353714071353173777357377777777777773
73737371713373113171717717777145404400646004640747645474076447644746610617111311712
13001100121311331330433171353713107121713013170071631331353113013073173537752777777
77777777777373733737313137173131770737777664660000000040046400646004000047646110012
12121630117104301031043411705103503071317140353530173170343531534171252407353175377
17377373777777777737173537713137113133135371377737771404047400000000440040000046564
61211001611121111130301301211033133313034313513435233403125121071710735321371713130
01317337377775777777777777777371737137371337137171317743537377777766464446000060000
46442564670513430031611030301700012112131170552530043032531351307171335313137007153
51303521107163153573771617377777777777773737373373353131313371370737573773775747460
46407464065464424110303011041112101103031040121125331303131343151131713714071350317
07110712313253121520031173733537777777777777777737737373717373313533531177165373577
77773777757474644565241351312511013001212112121011001315211315253172500530361634316
03353035213102435351611341121435373717777771737777777777777317377373131717313531373
50737173717352573717737353737171343070110212100210130101013020210311612313171134121
71131135313413531135353106130311611301001353537353737077777777777777377737173737333
13713351173405371537173525737375173407073173511302110112017121031030110013125317117
25371124301253717135035215271212170171703130313030703535373777757377777777777773735
73371717131137133317316353735370714257053271716135251330711121121140111350210121104
17130303711353631053313012125304317311353531070311001104110007137371773773777777777
77773773733771733317131335353170143417217317073173535317071353250303071021120120301
31130312433017171137113315043505353717170371310703131605316031703130107137171771773
47777777777777773773773373713313517331371243313353517007170535307007143511315011031
12107111131030105001153012125363757312131303113121051707131716110210110101100300317
13737373771377777777777777777777777737737333153717410117053532170571372535350733121
61213121107100030701251031300612131101331513170525217161613702131343103135143103031
21310140307171717735653777777777777777777775341307071331313130060130305313003411310
30301410531010101210121431113012110313013141213075737773521317121313510535031125121
20210301101010300353173377357317777777777777777777571713101013735353171001125353216
10613161035110031310130103010131003030013112105007031301011317731730717031711612012
13503533531050311021213010471353571373716737777777777777777773731001013515331353000
30110105110012121171212430010300121011030100510131003011300110301300777377717507317
31631350717133031035302110211010121303533733753773177777777777777777777510100000017
33533171104303031212104115301010100112103101010210301030310031101210012101001073173
77737317317115313003161531713071161110350311014335375337717743777777777777777530121
10111000015617137200103110311121203103031210021110010030101010000103110121013000130
13101777177777147135237305352531331703713061210210312131257371375377737777377777777
77350353553717315100017177011003143114301001013110110211020312110110101300101003121
12100030012003037777737377335375317330131351631713150110311301535017353777377377177
77777777777351351313011105335110177113007013130313105317016130705031110103010212100
01212110100101010131011017777777777165371317315707163315313523523112107130133437737
77375377577777777777713171310135371315373103520010113161311032072113131110311212121
01211011003110112121303000310010030773777777371713717173131031533170735301430131125
33535735737173777373773777777731771253531317353353571031312025211352715101134121631
05211111113110121210003100111011100101301010177777377775637717331737071735213317317
43173412131431737377777777775777777777731731311310717377753173715010101317303113304
37133531106317773777773731110013103121210300121210002107777777737331713161716110731
35351731703101013171733525777777652104277777377731713535341717353537357571310100010
35135325031035131737757752501050535773030103101011210021010010103737777777775733573
53317343537173713717071313431217531770500010400140777777377137130113313577777753371
75000100010370351314771377775713400100000000000417531013130313051130100010077777777
77734533173535312535331037531343052135353137777000040014001405777777735171735107135
37717753573310011111113533532113777774340010000000000000000035310510141100301001002
10777777737735335731735217103341737137353413110313535377104700106756207747773537371
71032517537577731773511011000110731735167777161101340010000000000000000070312131300
30121000100177777777777734331731317107353331137103053034310737377707774064560655700
14777753103535113137773711771101110010100171771737777171607000010001000000000000000
13011030061110101001107773777777371771735373173053751637173712531317317177757564674
76765667567047737571107177577777737731300001110011107713777775161011050100000000000
00000000000532131101721000012000777777773777717317353431343133317171717035307173773
77777574740045655675670177373771101034357151357111001001000100177777777735734303434
10100000500000000000001501210011211000101077777777777716353713537353435353533713354
31713535377777770006047606677674073777777771711113173753000001000010100177777777535
30514100000040107000000000000000031350031010010001007777777777737353703733153017353
73171375231737737377777777476504604474656777777777777777777777773000011000000101107
77777573530530374175353107057310000000000001710071030010101010777777777377753713713
57371613713173353350717135377777777777464054076146547777777777777777777757500000000
00000000077777777535775750310352570530077000000000000031001211210003000077773757777
37343711713131716137171753533437173773777777576700766704465625777777777777777777777
73700000000000000007777777777353707757756176357100100000000000005301012100100011007
77777377777735317335361732537173733737117173537777777777550465644767674777777777777
77777777777111300000110101000777777753577753712707100142070070000000010010300713110
10001000037577177737353437135331731517173171717170735377737777777476647467764474777
77577777777777777777173701000130000000077777777777773505741000052510071000000000000
00611210030001000017737371777773716135271711732533537373737307377177777777777752424
46476567777777777777777777777777714101001110000007777777777777071217071030170161700
00000001300105310310101010010717717357177771361311737317161735317171353537373777777
77747654476744644777777777777777777777777713001011010100100777777777777570570110414
16160007100000000417000307101100010000037173713777373341737317137121713737373773777
17777777777777774674446046777777777777777777777777717000000010100100177777775777573
53052431201001015340000000012100171121200100101011735717773375353735317137131613717
17173171737737777777777760074207656567777777777777777777777773710001011010000007777
77777773057052515250340007021000000000050371031011000100000371337107757373521352373
17350713737371773777377777777777765046546046467777777675777777777777773710113110110
11000177777777777573070100612501010005000000001003001310300001000101071771737373773
53571351177173343535373737735773777777777775677466446504775777757777777777777777501
31100000100100077777777771775711753010530400001010000000010010703113100010000003710
73535735373703733371331713737375737717373737777777377656474520464675777477777777777
77777733130100101011100077777777775777716503412520510121042000000000070013521001010
00101017373171737373531617171371713435317337537357777777377377756470064404657777777
77656777777777775111110100011001137777777777757716103521410520004010100000000010103
10130100010100007353773357737735353731731733537377377377373737373773753777774474767
04677777775777777777777771371301001001011017777777777537577134104034001001000000000
00000070003310100010000100317135733177173716015217317135173371737371717777537173777
67674604460447777774677747777777777713111110011010177777777777775777561343110121614
01000100000000010101012121010000000077337335737377373137335353737363573735373737735
33717317775610470004656777777775747777777777711713100010011377777777777777671735141
04014501010000000000000000160171101000100000103573717731777353716135333713535373737
37717353173713717775654065400004677777774707757777777735311010112113777777777777777
53575716125216121000001000100000001001031021000100101000733537737735377353071353533
73371735373737353773117137377656700000040047777656565777777777775313110101117777777
77777777777536352141010014340100000000000000010000311010100000001071775335377373737
17073373571753737371737373531737371777572565000047404677757777767777777777371131131
37777777777777777777775757571610500001000000000000000000010012100001000000003773357
37737777737313571733733717373735353737731353733770567000007400077777677777577777777
73531117777777777777777777777757353701011631010000000000000000000000013101001000001
01053351733537773713530533313531717353737373737131777377777700161407400047777577777
47777777777531377777777777777777777777757347753777717400000000000000000000000010103
00100000100003573631735735737731727173737373533717173735377733373737771614014100347
37777767574657777777735377777777777777777777777777757717577616010000000000000000000
00000003100000001001010173317717377377373711373535353734737371717371377777777777502
11200704737777775677777777777777777777777777777777777777777777177777150100010000000
00000000000000000031030100010210163174316353773771737271733733713135313737373777377
37777733714005001737377777777777777777777777777777777777777777777777775777776142140
10000000000000000000000000011000100010101201771317353737773735311731713713734377737
37377373737737373737371377737777777777777777777777777777777777777777777777777777777
75011210010000000000000000000000000001200100010301211431617353717737353353613733537
33537333777773373737337373737373773737377777747424056777777777777773717330213777777
77777777534353414100010100000000000000000000000100100030101010031736173137375737533
53435373135337773333777733737373373373373733737773777756101000507777777777777776140
50000137777777777775352521025000000000000000000000000000021001001021030311735131477
17373733713217331737377333373773333733333733733737337737737777140004040707477777777
77400000000000400257777777757170714141001000000000000000000000000001003001011010100
61733573313537771713715235733377333733333337333737373737737377737737777743577770747
71757777777000000000000000053775777777161714303001001000000000000000000000000000100
21201210311314121353737173737313253333733337333373373337333373377337373337737777710
77777507757470777770000000000000001100737775775371707105014000000000000000000000000
00000010001013103100357371712535371773173530577337373333333333333373733733373737777
37777777775475725777770477770000000000000000003005777677757717070102101000000000000
00000000000000012101010031031112131213535334373773333737337333337333333373733333737
37373733737777777777734700525741777777000000000000000000100775757777717510160100001
00000000000000000000000000100030310130307171353433035353773731717373333333337337333
33337373337373737777777777777774712535275765777000000000000000000125057777775357125
25014101000000000000000000000000001100010110130101121303131173127777333233233323373
33333333737373333737373737737777777777777140016050257407700050000000000000041003777
77777735710300000000000000000000000000000000203000307130121335341343701771773737333
33333333333333333333333737337373737377377777777777773750172574007471000000000000000
01000075777577575307505101010000000000000000000000000010101211035351010313703113733
33733733333332333333373373373337333337373737373777777777777777747740567006777700000
00000000000000077434777777375303025000001000000000000000000000001303003131212130134
31353673377373323333333333323333333333373333737373737377777777777777776747640424000
47477520000000000000000757570770575355314141001010000000000001000000000001301103521
71313017031373313733332333333233333333333333333733737337373737377377777777777777567
77004774770576705700000000000002177677057777777347130012000000000000003500000000000
01312503521705013135313733733331333332333323333333233733333333373373737373773777777
77774646446400040474067006775050001071617565057770005753573161530501010000000000171
00000000000707125131213130137333273313332333233333333332333733333373737373733733737
73777777777765674000007406764000057576770041650041677777777577777771753521401000000
10000053700000000004241335303513021301373333232333333333333333333332333333333333333
33773377373737777777757474000004656504704756524057470770071257777777777777571771341
43100101000001011743000000000740675307103411101327333133332333233333323323333333373
37337337373733773373777777777742467400470000647047067600770775747747745777777777777
77775347131020500010000035210100000000675740243103130303033323233331333333333233333
33333333333333373333737333737373737777656440400406400047440400410474772474077677677
77777777777747353174351021000100150357000000000046424400431010101013313333233333233
33233333333233332333333733373733373737373777777706400000670400000000070470477777577
07475775777777777777567577570152051052100143150001000000070004005610312131210323333
33323333332133333233333233333337333373337373737373737777444700000040416405600467474
77757556777417677707777777776567467171353413001006143043401000000074000004640210101
00103332303333323133333323333333333333373337373737373733737377377467674046000064064
64067567774777767757746754474077767740524677472572531435250121071000000000004642700
47040121303121333333323333323333333333332333333333373333333333337337373377640444004
00000400400004677777070775676777567777765757425647756705735705717717141050711010000
00000546406767401010010030333331323333323323330333333233373333373737373737373737777
74040000600004640000470047677434475034774434774750676705657740400645717377753430001
21473000000000060000440404210130133332323333333333333333331233333333373373333373337
33737373764200000040060404200064067677674770424577074070477657740677647400641637175
75251010000573500014425604450000046500210130333131323313233333333333333333373333733
37373373733737377774540004400404000040544774774757777405060407744774746576504474760
47764457777752000101013501024674064706400000460410301132337333123333233233233233332
33337333373333733737373373774664400000004000000460467767676776770675424770747725046
56567765400447606406535177777777777000547047400400060047000101203132333333333333333
33333333333333337373373733733373777770004000000000000400000067674776767777657025760
04765406770464004604700440000577777777777777750076000000000007407646001211733330332
33231333333333332333333373333373337737373737374404000000000004064740047767676565765
65640476450765676564407564256740047040477777777777777777104000076476005400446500301
23333333331333233233231233333337333373733737333373737777000040000000000040004000445
74040067647247004167400474040004244756047042474767777777777777777776000404704406460
00006401711303373032333333333333333333333337333337337373737377377654004000000004000
46004600064000400400540470047040076000470047646404004740004377777777777777777040077
04770740074000074012133333137332333333333333323333333337373337333737373377704640004
00000006400400740060043674004076016474007640456074046504705764740406547777777777777
77770404400746440044674046002117303137133133233231233233337373337333337337737373777
70464000004000404000000440044067440004676406474004041006524700000674664564770442777
77777777777777006000470047046704006740130313770323233333333333333332333373333737337
33373773737400000000000004040074567202400460000007400564706776656065646406004007247
04404657777777777777777704046005770600040000567400113711731333033333333333333333333
33733337337373733777404000044000040000044640440470047474400465640060044540456404746
54004744064760006777777777777777777400400674147700707604060307032313733333233233213
23333337337333737337373737773774000400004000004040007000440664046070765647500400602
00640474416004740074765000777777777777777777400000000474640640740044001173130733333
33333333333333373333337333337333737373770600460004604000007006464640045061046404650
64056005644054006467407046564740040647777777777777777400042000076000043400706000331
37535337233313333333333233333373373737373737377777047000406400040000440500650004604
60074004604006544640046700470640470744006647040047777777777777000400404007704000467
44404401307331271333032332332332333337333333333333737373737746640040440065406000646
04604474740500600004600460647400044744005644640240452406400047777776567440006400740
47777047446056700053531713733333333333333333333337373737373733737377774400000000047
67640474654000074644746544004740670450400446740404674654047056400474004656776565642
40640400607777440406106740033127313533333333333333333333333333333333337373777774000
04440000464640004044604464647676766746560404046000476776767677776004646400404656676
646464644400400640404777600004400460011713000000000000000000000105000000000000E0AD0
5FE)
INSERT "Categories"("CategoryID","CategoryName","Description","Picture")
VALUES(3,'Confections','Desserts, candies, and sweet
breads',0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E7
42E5069637475726500010500000200000007000000504272757368000000000000000000A029000042
4D98290000000000005600000028000000AC00000078000000010004000000000000000000880B00008
80B00000800000008000000FFFFFF0000FFFF00FF00FF000000FF00FFFF000000FF0000FF0000000000000
01133307357377777040000000000000060600002520000141313153117160370700212401610753716
17637506357172512171357170173537160000025214002070000012436167777777173333737171773
73737770000111113133013135773770000000000001000005004000633113131331070507343004000
00030707616174335143565375717731717717161671706040767767756770642534371777777373575
31737373753537337113313111111113131235777000043712006767773677777711131531311777377
07704312536170717117777356373737356377717737137473571677170771773563770001677747677
77375313337335373713737175311113131301313161311121630353713500077534771773111371331
71331777777770734772516177777717777352575777357377717537533173777160277767777777043
63567371773753333717135373573735377371311127113113031701311111113113167007367777677
17331131131351377777777714707776167777777771753773753773571777735737570735777756777
77677770365635777677533753537337371737353377377313111123130131313103131313131711770
47767077735353313353133117777777776377717771777777777773535737775777773777735335355
37377377777777777617716375357335333331353173737533713173712711311113135213133101121
31171337003717377771313117113171131777777777177716777777777777777777735353773777777
77777577336577777777777776716067774767317371711733733537377717777531112310312111313
03711313171133131430477657671717153313131331377777777776777777343777777777774375777
77357777777777737357530735777777777776071777737317371733733531737177313733737131113
31311330351113015331131131734307777777313133117135315313777777773537777777777777777
77775377371777777777777777777377777677777777777170616177173313373131733717377373735
73773103111313103132130133071311311313000617277173171731331313111137777777777757175
37777777777773652757717375777577777525753717177773536177725352561671737353533317137
17377171737537133131210113131131131531311313713100006041671131311711317131311777777
75353737736535777173773753752767757377737737777736757777177777776165206353735331317
33713333537375373737377311131113131130131213033130311313170107012701335313313171311
31131717737377735717537735276577652743717177377377777737737536371777777071777165352
73533173731713717133717377317177373121131111121130313131031313313531600076507711317
15313131311311777777771716376377776775371737313616163477757717775775777756707571777
63536134374733531317373133133533737313737353111311031111311113017311153133131311200
12507317133317131713113137773577737753753435373777675756537535736173777737773773577
37773677777767761743717333733173731335335375377133533713111111013130312173107313107
13131341076127713135353135313113135737573735353753777775677435272534734343576775375
77375777735717771717171771707167317131733537317311331373337137131103331313113111113
11331213313131350307165013131313153131131317375737775777773743777371737777536734371
77735377773757737377777777777777771677365353333731737313131335373113133133111111213
53011303310335313111331312161677373135373133131135311777377777373717537717777777777
72535734363477777777777375775777777777777777771657373317131717173331371331733133131
33313311303133111133111331733115313717537777171311711171731313117777777777577377177
77777777777776347757737777777777777377377377777777777777773777173133333373531313313
31333133131112177331331103134137305310531317177377777131353713371313131113777777777
73777777777777777777753577777757777777777777777777777777777777777777777733137135353
73313313131331110103131137701710113113131317331333131337777177731731311311317171131
17777777777777777371777777777737773737373777773777777577777777777777777777735777713
13313133313731313131131110101117733716007712130113053131711431711377777771317131317
31313171131777777777777777777777777773577737777774770737777173737375777777777777777
77777573733131331313735311310311333111111770167700007151313133135313313133117773775
31313135313713131311177777777737777777773535357773777717737737757371777777753777777
77777777777777377735313313131313373113110111131113171607777000072111111134337113131
13377177773531711337131011711317777777777777777537777777377753537735717737777777753
77777357773777777777777777771333133331313131311010111311131116770777000000000033731
31013353533713777373131313135135313631317777777777777371737573773777373737717337317
73753737377377777377775377777777777773733131111313313331311113135335313777734340000
00000001131131113121117173577131713131331317175311777777777773753777737717717171717
13707531753573735371777373777173777773777777777713173133313113013313131113377377177
70135370000000000311371312131313131737137131131717317131713137777773735737773537177
13737373717713335337231717353737775777777777737777777777777331331131111131013131317
57173173343410111313410000041371353135313537375335131731713117135377177777377757377
57717377377777353533317171353111737353717353737377773717173777777777731331311313111
11113111733373571313531313011113430353631313171331133171371333131133133135316311773
77753777773313717353121013131717171312113331313312113777753737777777573777777771331
33311100010111113031177173311011111111031131752575317311315303533771353531731731531
31715331577737737353753537173531133131313313101101101313113131013137735737377737717
73777771133131311111131331131371373713131313013111311313737371173713131317137713131
31531731353137351335357775777133731731313331312111131311011013111111111131303317375
37737777735773777331331333313313313310111717173111111113031111313535377371133121713
13713713135333713713171173711313737331371731313313111111113030101210111110010101011
11111031337135373775307777731311313133313313113131337377531301103111301313131777771
33717131311313113537331713713131071711311311357771371131111010110110111113111131000
11110101000010111121131377777377307377131311331013113133713131117131111313503113317
03530317735313171317113173131117113713135313121317115313113731331301010100101101010
11101011110001110101010101011011113173773577570771111311010133137133311331101710311
31352115213131313131317131353031311353373371137171313131713133131131331310113111131
13012111111031310121131001101010101010110001133717773773717313111110101117373533353
33313135010131116311317353531735335333131353131353171373133131717131111111111111010
11010121012111110101011011131101011001101103710112110101117373773777653113101103137
17313353335313313131317131311307313033121335313535313130353173371153535313131131313
13131701011011111131111010101011011010103110101101103513101535010112371753777713771
11130111313313353335373311013113101213713103131131317335131352133533171711733313313
13131111111121133113011010101011011010100010110110101303001013103113131353101113733
71353705271311113333313533353331713131773073351121531717253537111317133135135303373
31717317171131313113311017521012110101110010101001101000101111211111101013170170103
03121013533737773714713133131113331733537373111311171153311331333113131031713131171
33131715371713717131313113313110113131131110111010111101011001001101010111313013170
10113131311111113331713317777323131131003131331333131337307131130310311213533173131
13131717317125313335313713131313113111010135353101010111010110101010011101001010111
21011013131313101010103121111133517317775071111103131331331133731117111031311353717
13413107112111313131311353571373537131311103101013531131211110101010110101010110001
01101011011110131010113011311131111301031133173353770733111131011311331317113117317
15331313131331731337131217135353121331711735335313131111110311211113010111011010101
01110111010011010131031310111110112101010121013110311331737737707713111113313013013
13110311313101313131311135317135317135313111351713731717317377330101311313031111101
01013010301121101010110101101031010101010101111012111113121110311731317171277313033
11210101313173171311131701616017337335331331313317130353373531733317717311113113011
13103030101011013111101101011130010101131113111010011010010110101011310113331717377
70777757753111111301171131707060707000052001017317315353517311713531731717577337173
10313011011011111311110111101031013110101300001011010121010110010110110101100101311
11131335317757773773771313111137131177777777771670534725353173131331373113535317137
33177533113510111010111010100101101013110131010110111010110131311101000101001101010
01110100230011311377137037777777777777377770707725777777610634305277353535353731737
13713713717773131013133131011101011111131011311101110113101170010110101011011010100
10100101010000110313710113731317177770777375757757777777777736777610717775207353737
13171773535353717313713131013011111011001010101101031101011010110101073113110111011
01001010010101011301031130110733301331377377077774777377343757772577777777770776703
65717377537353713531373537317137311013113030137753110111011111011110110101111117101
00010101101111010101001011011131121100331311011311171771777375777777537777776776776
77770771653737171371713537737717171353311133111301111131337775100110101110010101101
01010133111110101011010100110010101010101211011001101010110337353777777777775777777
77777777777777070773535373773737735317177373733113131101711300101101113733100101101
11010100101011101101010101011010101100111031101011110110011001211010311737752777737
77773577767767777777777705253133717173537131717373353717133111331331101111101313103
57710010101010101100110101701110101101001010101110001101010010100111011111010010335
31777757477777777537777172570777777253171537373737371737753577173735131111101131010
01110103103133710110101001001100101031010101001001010101010111311110110101112110010
11311111131237777375777757777777704725707436531713737177173753535377637371713331313
11110111110130111113101113301010110010011011011101010110111010111110101301301101101
00110111110111013130117537777377777777717250735207177534313535373173513737770717573
73311111111301110101110110310113101013110100110110011011031001010100110110301111301
10110110101100101010110111010107137177777777777170472074257763436712531353171737757
57077373753111313131311010111010110110130101110101110110110113011011011010100101110
11110310110110110110101131310100101011113117177717577753577073512753471777707531753
77371773773773535777773111311313310101010101101101111001101010100101010111010110001
01010101010101101110101100110101011131301101011010130317777734377777707426163430616
17707672717177777777777767377371713113111113110101101001011101111011010131011010101
01010111011011101011101011010101011101101101011111010310110121177177777757777771275
52577777777707353576777777777777717357357373131110121110101011011111001101010010101
11001011101101010010010101111010110110101010011011001031011010100112111177377777777
77775761632777777777777756777357777777777777753777353531310011110110110011001011101
01111001110101111001100101101010101101011110110111031111010103717131011131110111073
13537771717577775257507777777777737377777377777777777773777377331310113121130100110
01101000101001011010101101011101101011001011101010101301312110161010121713011010101
01011031317177717777771717277777277777777774777777777777777777777717353753310101011
21110110111010111010111010101010101010001010100101010011101101011011101311371311525
11011010101310111131031777525737777750777657777777777777777777777777777777773773713
71313101711100100110111101010100010101011101010113010101101010111011010110111011313
11111703130310110101010110101031753777775777777727353777777777773777777777777777777
77735375371357101312101110110110101010100111011011000101111011101000010111011011010
10103130101121213534110110110111112111131537753753775357765743477777777777577777777
77777777777773713331313353535131000110101313110101100010101011101100110101003110110
11011011010111101135211153111370110110100101113011331777577777777735377437777777777
77377373777777777777777577171317773173310311101011011011101011110101110101011101131
11577777370110110101100101013131613536111305301011101011010317017737777777774347034
16736175777275777777777777777777773731313311137153111311110111011011010101131010101
11010103010773773777101101101011101131115313531136351301710101731011317137775777777
77774373436756572773757737777777777777777773737131011311713101035010101011011013107
10101110110010131111773777577313000101110101310121331713431111371721707311011313131
77777177777770341416173737776777377777777777777777777777771313103031031311317737301
01011101313111010110110101010137737727170131101000101101311311037135031701315313152
11101311275777777577777343621616756753577777777777777777777777771737353131115311011
07377775371310313117777131101101101111107375217173101013713101011103110171011314313
15311713313011013113737777777777741615250716352773777777777777777777777777777313130
10730103101351335317351111103533171701701010100101171353737101113537751010101110171
31103531713013011101110111013577757777777772161025277777777777777777777777777777777
73735773513111111101101315335317301035130101311311110101117727773777710112112537371
30101033011031713113531111307112101313777577777777777525075347777777777777777777777
77777777777757331337177301011211010315351213311341113017112125111217135137735313121
13111305377771735110101213170101303011121171101013777735777777702527673477777777777
77777737777777777777773771711331753112110131113112171152113121513125111303111251341
17777011110103113101353711210311171521313101110111031713313577357777777777534737437
77773777737777777777777777777777371737353533101110101012107111031110111133111312111
10301310312133131010101101053353112111310121311111011010110135313111137777777353577
76737577777777777777777777777777777777777777731313133053110111013113112131012110312
51031011101351710101111010011011101311351317111301531113012111011010101311301257777
77577777377374776347777777777777737777777777777777773777713131530101130131113121110
13111311111310111013701303513101011110711031101303103131617131210131101010110101313
01111377777777577777757737573777737777777377777777777777777777177353101311313010110
12105130310112101213011101077717311121073110101103110113011131011313121111310111210
10110311011210717777777777175777635727577777777377777777377777777777777777777771313
17101111031111315310101111111011011377353117121177101100101170101111030131211111121
30110101111701752111311313777777777777773757725727777777777777777777777777777777777
37737311217353101010130301305311303012113017777171713031103101101111313711001011111
01113030110110301010731713112111735777777777777777572775357777377377777737377377777
77777777773775353117171701011101111011313011131110113777713117111035771301010101113
01111010101110111101130111113101737171101317377777777777777772572763537777777377377
77777777777777377377177373713537313510011010131010131010301101777371731121110373053
51011101011312110111010101011011101210131117313731303177777777777775777535571777777
73777777777377777777777777777737777131377171313110110110031110113111101777353310711
52117771313210101011010110101010101010310101011101437113717353137777777777777777276
37377737737773737773777737777737777777773577731317131253530110110111130130110103777
17311531212117353114351121113010131311011010111110111311213133103013713117777777777
77777775717777777777737777377777777777777737373737737777130317113031710110110101101
10010177173152131111131773121311211210111110103011011101010101010110501531530137713
77777777777777777737777777777377373773777737777777777777777773377775313131111313121
10010101101110117771731131303110173111010717117112101101111030103110111011101131211
31317131377777777777777777777777777773777377737777377737737377737373737177777313135
03071053510111011011010107731211210101100172110113131303112513101010011113121130131
01301011121371313777777777777777777777777777777777373735737777377777777377777777737
77777711213111313010711011011010113711211011101101377110101435253521113071311113127
10111011101101211301131373577777777777377777777777777777737377717377377777173737777
17373737717777773113573773531310351011011101713111011001101073570131313113131213113
15212105111110111101011111013571115377777777777777773777777777777777773737343773773
77777773776377737373777777773131735735353103112110101730101110111001117731710352531
43151707352111113121031101211130101735737373377777777773777777777777777777777737717
35357777777773573773773737773717777731117777731735353531112111011101001100113107773
53035131013131313111130301011131031351214131317337573577777777777777377777777777777
77773573737377777777777777777771737373773177777173733531735371307030111031001011101
11050317152171121353170370313031111131310531410353131611371533173777777773777777777
77777777777777737727373707777777777177777337173777771777773117737715317353171101011
01101010103013113773111211713121311110110121210101121131713535317313331737777737737
77737777737737777777777777075357353435777737777171775273737777777777773153173173573
53173121011011010311110134107170317011071113031101111113111211253717735353717117777
77777777735377773777777777777777777377373727373734377577777771737377777777777777773
17353173717353535133010011110301310131121110113031303011011010301010111353713717737
71713777777737773777777777777777777777777777777077735343657377163753571637173777777
77777777777313771737753535373513171010101110131071112113011101111011010111113103071
71775371771733537777777777773737377777777377777777777777370716733532777771417737172
73777777777777777777777113353537371371537171777111103110111301130113031010110737110
12103113131313353773771737777377777377777773777737777777777773777773737376335353517
73011507353737777777777777777777773153735353753737173713737071013103013011310110110
10337177353171775716153533535737771737777373777373777773777777377777777777377734353
17237277735341617317377777777777777777777777773535373537177171717537731313017113513
05031011011757577353535371373133135737337131777777777777777773777777773777777377777
77777733637353537737775353716377777777777777777777777777131377171777137353735735343
07121703035371031037773737173735373777171171331317527777773777773737737777777377777
77777777737777777717073635735303252563737777777777777777777777777777751373773777177
35335735317171717535371735375371735377535777171371731311716371777377773737777777777
73777777777777777377777377777372537236353533531377777777777777777777777777777737353
53753177173753777357177773137353717353753715371737333537717353717067524247777377777
73773773777777773773777777777773777777737127177372521637777777777777777777777777777
77777577737737773173513717353777371435753717173713173735375357533133317373001024107
34377737377777777773777377777777737777737777777777737121010121737777777777777777777
77777777777777736777535373171313717353717777137733353735717177171717377331131001371
00000100074347735777377377377773777777377777777777777773777777773737377777777777777
77777777777777777777777347175737371770717537173537371175735753717373771373733535353
12161742130000000001601377371773777773777777773777777773777777777777777777777777377
77777777777777777777777777777775773472777573717707025371735353733717337173537531717
17573737317170635347100004210716247363737637377737373737777377777773777737777773777
37777770777777777777777777777777777777777377535777777777707353171717373717537357173
53713773737333531370070714253600000010616150377177177377377777777737377377777773777
73773777777777730777777777777777777777777777777777777776717777777777504060312131717
73771733113177771313110103431073474353410410610617772765363637177371737373716773777
37777777777777777737773777017377777777777777377777777777777777777167777777777727371
70757671317737731106013131337176343434034773776776120716100707757371317377177637567
52717353777773777773773777377737777076777377777777777777777777777777777777771777777
77777525677020753673135311677166072147777140774340377677777741676167077773767776172
72337737373737737777777773777777773757377737076173777777777777777777777777777777777
77777777777777777735775277771725317701671077573756763725377347777777772753477127776
77777037017757137373735235237377537773777372777353537777173577737773777737777777777
77777737737777777777777777177617257777777760707707077767777731477561047777777772053
67106577777777705033033237437070737735777336377773777734367776700076773777777777777
77777777777777777177777777737777777774176142770776777307077070773776777430637270777
77777751241637037677577772776530170335373737121253777170377437177353521317000107737
77377777777777777377777777777777777775777777777360121477777535740070525257777177634
10505003437707176012140505717727035001000600343303030035353637163775377763477637767
00700037527377377377737737777773737777777777777777777777761040003070727630100000007
25047617000200000774107767016002100636005347200002010063043430370200717077071275253
53703170716100007737777777777777777777777777777777777777777777777101073001675250534
06003010435243017050701612570367601000005000271417704340140140075143707050014316374
07077037273437670707000014377353737777777777773773773771717777777777777777777777777
05207772521014060707617767070305204036571717771610012415636707371423000210727052572
00200770730700770716370101007076000205367777773777373777777771777777707777777777777
77777777777753070775602101107176171677616153141727767077616707172716107076715070142
52572572570500740700434300707161677677770107001671737373773777773773771677777717171
77177777775777535777777752525210506060167161617010520421635707177010103472577777777
10607016107777777772520703070777000716161777777777707077073737777777777777777773737
77777777777177777777777777070777777777770707171777777777777773573577777777777777773
577777777777717770777777777775257770434000000000000000000000105000000000000E1AD05FE)
INSERT "Categories"("CategoryID","CategoryName","Description","Picture") VALUES(4,'Dairy
Products','Cheeses',0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D61676500
5061696E742E5069637475726500010500000200000007000000504272757368000000000000000000A
0290000424D98290000000000005600000028000000AC00000078000000010004000000000000000000
880B0000880B00000800000008000000FFFFFF0000FFFF00FF00FF000000FF00FFFF000000FF0000FF0000
00000000007777777777777757737757377737737777775777777777777777777777777777777777777
77777777777777777777777777777777777777777777777777777777777173434716174361735707353
43657171737723570000777777773777773777773765377775737717773753753777777777777777777
77777777777777777777777777476572521030602060424347777777777777777777777777357773753
74361705253432163617075727777777737777777737777777777777757775777773573777777777777
77777777777777777777777777777252414121000004060400400000000000406167777777777777717
77635347361753707735275777577777375777777777737777737577177177177173737377717777777
77777777777777777777777777777777777127052430200400604200000000000000000000000000077
77777777777177677371723707705270727173573567737773735777577357773777777777777775775
37777777777777777777777777777777777777752510765024100406006000000000000000000000000
00000000000007777777777171756757577307371717076734737177777777777773577777777377777
77777777777777777777777777777777777777777777777777767610741204200000000000400000000
00000000000000000000000000777777777737736370753525256173577375761773577773577777375
77777775371735737777777777777777777777777777777777777561600000016700604004004004000
00000000000000000000000000000000000000077777777717777737767777376572577273777777777
77377777773573573777777777777777777777777777777777777777777765361777777776500600000
00000000404000000000000000000000000000000000000000077777777757377671717075377777577
57377737777777777777777777777777777777777777777777777777777777777777717257777777771
77770400400002000002020040040000000000000000000000000000000000007777773757757777777
27171777373577777777777777777777777777777777777777777777777777777777777777777567537
77576777560024714200604040404040400000000000000000000000000000000000000000007777777
77373707075676777747727777777777777777777777777777777777777777777777777777777777777
57572536577727757700000164250400000000000000000000000000000000000000000000000000000
00000777737377567377371735377357777777777777777777777777777777777777777777777777777
77777777563763576167675777777000000250200000000000000000000000000000000000000000000
00000000000000007777777777174347777775352717777777777777777777777777777777777777777
77777777777777777737435763573757616706165200756040000000000000000000402000000000000
00000000000000000000000000007777573777377161777677577777777777777777777777777777777
77777777777777777777777777765374357434777077752161257003434246040000400400000000404
00400040000000000000000000000000000000047737734756377707173737777777777777777777777
77777777777777777777777777777777777751614342436525277777561400074034000042040000000
00000000000200200024040000000000000000000000000000377757737356177777756777777777777
77777777777777777777777777777777777777777776163634270716525677577777777777700000000
04252000000400000000400404004020040000000000000000000000000000773735256172716177353
77777777777777777777777777777777777777777777777777771775414340564167014707777777343
57610000000000475244000400040000000000000420424000000000000000000000000007756777361
57777257777777777777777777777777777777777777777777777777777777707363407031670470252
00777757202172507060000000652060004000400404004004000000040004000000000000000000000
07735235363437173717777777777777777777777777777777777777777777777777777767050425074
60143040040434342757100507251000000000470040000000000000000004040002000000000000000
00000000000077775743537477476777777777777777777777777777777777777777777777777777071
07243527421242042420024004142706003005247340000000042000000000000000000000040404000
04000000000000000000000771723536537173537777777777777777777777777777777777777777777
77777177477043425010410400004040043607404140061253043612000000040640000000000000000
00000004040024040000000000000000017677525377777777777777777777777777777777777777777
77777777777777765370434717242024204240030434056070242400402430434161000000000600000
00000000000000000000240000000000000000000000735077253434353577777777777777777777777
77777777777777777777777777346774342401404004000060430652160400000000000010021603400
00000425000000000000000000000400040000000000000000000005270143435370727777777777777
77777777777777777777777777777777770743535360500606034034070434702040000000040040042
41050143402000000065650400000400000000000402040000000000000000000371436352770735777
77777777777777777777777777777777777777777777753477651606100140240724524005040420004
00000000000200203030506000000000616160000000000000000400000000000000000000001634107
10771777777777737773777777777777777777777777777777757776734772410042420407045252160
20020040000000000000400040000303147000000000424700400000000000006040000000000000000
00061527077316703777777777777777777777777777777777777777777773752577716524612500563
47252404004040400000000000000000400040400421252000000000004700240000000000042140000
40000000000001720161256137577777777777777777777777777777777777777777777656777416075
21040256056152434306120102040000000000000000000000000040357340000000000650040000000
00006000000000000000000070525357375727777777777777777777777777777777777777777777537
17777605247470256172562500044044640400000000000000000000000000000000007167070000000
65242040000004074000040000000000000725363757257777777777777777777777777777777777777
77777776567167170250324470765705065612521212035000000000000000000000000000000000000
16165200010605460060000020704000000000000000707075772777777777777777777777777777777
77777777777777777371677564652645217771616070216525674774301000000000000000000000000
00000000070071210770011203461000004047000000000000000017070725775377777777777777777
77777777777777777777777777765653525352141207477743434174707535375310000100000000000
00000000000000000000070041650030677400046000253640000000000000007070737773777777777
77777777777777777777777777777777777771737424060742054735653434374377367657300000000
01000000000000000000000000000000572521210135777770000406437400000000000000070717577
77777777777777777777777777777777777777777777777656534343416520347736747343743571777
74101000000000100000000000000000000000000021701000020317777774204167774000000000000
07252427375377777777777777777777777777777777777777777777537374700424304767705717347
75376777177300000100000000000000000000000000000000034161001210102777777750000567704
00000000000352537577677777777777777777777777777777777777777777777776574300434104317
71773657771675716777700000000100100001001000000000000000000000030021000106177777776
00600000425600000000056102527377177777777777777777777777777777777777777777775363742
52424214757652536577777277357671010010000000100000001000000000000000000000010021021
10377777770070000000004240000012006143571761777777777777777777777777777777777777777
77775752542505252167537565372573577577357300000000000000000000000000000000000000000
00001001020107777777007700000000000000002530002021617777777777777777777777777777777
77777777777777277721425250425367435347577777727777741000000010000010100000001000000
00000000000000001210121777777700000000000700000000704034175777737777777777777777777
77777377777777777777777757705425242035677177677727347777747771001001000000000000100
00000010000000000000000000000121077777774000000000000000004343034034343415777777777
77777777777777777753777777777777777077025241504252563575257577775777177300000000000
01000000001000000000100000000000000000000121777777000000000000000000000070161253736
37777777377737777777777777777777777777777777771670616261434735763777275737777777471
00000010010000000000000000000000100000000000000000000357777770000000000000000000000
76161253577777777777777777737777777777777777777777777777671416141600707617567357274
73777777300010000000000001000000001000010000010100000000000000002777770000000000000
00000000000170777763777737357353757357777777777777777777777777777753422507241707716
43775775777575777750000010000000000001000000000000000000000101240000000000002177600
00000000000000000000067073435757777777777773777777777777777777777777777777777674506
15242506717653672771777377737010000000000010000000100000000000001000000001000000000
00040407000000002400000400000001610777737735777777777777777777777777777777777777777
77771730706250425167056577577671675757700000001000100000000000000000000000000100000
01010000000000000040100000176000377000770352525347777777777777777777777777777777777
77777777777777765607142525243563527077777777277771001000000000000010000000001100000
00000001000000000000000000402524000076100047400070776025377377777777777777777777777
77777777777777777307757775307406160043463527577757753577707000000000000000000000000
00001000000000000001000000100000000002524000000700003700000776175777775777777777777
77777777777777777777777777747167737765025341652417567527076777677577700000000000000
10000000000000010000000000000000010001001200061420000000000000000000003161207052777
77777777777777777777777777777777737771761774777770243612526074365775377777725773010
21000010000000000000000000000000000000000000000010010000614000000000000000025060616
57127052777777777777777777777777777777777775770777065707776561405601416165252765777
57777710001000000000000000000000000000000000000000000001000010256706000000000177377
43521000012061073577777777777777777777777777777771777770737017527561773473605606052
57653563477777070000100000000000000000000000001100000000000000001001010216100000000
00060604343777777777753577167777777777777777777777777777777777777577772025361705670
40761614252416525777365777101000100000000001000000000000000000000000000000000000016
36160000000000000000000424343437763071777777777777777777777777777177777777721747570
25707771772503616342524365252577777770001000100100010000000000000000000000000000000
00000001014040000000000000000000000000000017572777777775775775777777777777777777357
73577737051207430653524507041425241616525074743101000000000000000000000000000000000
00000000000000001020202060000000000000000000000000747737577777777377373737777777777
77777757735767777520250701613477702407243401606525673717733001010010000000000000000
00000000000000000000000010001040040000700000000000000000000077767777777577777777777
37777777777773777777771716174350707614616165707052417605006525656367373000000001000
01000000000000000000000000000000000010020400750177000037400000200000777725077777737
77773573757777777777735777737777007007342100170352573657070524016070024343571733733
21010000100000000000000000000000000000000000000100007776007720000760000075000074375
61737777777737773573737777777357777777653077016352506106160700527252425256070434107
06074773773610010000000000000000000000000000000000000100000777777700774000177000017
60007777421677577777777773773535777777777377770753416006007052106100172525057775252
01407070604074343733333210000010010000000000000000000000000000000101377777700077000
06770000777005777425621777773737777717373737777777743777777034177171030060125614165
25255275257603404347070243427777373230100000000000100000000000000000000000000037777
77700172000177000037700277770015673777757735373517175377777777050537704361434340701
04030612101612416070757434343434707056173773737321210000000000000000000000000000000
10100777777743000000003570000776165777702305773773615343437070377777775302777707253
43416034367374107070616136116162525243406107072561737737373610001001000000000000000
00001000000000177777777000000000000000075425367700456375773717273537073171777777361
41777705061603014141004127152717004006525535253416146052502437737737333731200000000
01000000000000000100001037777767400000000020203407025767706127347361577775775771743
41777770521257772171616577273430034020142534352101207614216167376167534217337377737
63121000100000000000000000000010037777777770000000000014000025275347043471771723537
73637773737717777705252775765071777750014125351603421000524052052147041750701777777
77773337333733733000001000000010010000100007777777576700720000002102141652752430525
63777777753575737577527777070252577777377771712030205076705010477725372161061021252
74167777777737777377737727333121001000100000010000037777777777700574000000560002002
56341402527535377353773735777377774030050177677177777772514101200103777777775705050
16124147041270777757377737377333733737373325001000001000001017777777776770027200000
03740001757700020167527775576717757773757753774702767171777777737120374001420577402
17737727060041020003040775773777357373377737737372373333431010001010037777777765776
10575000000777000602774001245277735335377173717777737773777535777777777765757176300
21002127106124105351610614343430007377775777777773373337373773737333323030030377777
77777777576002700000007740305057730003052557677771777477717377775777777777777777757
37307010410400041765125124342010707253400043777573771737737773777373733337373637337
33777777777757777277703710000007770000267774000063573537771767173537757777775377777
71737777377740170000630000377025724103416000057052573775737777777535733773337373776
37373333737777777777777747757700000000000377000251777200053472777177771777777777777
37777777777757177775712700300107503041614071006170700120061007777377535357377737773
77737373337333773737777777777777777777777000000000000300142437740002437577177777717
35735371777777777777777777777375173400000761430003770701007401040100070371777377773
74353537173737373773377337777777777777777777777677652000000003000303034743401074377
77777777775735777777777717777777777753567721737000000037430070707352037421000125075
76177717771773727173737373733773143777757777777777777777775770000000000000040404307
61200017477777777777777777777777777777777777777777305074300010007534010000060041431
00340003773777537712771717535277373717531343777777777777777777777777774100000000100
00303430741000256737777777777777777777777777777777777777777175201341002503770000010
01040020160700000017717377537571727136171163527330773177777777777777775777747777720
16000006000007000743600012074777777777777777777777777777777777777771612052412410735
70077200000003010001017010007077571737173617375373735371165310705777777777777777777
57777777502750000160000070003470000743777777777777777777777777777777777773753777752
10241277727777050000000000000000700000375363743563537152317071253731357317377777777
77777777777777777706176000077000077002437000003567777777777777777777777777777777717
77777714214341205001434170070060050000000016000175273573773537163756135353525343317
07777777777777737777777777776174300007700034740535770003473777777777777777777777777
77777777777353416350343075214210002500101020600000000000307371771753534173513357361
73535317431777775777777765777777757777003740000777000777024767100436577777777777777
77777777777777777777577672507701617742104371020060000100100000000000707352712737371
73653253534317252134377777777777777777777777777774077000077700077701257760014377777
77777777777777777777777777717377617437001616141006304070501070506100201025000177163
53753525361713533533172531717117777377777777777577777777774300000000700007770607775
00425677777777777777777777777777773777777001717170000003060175030021610021006141251
72114734717353771735343525703471531707076777757677777777777777776577300000000000000
17270537760021617777777777777777777777777777777771710024361614000001700250757576014
07012161274576377137257343305371375317713235217131177437777757777777777757777743000
000000000...
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
Great! Studypool always delivers quality work.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Content
write a discussion
All networking specialists need to be familiar with IPV6 because it is the future of networking. So why are new homes and ...
The Collatz Sequence of Positive Integers Java Programming Exercise
this is a small question about The Collatz sequence. please just do the coding part. please do the comments. please use ...
UCM Python Program Project
Instructions:You need to write one Python program per question. Each program should be written in IDLE or be IDLE compatib...
Capilano University Rock Paper Scissors Python Game Project
In this project you may work alone or with a partner to complete ONE of the following projects:Develop a Python program th...
Job Duties
Please see the below and write the job duties and how it matches with my education courses in bachelors and mastersPlease ...
Slove layout problems
Please help me solve attached layout bug for the text view, you should also test the app using Android Studio....
Online Scavenger Hunt
Q2b. Here are the key words “Large chain hardware store in Albuquerque” Q2d. The search engine that was used is Google...
Description
2. take all the folders and put in main folder 4. Navigate to the main in desktop using cmd cd /Desktop/main...
21995460
Sustainability is a term that is used to define the ability of a product or a service to remain relevant, or its quality t...
