Show the CREATE TABLE statements for the table AGENT (assume that non-primary key columns can be optional.)

What will be an ideal response?


CREATE TABLE agent
(agentid CHAR(2),
agentname CHAR(10),
agentarea CHAR(1),
agentrating INT,
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...

The Freedom of Information Act of 1966 is designed primarily to do which one of the following?

A. To give media access to all meetings and proceedings in government B. To promote full disclosure from the executive branch of government C. To make such law consistent across the 50 states D. To make both documents and computer files available to the public E. To give everyone access to information about different religious faiths

Business

Lingerie Closet, a women's clothing store, employs female attendants to assist customers in the dressing rooms. Mark, a forty-one-year-old male, applies for an attendant's job, but is not hired. In Mark's suit against Lingerie Closet for employment discrimination under Title VII, the store has? A) no defense B) a bona fide occupational qualification defense

C) a business necessity defense.? D) a seniority system defense.

Business

Statutes passed by Congress may limit which types of jurisdiction?

a. inclusive jurisdiction b. de novena jurisdiction c. global jurisdiction d. subject matter jurisdiction e. superior jurisdiction

Business

In UML, an object class is represented by:

A) a rectangle with three compartments separated by horizontal lines. B) a circle in which the activity name is recorded. C) a double-lined ellipse in which the activity name is recorded. D) a diamond in which the activity name is recorded. E) a set of brackets in which the event name is recorded.

Business