1. Create the TopLevelCust view described in Review Question 2. Display the data in the view.

CREATE VIEW TopLevelCust AS
SELECT CustomerNum,CustomerName, Street, City, State, Zip, CreditLimit
FROM Customer

2. Create the PartOrder view described in Review Question 3. Display the data in the view. CREATE VIEW PartOrder AS
SELECT Part.PartNum, Part.Description, Part.Price, OrderLine.OrderNum, OrderLine.NumOrdered, OrderLine.QuotedPrice, Orders.OrderDate
FROM Orders INNER JOIN (Part INNER JOIN OrderLine ON Part.[PartNum] = OrderLine.[PartNum]) ON Orders.[OrderNum] = OrderLine.[OrderNum];

3. Create a view named OrdTot. It consists of the order number and order total for each order currently on file.
(The order total is the sum of the number ordered multiplied by the quoted price on each order line for each order.) Display the data in the view.
SELECT OrderNum,NumOrdered, QoutedPrice, NumOrdered*QuotedPrice AS OrderTotal
FROM

4. Create the following indexes. If it is necessary to name the index in your DBMS, use the indicated name.
a. Create an index named PartIndex1 on the PartNum field in the OrderLine table.
CREATE INDEX PartIndex1
ON OrderLine (PartNum)

b. Create an index named PartIndex2 on the Warehouse field in the Part table.
CREATE INDEX PartIndex2
ON Part (Warehouse)

c. Create an index named PartIndex3 on the Warehouse and Class fields in the Part table.
CREATE INDEX PartIndex3
ON Part (Warehouse,Class)

d. Create an index named PartIndex4 on the Warehouse and OnHand fields in the Part table and list units on hand in descending order.
CREATE INDEX PartIndex4
ON Part (Warehouse, OnHand DESC)

5. Drop the PartIndex3 index.
DROP INDEX PartIndex3 ON Part

6. Assume the Part table has been created, but there are no integrity constraints. Create the necessary integrity constraint to ensure that the only allowable