Describe the delete set-to-default option (for implementing a referential integrity constraint)
What will be an ideal response?
The delete set-to-default option allows a record to be deleted if its primary key value is referred to by a foreign key value of a record in another relation. As a result, in all of the records where the foreign key value refers to the primary key of the record that is being deleted, the value of the foreign key is set to a predetermined default value.
You might also like to view...
Debbie likes working in the banking industry because it has a lot of structure and certainty, and the daily work is routine. Debbie probably
A. has a high tolerance for ambiguity. B. has a large need for ambiguity. C. has a low tolerance for ambiguity. D. is in the middle ambiguity range. E. thrives on ambiguity.
For textile production, the U.S. capital/labor ratio is 0.5 and China's capital/labor ratio is 0.02. This means that
a. the United States is the relatively capital scarce country. b. China is the relatively labor scarce country. c. China is the relatively capital abundant country. d. the United States is the relatively capital abundant country.
What is the primary difference between an agent and a broker?
A. An agent gets compensated based on commission while a broker generally charges fees for his services. B. A broker works only for a seller whereas an agent can represent a buyer or a seller. C. An agent represents a company on a permanent basis while a broker is employed temporarily. D. An agent has much more extensive knowledge about the products he deals with than a broker does. E. Brokers have long-term relationships with their customers while an agent's relationships are generally short-lived.
A well-designed data structure helps reduce problems related to:
A) data storage. B) efficient manipulation of data. C) undesired duplication of records and multiple updating of records. D) All of the above