QUESTION $4$

Consider the following relational schema for a company:

Customer $($CustCode$,$ CustName, CustAdress, Payment Method$)$

Product $($ProductCode$,$ ProductName, UnitPrice, UnitCost$)$

CustomerOrder $($OrderNo$,$ CustCode, ProductCode, QtyOrdered$)$

The primary keys are underlined.

Write SQL queries to answer the following:

$($a$)$ Create Customer, Product, and Order tables from the relational schema described above. Select appropriate data types for each attribute. Remember to set the primary and foreign keys.

$($b$)$ List the Customers Name and address where the addresses contain the word Cork.

$($c$)$ List the order Number and Net $($Price of an item less its cost$)$ profit of each Customer Order.

$($d$)$ Write the statement to update the unit price of ProductCode $S106$ by $2.$