HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT AGENT AREA

question 91

Multiple Choice

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT
$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Matt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$
This database will be used for the following questions citing tables from the HAPPY INSURANCE database.


-Which of the following sequences of CREATE TABLE statements for HAPPY INSURANCE database is in correct order?

• A)CREATE TABLE area
• CREATE TABLE client
• CREATE TABLE agent
• B)CREATE TABLE area
• CREATE TABLE agent
• CREATE TABLE client
• C)CREATE TABLE client
• CREATE TABLE agent
• CREATE TABLE area
• D)CREATE TABLE agent
• CREATE TABLE client
• CREATE TABLE area

---

Definitions:

Units Produced

The total number of completed products manufactured within a specified period.

Manufacturing Overhead Cost

These are indirect factory-related costs that are incurred when a product is manufactured, including costs related to the operation and maintenance of the factory.

Units Produced

The total number of finished goods completed within a given period.

Direct Manufacturing Cost

Expenses directly associated with the production of goods, such as raw materials and labor directly involved in manufacturing.