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 68 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
YES! Correct, THANKS for helping me on my review


Liamb2179

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

 

Did you know?

According to the FDA, adverse drug events harmed or killed approximately 1,200,000 people in the United States in the year 2015.

Did you know?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Did you know?

Although not all of the following muscle groups are commonly used, intramuscular injections may be given into the abdominals, biceps, calves, deltoids, gluteals, laterals, pectorals, quadriceps, trapezoids, and triceps.

Did you know?

According to animal studies, the typical American diet is damaging to the liver and may result in allergies, low energy, digestive problems, and a lack of ability to detoxify harmful substances.

Did you know?

Signs of depression include feeling sad most of the time for 2 weeks or longer; loss of interest in things normally enjoyed; lack of energy; sleep and appetite disturbances; weight changes; feelings of hopelessness, helplessness, or worthlessness; an inability to make decisions; and thoughts of death and suicide.

For a complete list of videos, visit our video library