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 79 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
Excellent


pangili4

  • Member
  • Posts: 346
Reply 3 on: Yesterday
Great answer, keep it coming :)

 

Did you know?

Giardia is one of the most common intestinal parasites worldwide, and infects up to 20% of the world population, mostly in poorer countries with inadequate sanitation. Infections are most common in children, though chronic Giardia is more common in adults.

Did you know?

Once thought to have neurofibromatosis, Joseph Merrick (also known as "the elephant man") is now, in retrospect, thought by clinical experts to have had Proteus syndrome. This endocrine disease causes continued and abnormal growth of the bones, muscles, skin, and so on and can become completely debilitating with severe deformities occurring anywhere on the body.

Did you know?

Thyroid conditions cause a higher risk of fibromyalgia and chronic fatigue syndrome.

Did you know?

The word drug comes from the Dutch word droog (meaning "dry"). For centuries, most drugs came from dried plants, hence the name.

Did you know?

For pediatric patients, intravenous fluids are the most commonly cited products involved in medication errors that are reported to the USP.

For a complete list of videos, visit our video library