Q$2.$ Consider the following relational database for a Human Resources System.

Each primary key is specified with a key icon.

The one$-$to$-$many relationships are specified by using

Note that in this question, the names of foreign key are coincidentally the same as the names

of primary key being referenced.Q$2.$ Consider the following relational database for a Human Resources System.

Each primary key is specified with a key icon.

The one$-$to$-$many relationships are specified by using

Note that in this question, the names of foreign key are coincidentally the same as the names

of primary key being referenced.

Write SQL commands to answer the following queries.

$($a$)$ Create table 'countries' with foreign key constraint using reference option of cascade

for both update and delete. If there exists a table $`$countries$\text{'},$ remove it before

creating one.

The following is the structure of the table 'countries'. Please use the data types in the

following table and ignore the data types specified in the diagram above.

$(5$ marks$)$

$($b$)$ Insert a record with the following values into the table against each

column.