Structured English can be more complex if blocks of ...

[humphriesbr@me.com]

Structured English can be more complex if blocks of (instructions) are ________ within each other to show hierarchy.
 
  A) nested
  B) grouped
  C) selected
  D) placed

Question 2

Show the CREATE TABLE statements for HAPPY INSURANCE database for the table CLIENT (assume that non-primary key columns can be optional) with the DELETE SET-TO-NULL and UPDATE CASCADE option for its referential integrity constraint.
 
  What will be an ideal response?

[aidanmbrowne]

Answer to Question 1

A

Answer to Question 2

CREATE TABLE client
(clientid CHAR(4),
clientname CHAR(10),
clientagent CHAR(2),
clientspousename CHAR(10),
PRIMARY KEY (clientid),
FOREIGN KEY (clientagent) REFERENCES agent
ON DELETE SET NULL
ON UPDATE CASCADE);

[humphriesbr@me.com]

Excellent

[atrochim]

TYSM