Show the CREATE TABLE statements for the table CLIENT (assume that non-primary key columns can be optional.)
What will be an ideal response?
CREATE TABLE client
(clientid CHAR(4),
clientname CHAR(10),
clientagent CHAR(2),
clientspousename CHAR(10),
PRIMARY KEY (clientid),
FOREIGN KEY (clientagent) REFERENCES agent);
You might also like to view...
Which of the following is NOT one of the four planning activities undertaken by all corporate headquarters?
A) defining the corporate mission B) establishing strategic business units C) assigning resources to each SBU D) assessing growth opportunities E) deciding sales channels
What is good advice about personal values?
A. focus on intrinsic values that are naturally satisfying B. avoid focusing on acquiring wealth and possessions C. try to find a good fit between your values and your organization’s values D. all of these
An important managerial accounting report is the budget, which predicts revenues and expenses.
Answer the following statement true (T) or false (F)
As part of the encoding process, the sender of a message must ________
A) select the receiver's preferred communication channel B) ask the receiver if he or she understands the message C) keep all messages in English for universal understanding D) select appropriate words or symbols given the receiver's experiences and culture