This topic contains a solution. Click here to go to the answer

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

frankwu

  • Hero Member
  • *****
  • Posts: 549
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



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

kingdude89

  • Sr. Member
  • ****
  • Posts: 336
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




frankwu

  • Member
  • Posts: 549
Reply 2 on: Jul 7, 2018
Excellent


bdobbins

  • Member
  • Posts: 326
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

Illness; diuretics; laxative abuse; hot weather; exercise; sweating; caffeine; alcoholic beverages; starvation diets; inadequate carbohydrate consumption; and diets high in protein, salt, or fiber can cause people to become dehydrated.

Did you know?

Elderly adults are at greatest risk of stroke and myocardial infarction and have the most to gain from prophylaxis. Patients ages 60 to 80 years with blood pressures above 160/90 mm Hg should benefit from antihypertensive treatment.

Did you know?

Aspirin is the most widely used drug in the world. It has even been recognized as such by the Guinness Book of World Records.

Did you know?

It is widely believed that giving a daily oral dose of aspirin to heart attack patients improves their chances of survival because the aspirin blocks the formation of new blood clots.

Did you know?

Asthma occurs in one in 11 children and in one in 12 adults. African Americans and Latinos have a higher risk for developing asthma than other groups.

For a complete list of videos, visit our video library