Explain the integrity features that a database management system may provide making reference to the system used, and indicate the disadvantages that arise where they are not available.
What will be an ideal response?
This answer also requires knowledge of a particular DBMS that is being used. The basic integrity
features can be explained, such as domains, primary key specification, nulls, referential integrity,
with reference to how the particular DBMS provides them. The advantages of having the DBMS
handle these should be appreciated to determine the disadvantages. For example, validation
routines would need to be included in all relevant programs, it is difficult to understand
constraints that are buried in programming code, duplication of effort.
You might also like to view...
The capacity of an Internet connection is sometimes referred to as ____________________and can be measured in bits per second.
Fill in the blank(s) with the appropriate word(s).
Each orderProduct element contains 3 child elements: ______, ______ and ______ .
Fill in the blank(s) with the appropriate word(s).
What command below takes a list of arguments specifying the absolute or relative pathnames of files to remove?
A. del B. rm C. remove D. delete
What two devices are often combined into one device to connect the network to the Internet and to share the connection between devices on the network?
a. Router hub and switch b. Switch and hub c. Router and switch d. Modem and router