b) Write the syntax to create a table named Product in SQL with the following restrictions; Product(pid, pname, price, packaging, colour, manufacture_date, supplier, country_manufacture) Where pid is...

do part ( v- vii)

Extracted text: b) Write the syntax to create a table named Product in SQL with the following restrictions; Product(pid, pname, price, packaging, colour, manufacture_date, supplier, country_manufacture) Where pid is the primary key. pname and manufacture_date do not accept null values. price is greater than Rs 350. packaging accepts only box or bag entries. The default colour is "Red". Page 3 of 5 Consider the schema of Product table in section (b), write SQL statements for the following queries. i. List the name of the products supplied by CFL Ltd. ii. List the details of blue coloured products in bag packaging. i. Display the name of the suppliers from india or china. iv. List the details of all the suppliers whose names have "" in the second position. v. Display the details of the products with price between Rs 450 and Rs 900. vi. Display details of the red coloured products that were manufactured on 20 Oct 2020 or price is greater than Rs 600. vii. List the pid and name of suppliers of box packaging products in ascending order by country.