[Solved]Question 5 Using Sql Create Table Command Create Products Table Question 6 Using Sql Creat Q37215155

Question 5. Using SQL create table command, create the Productstable

Question 6. Using SQL create table command, create theOrderedProduct table. During the create, establish OrderID +ProductID as a composite primary key. Table: OrderedProduct

Question 7. Establish an index on the customer name that willalso not allow null values. Call the index CustName. HINT…**Use theUnique keyword**

Question 8. Establish an index on the OrderID column of theOrderedProductstable. Establish a similar index on the ProductIDcolumn of the same table. (This is 2 separate index createcommands)

Question 5. Using SQL create table command, create the Products table Table: Product Data Int Va straints ProductID 30 UnitsOnHand UnitsOnOrder UnitoMeasure ReorderPoint UnitCost Question 6. Using SQL create table command, create the Ordered Product table. During the create, establish OrderlD +ProductID as a composite primary key Table: OrderedProduct Data Int Inte Constraints OrderID ProductID NumberOrdered eference to the Order table key reference to the Product table uotedPrice Money Question 7 Establish an index on the customer name that will also not allow null values. Call the index CustName. HINT. *Use the Unique keyword Question 8. Establish an index on the OrderID column of the OrderedProducs table. Establish a similar index on the ProductID column of the same table. This is 2 separate index create commands) Show transcribed image text Question 5. Using SQL create table command, create the Products table Table: Product Data Int Va straints ProductID 30 UnitsOnHand UnitsOnOrder UnitoMeasure ReorderPoint UnitCost Question 6. Using SQL create table command, create the Ordered Product table. During the create, establish OrderlD +ProductID as a composite primary key Table: OrderedProduct Data Int Inte Constraints OrderID ProductID NumberOrdered eference to the Order table key reference to the Product table uotedPrice Money Question 7 Establish an index on the customer name that will also not allow null values. Call the index CustName. HINT. *Use the Unique keyword Question 8. Establish an index on the OrderID column of the OrderedProducs table. Establish a similar index on the ProductID column of the same table. This is 2 separate index create commands)

Expert Answer

---

Answer to Question 5. Using SQL create table command, create the Products table Question 6. Using SQL create table command, create… . . .