This topic contains a solution. Click here to go to the answer

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

humphriesbr@me.com

  • Hero Member
  • *****
  • Posts: 550
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?



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

aidanmbrowne

  • Sr. Member
  • ****
  • Posts: 305
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

  • Member
  • Posts: 550
Reply 2 on: Jul 7, 2018
Great answer, keep it coming :)


ghepp

  • Member
  • Posts: 361
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

Malaria was not eliminated in the United States until 1951. The term eliminated means that no new cases arise in a country for 3 years.

Did you know?

Lower drug doses for elderly patients should be used first, with titrations of the dose as tolerated to prevent unwanted drug-related pharmacodynamic effects.

Did you know?

The first documented use of surgical anesthesia in the United States was in Connecticut in 1844.

Did you know?

Pubic lice (crabs) are usually spread through sexual contact. You cannot catch them by using a public toilet.

Did you know?

Astigmatism is the most common vision problem. It may accompany nearsightedness or farsightedness. It is usually caused by an irregularly shaped cornea, but sometimes it is the result of an irregularly shaped lens. Either type can be corrected by eyeglasses, contact lenses, or refractive surgery.

For a complete list of videos, visit our video library