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?
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);
You might also like to view...
To record a cash discount allowed on a purchase:
a. no entry is required. b. purchase returns and allowances is credited. c. purchase discounts is credited. d. purchases is credited.
Most infrastructure-centric-metrics today in the IT world are _____ metrics, which focus on the extent to which an organization is doing something right.
Fill in the blank(s) with the appropriate word(s).
ISO 9000 refers to: A) standards used for assuring product quality through product design and manufacturing process
B) a series of import regulations imposed by the European Union. C) Japanese trade restrictions against U.S. telecommunications companies that were eventually repealed. D) a trade agreement established between the U.S. and the European Union that will significantly reduce barriers to trade.
A mortgagee can provide for a power of sale in a mortgage
Indicate whether the statement is true or false