State whether or not each of the following statements could be an integrity constraint of a checking account database for a banking application. Give reasons for your answers.
a. The value stored in the balance column of an account is greater than or equal to $0.
b. The value stored in the balance column of an account is greater than it was last week at this time.
c. The value stored in the balance column of an account is $128.32.
d. The value stored in the balance column of an account is a decimal number with two digits following the decimal point.
e. The social_security_number column of an account is de?ned and contains a nine-digit number.
f. The value stored in the check_credit_in_use column of an account is less than or equal to the value stored in the total_approved_check_credit column. (These
columns have their obvious meanings.)
a. Yes. It describes a constraint on a snapshot of the database.
b. No. It does not describe a snapshot.
c. No. The balance will change.
d. Yes. It is a domain constraint.
e. Yes. It is a domain constraint.
f. Yes. It describes a constraint on a snapshot
You might also like to view...
Which of the following is true about a deep copy?
A. The address of a pointer in the original is copied to a pointer inside the copy. B. The address of a pointer in the original is different than the address of the corresponding pointer in the copy. C. It is a copy made deep within the code of a long function (and therefore, not so easy to debug) D. It is never made with the aid of a copy constructor.
In what library is the function rand( ) found?
A. It is included in namespace std;
B.
Objects within a class can be grouped into _____, which are more specific categories within a class.
A. grids B. units C. subclasses D. matrices
The Post method specifies that the data collected in the form be sent to the server as appended to the URL of the web page in the Action property.
Answer the following statement true (T) or false (F)