Database - Data Models into Database Designs - Discussion
Discussion Forum : Data Models into Database Designs - General Questions (Q.No. 20)
20.
Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
Discussion:
1 comments Page 1 of 1.
MANOJ KUMAR said:
1 decade ago
Data constraints are limitations on data values:
Domain constraint - Column values must be in a given set of specific values.
Range constraint - Column values must be within a given range of values.
Intrarelation constraint - Column values are limited by comparison to values in other columns in the same table.
Interrelation constraint - Column values are limited by comparison to values in other columns in other tables [Referential integrity constraints on foreign keys].
Domain constraint - Column values must be in a given set of specific values.
Range constraint - Column values must be within a given range of values.
Intrarelation constraint - Column values are limited by comparison to values in other columns in the same table.
Interrelation constraint - Column values are limited by comparison to values in other columns in other tables [Referential integrity constraints on foreign keys].
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers