Author Question: Structured English can be more complex if blocks of (instructions) are ________ within each other to ... (Read 23 times)

humphriesbr@me.com · **on:** Jul 7, 2018

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 · **Reply #1 on:** Jul 7, 2018

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);