Author Question: Show the CREATE TABLE statements for HAPPY INSURANCE database for the table AGENT (assume that ... (Read 102 times)

frankwu · **on:** Jul 7, 2018

Show the CREATE TABLE statements for HAPPY INSURANCE database for the table AGENT (assume that non-primary key columns can be optional) with the user defined constraint specifying that the agent rating must be between 50 and 150.

What will be an ideal response?

Question 2

As a systems analyst works to understand users, their organization, and its information requirements, it becomes important to examine different types of hard data that offer information unavailable through any other method of data gathering.

Indicate whether the statement is true or false

kingdude89 · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

6CREATE TABLE agent
(agentid CHAR(2),
agentname CHAR(10),
agentarea CHAR(1),
agentrating INT CHECK (agentrating >= 50 AND agentrating <= 150)
agentyearofhire INT,
supervisedby CHAR(2),
PRIMARY KEY (agentid),
FOREIGN KEY (agentarea) REFERENCES area,
FOREIGN KEY (supervisedby) REFERENCES agent);

Answer to Question 2

TRUE