Part-1 (8 Marks) Part a:- Create database tables in your designated section with appropriate relationships(5 Marks):-...

Transcribed Image Text:

Part-1 (8 Marks) Part a:- Create database tables in your designated section with appropriate relationships(5 Marks):- ORDER Order D OrderDate ORDER LINE Order D ProductID OrderedQuantity PRODUCT ProductID Product Description ProductFinish ProductStandard Price ProductLinelD Make sure to pick right datatype for each column considering what kind of input you are expecting in that column as per real world needs. Following constraints should be satisfied: - a. OrderID and ProductID ORDERLINE table is a composite and foreign key. b. OrderDate in ORDER table should not be empty. c. OrderQuantity in OrderLine table should always be >0 d. ProductStandard Price in PRODUCT table should be >=0.0 Part b. (3 Marks) a. Issue command to new a new column - ProductColor in Product table without dropping the table. b. Issue command to drop column ProductColor from Product table which you just created in above steps. c. What will be the output for the following command Considering there are some records in the Orderline table; - I Update OrderLine set OrderedQuantity=-1; Part-2 (3 Marks) Insert minimum 2 products, 2 orders and 2 rows in OrderLine table with any values of your choice. Part-3 (2 Marks) Issue command to delete complete data from products table and observe the output and explain the reason for the output. Once you are done paste commands and output screenshots both on word document and upload the word document. One document would be enough for all screenshots. Part-1 (8 Marks) Part a:- Create database tables in your designated section with appropriate relationships(5 Marks):- ORDER Order D OrderDate ORDER LINE Order D ProductID OrderedQuantity PRODUCT ProductID Product Description ProductFinish ProductStandard Price ProductLinelD Make sure to pick right datatype for each column considering what kind of input you are expecting in that column as per real world needs. Following constraints should be satisfied: - a. OrderID and ProductID ORDERLINE table is a composite and foreign key. b. OrderDate in ORDER table should not be empty. c. OrderQuantity in OrderLine table should always be >0 d. ProductStandard Price in PRODUCT table should be >=0.0 Part b. (3 Marks) a. Issue command to new a new column - ProductColor in Product table without dropping the table. b. Issue command to drop column ProductColor from Product table which you just created in above steps. c. What will be the output for the following command Considering there are some records in the Orderline table; - I Update OrderLine set OrderedQuantity=-1; Part-2 (3 Marks) Insert minimum 2 products, 2 orders and 2 rows in OrderLine table with any values of your choice. Part-3 (2 Marks) Issue command to delete complete data from products table and observe the output and explain the reason for the output. Once you are done paste commands and output screenshots both on word document and upload the word document. One document would be enough for all screenshots.

Answer rating: 100% (QA)

Based on the information provided in the images heres how you can create database tables for ORDER ORDERLINE and PRODUCT insert data into these tables and perform certain SQL commands as specified Par... View the full answer