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);
You might also like to view...
American Airlines runs a series of television commercials that show its personnel going out of their way to help customers. In addition to consumers, an important secondary audience for these ads is (are)
a) the FAA. b) airline competitors. c) bus line customers. d) American Airlines employees. e) American Airlines shareholders.
Which of the following organizations is exempt from the antitrust laws?
A) Businesses that are substantially regulated by the states B) Labor unions C) Railroads D) A, B, and C E) A and B only