The Tables:

CREATE TABLE Customer_T

(CustomerID NUMBER(11,0) NOT NULL,

CustomerName VARCHAR2(25) NOT NULL,

CustomerAddress VARCHAR2(30) ,

CustomerCity VARCHAR2(20) ,

CustomerState CHAR(2) ,

CustomerPostalCode VARCHAR2(10) ,

CONSTRAINT Customer_PK PRIMARY KEY (CustomerID));

CREATE TABLE Order_T

(OrderID NUMBER(11,0) NOT NULL,

CustomerID NUMBER(11,0) ,

OrderDate DATE DEFAULT SYSDATE ,

CONSTRAINT Order_PK PRIMARY KEY (OrderID),

CONSTRAINT Order_FK1 FOREIGN KEY (CustomerID) REFERENCES Customer_T(CustomerID));

CREATE TABLE Product_T

(ProductID NUMBER(11,0) NOT NULL,

ProductLineID NUMBER(11,0) ,

ProductDescription VARCHAR2(50) ,

ProductFinish VARCHAR2(20) ,

ProductStandardPrice DECIMAL(6,2) ,

CONSTRAINT Product_PK PRIMARY KEY (ProductID));

CREATE TABLE OrderLine_T

OrderID NUMBER(11,0) NOT NULL,

ProductID NUMBER(11,0) NOT NULL,

OrderedQuantity NUMBER(11,0) ,

CONSTRAINT OrderLine_FK1 FOREIGN KEY (OrderID) REFERENCES Order_T(OrderID),

CONSTRAINT OrderLine_FK2 FOREIGN KEY (ProductID) REFERENCES Product_T(ProductID));

The Data:

-- Table: Customer_T

INSERT INTO Customer_T VALUES(1,'Contemporary Casuals', '1355 S Hines Blvd', 'Gainesville', 'FL', '326012871');

INSERT INTO Customer_T VALUES(2,'Value Furniture', '15145 S.W. 17th St.', 'Plano', 'TX', '750947743');

INSERT INTO Customer_T VALUES(3,'Home Furnishings', '1900 Allard Ave.', 'Albany', 'NY', '122091125');

INSERT INTO Customer_T VALUES(4,'Eastern Furniture', '1925 Beltline Rd.', 'Carteret', 'NJ', '070083188');

INSERT INTO Customer_T VALUES(5,'Impressions', '5585 Westcott Ct.', 'Sacramento', 'CA', '942064056');

INSERT INTO Customer_T VALUES(6,'Furniture Gallery', '325 Flatiron Dr.', 'Boulder', 'CO', '805144432');

INSERT INTO Customer_T VALUES(7,'Period Furniture', '394 Rainbow Dr.', 'Seattle', 'WA', '979545589');

INSERT INTO Customer_T VALUES(8,'California Classics', '816 Peach Rd.', 'Santa Clara', 'CA', '969157754');

INSERT INTO Customer_T VALUES(9,'M and H Casual Furniture', '3709 First Street', 'Clearwater', 'FL', '346202314');

INSERT INTO Customer_T VALUES(10,'Seminole Interiors', '2400 Rocky Point Dr.', 'Seminole', 'FL', '346464423');

INSERT INTO Customer_T VALUES(11,'American Euro Lifestyles', '2424 Missouri Ave N.', 'Prospect Park', 'NJ', '075085621');

INSERT INTO Customer_T VALUES(12,'Battle Creek Furniture', '345 Capitol Ave. SW', 'Battle Creek', 'MI', '490153401');

INSERT INTO Customer_T VALUES(13,'Heritage Furnishings', '66789 College Ave.', 'Carlisle', 'PA', '170138834');

INSERT INTO Customer_T VALUES(14,'Kaneohe Homes', '112 Kiowai St.', 'Kaneohe', 'HI', '967442537');

INSERT INTO Customer_T VALUES(15,'Mountain Scenes', '4132 Main Street', 'Ogden', 'UT', '844034432');

-- Table: Order_T

INSERT INTO Order_T VALUES (1,4,'Sep-08-09'); INSERT INTO Order_T VALUES (2,3,'Oct-04-09'); INSERT INTO Order_T VALUES (3,1,'Jul-19-09'); INSERT INTO Order_T VALUES (4,6,'Nov-01-09'); INSERT INTO Order_T VALUES (5,4,'Jul-28-09'); INSERT INTO Order_T VALUES (6,4,'Aug-27-09'); INSERT INTO Order_T VALUES (7,1,'Sep-16-09'); INSERT INTO Order_T VALUES (8,4,'Sep-16-09'); INSERT INTO Order_T VALUES (9,6,'Sep-16-09'); INSERT INTO Order_T VALUES (19,4,'Mar-05-10'); INSERT INTO Order_T VALUES (20,4,'Mar-06-10'); INSERT INTO Order_T VALUES (21,4,'Mar-06-10'); INSERT INTO Order_T VALUES (22,4,'Mar-06-10'); INSERT INTO Order_T VALUES (23,4,'Mar-06-10'); INSERT INTO Order_T VALUES (24,1,'Mar-10-10'); INSERT INTO Order_T VALUES (25,4,'Mar-10-10'); INSERT INTO Order_T VALUES (26,4,'Mar-10-10'); INSERT INTO Order_T VALUES (27,4,'Mar-10-10'); INSERT INTO Order_T VALUES (28,4,'Mar-10-10'); INSERT INTO Order_T VALUES (29,4,'Mar-11-10'); INSERT INTO Order_T VALUES (30,4,'Mar-11-10'); INSERT INTO Order_T VALUES (31,15,'Mar-11-10'); INSERT INTO Order_T VALUES (32,15,'Mar-11-10'); INSERT INTO Order_T VALUES (34,15,'Mar-11-10'); INSERT INTO Order_T VALUES (35,8,'Mar-11-10'); INSERT INTO Order_T VALUES (36,4,'Mar-11-10'); INSERT INTO Order_T VALUES (37,4,'Mar-11-10'); INSERT INTO Order_T VALUES (38,4,'Mar-11-10'); INSERT INTO Order_T VALUES (39,4,'Mar-11-10'); INSERT INTO Order_T VALUES (40,4,'Mar-11-10'); INSERT INTO Order_T VALUES (41,12,'Mar-11-10'); INSERT INTO Order_T VALUES (42,4,'Mar-11-10'); INSERT INTO Order_T VALUES (43,12,'Mar-11-10'); INSERT INTO Order_T VALUES (44,6,'Mar-11-10'); INSERT INTO Order_T VALUES (45,12,'Mar-11-10'); INSERT INTO Order_T VALUES (46,1,'Mar-11-10'); INSERT INTO Order_T VALUES (47,12,'Mar-11-10'); INSERT INTO Order_T VALUES (48,1,'Mar-11-10'); INSERT INTO Order_T VALUES (49,4,'Mar-11-10'); INSERT INTO Order_T VALUES (50,8,'Mar-11-10'); INSERT INTO Order_T VALUES (51,16,'Mar-11-10'); INSERT INTO Order_T VALUES (52,16,'Mar-11-10'); INSERT INTO Order_T VALUES (53,16,'Mar-11-10'); INSERT INTO Order_T VALUES (54,16,'Mar-11-10'); INSERT INTO Order_T VALUES (55,16,'Mar-11-10'); INSERT INTO Order_T VALUES (56,9,'Mar-11-10'); INSERT INTO Order_T VALUES (57,9,'Mar-11-10'); INSERT INTO Order_T VALUES (58,14,'Mar-11-10'); INSERT INTO Order_T VALUES (59,13,'Mar-11-10'); INSERT INTO Order_T VALUES (63,4,'Mar-11-10'); INSERT INTO Order_T VALUES (64,4,'Mar-11-10'); INSERT INTO Order_T VALUES (65,4,'Mar-11-10'); INSERT INTO Order_T VALUES (66,9,'Mar-11-10'); INSERT INTO Order_T VALUES (69,4,'Mar-11-10');

-- Table: Product_T

(ProductID, ProductLineID ,ProductDescription , ProductFinish , ProductStandardPrice )

INSERT INTO Product_T VALUES (1, 1, 'End Table', 'Cherry', 175);

INSERT INTO Product_T VALUES (2, 2, 'Coffee Table', 'Natural Ash', 200);

INSERT INTO Product_T VALUES (3, 2, 'Computer Desk', 'Natural Ash', 375);

INSERT INTO Product_T VALUES (4,3, 'Entertainment Center', 'Natural Maple', 650);

INSERT INTO Product_T VALUES (5, 1,'Writers Desk', 'Cherry', 325);

INSERT INTO Product_T VALUES (6,2, '8-Drawer Desk', 'White Ash', 750);

INSERT INTO Product_T VALUES (7, 2,'Dining Table', 'Natural Ash', 800);

INSERT INTO Product_T VALUES (8,3, 'Computer Desk', 'Walnut', 250);

-- Table: OrderLine_T

INSERT INTO OrderLine_T VALUES (1, 1, 2);

INSERT INTO OrderLine_T VALUES (1, 2, 2);

INSERT INTO OrderLine_T VALUES (1, 4, 1);

INSERT INTO OrderLine_T VALUES (2, 3, 5);

INSERT INTO OrderLine_T VALUES (3, 3, 3);

INSERT INTO OrderLine_T VALUES (4, 6, 2);

INSERT INTO OrderLine_T VALUES (4, 8, 2);

INSERT INTO OrderLine_T VALUES (5, 4, 3);

INSERT INTO OrderLine_T VALUES (6, 4, 1);

INSERT INTO OrderLine_T VALUES (6, 5, 2);

INSERT INTO OrderLine_T VALUES (6, 7, 2);

INSERT INTO OrderLine_T VALUES (7, 1, 3);

INSERT INTO OrderLine_T VALUES (7, 2, 2);

INSERT INTO OrderLine_T VALUES (8, 3, 3);

INSERT INTO OrderLine_T VALUES (8, 8, 3);

INSERT INTO OrderLine_T VALUES (9, 4, 2);

INSERT INTO OrderLine_T VALUES (9, 7, 3);

INSERT INTO OrderLine_T VALUES (10, 8, 10);