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?


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);

Business

You might also like to view...

A "write our new slogan" event that awards a prize to the winning slogan is a(n):

A) contest B) sweepstakes C) premium D) illegal activity

Business

The practice of outsourcing routine activities, such as customer order entry or human resource transactions, is called _____.

Fill in the blank(s) with the appropriate word(s).

Business

In the VALS framework, consumers whose energy finds outlets in exercise, sports, outdoor recreation, and social activities are referred to as ________.

A. Experiencers B. Strivers C. Achievers D. Makers E. Believers

Business

Kevin works in the public relations department of his company. He sends a news release about a new product offering to several newspapers and television stations. Kevin knows from past experience that even when the media use his news releases, they often release the information at inopportune times. They will also sometimes cut out what Kevin believes are the most important points to make the news fit. However, Kevin accepts these disadvantages because free publicity offers the advantage of

A. credibility. B. target market awareness. C. timeliness. D. accuracy. E. feasibility. 

Business