SCustomerT PK...

S_Customer_T PK Customer_ID Customer_Name Customer_Address Customer_City Customer_State Postal_Code S_Product_T PK Product_ID Product_Description Product_Finish Standard_Price S_Order_T PK Order_ID Order_Date FK Customer_ID S_Order_Line_T PK, FK Order_ID PK, FK Product_ID Order_Quantity

Thanks for your feedback!

Please don't use handwriting. Unique Answer. 1- Transform it into a Relational data model and transform it into normalized form. Write the SQL commands to create each table after normalization. Write an insert command to add 5 rows in each of the tables. Write a delete command to delete a row from each table. Write the commands to query the following values. 2- Show product id and finish date for all products. 3. Show product id and finish for all products, sorted by product_line_id in ascending order. 4. Show product id and finish for all products, sorted by product_line_id in descending order. 5. Show each product_line_id and the total number of products for the product_line_id. S_Customer_T S_Order_T PK Customer_ID PK Order_ID Customer_Name Order_Date Customer_Address FK Customer_ID Customer_City Customer_State Postal_Code S_Product_T S_Order_Line_T PK Product_ID PK,FK|Order_ID Product_Description PK,FK Product_ID Product_Finish Order_Quantity Standard_Price

Play audio

Feedback

Question

S_Customer_T PK Customer_ID Customer_Name Customer_Address Customer_City Customer_State Postal_Code S_Product_T PK Product_ID Product_Description Product_Finish Standard_Price S_Order_T PK Order_ID Order_Date FK Customer_ID S_Order_Line_T PK, FK Order_ID PK, FK Product_ID Order_Quantity

Please give Ace some feedback