Question

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.

Answer 1

Question is incomplete (definition for CLIENT table is missing)

Se Below for missing details

ClientID || ClientName || ClientAgent || ClientSpouseName

C111 || Tom || A1 || Jenny

C222 || Karin || A1 || Bill

C333 || Cole || A2 || Amy

C444 || Dorothy || A2 ||

C555 || Andy || A3 || Amy

C666 || Tina || A3 || Matt

C777 || Christina || A4 || Mike

Answer and Explanation:

To answer the question, the database definition needs to be shown; This requires a create database statement;

This is as follows:

CREATE DATABASE `happyinsurance`;

See attachment for complete explanation