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 67 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
Thanks for the timely response, appreciate it


brbarasa

  • Member
  • Posts: 308
Reply 3 on: Yesterday
:D TYSM

 

Did you know?

Street names for barbiturates include reds, red devils, yellow jackets, blue heavens, Christmas trees, and rainbows. They are commonly referred to as downers.

Did you know?

Eating food that has been cooked with poppy seeds may cause you to fail a drug screening test, because the seeds contain enough opiate alkaloids to register as a positive.

Did you know?

In 1844, Charles Goodyear obtained the first patent for a rubber condom.

Did you know?

Women are two-thirds more likely than men to develop irritable bowel syndrome. This may be attributable to hormonal changes related to their menstrual cycles.

Did you know?

Today, nearly 8 out of 10 pregnant women living with HIV (about 1.1 million), receive antiretrovirals.

For a complete list of videos, visit our video library