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 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 CASCADE);
You might also like to view...
Esquire Industrial plant operates five days per week with a daily payroll of $4,000 . Employees are paid every Saturday for the workweek just completed (Monday through Friday). The last day of the month is Wednesday, March 31 . What is the effect of the correct adjustment at March 31?
a. Increases stockholders' equity and Wages Payable by $8,000 b. Increases Wages Payable and decreases Cash by $12,000 c. Decreases stockholders' equity and increases Wages Payable by $12,000 d. Increases Wages Payable and increases Wages Expense by $8,000
Stage 2 of the group development stages is characterized by ______ development.
a. high b. outstanding c. moderate d. low
Tell me about a time when you showed initiative and took the lead is an example of a behavioral interview question
Indicate whether the statement is true or false
Which of the following statues requires that commercial email not have deceptive headings and clearly indicate if the email is an advertisement?
a. the FCC's Open Internet Order b. CDA of 1996 c. Section 5 the FTC Act. d. CAN-SPAM