1drop table Parts 2drop table Lines 3drop table Customers 4drop table Sales 5 6CREATE TABLE Parts ("PartNumber" VARCHAR(255), "Description" VARCHAR(255), "Price" VARCHAR(255)) 7CREATE TABLE Lines ("SalesOrderID" integer, "LineNumber" VARCHAR(255), "PartNumber" VARCHAR(255),"Quantity" VARCHAR(255)) 8CREATE TABLE Customers ("CustomerID" integer, "Name" VARCHAR(255), "Street" VARCHAR(255), "City" VARCHAR(255), "State" VARCHAR(255), "PostalCode" VARCHAR(255)) 9CREATE TABLE Sales ("SalesOrderID" integer, "OrderDate" datetime, "CustomerID" integer) 10