Database - Data Models into Database Designs - Discussion
Discussion Forum : Data Models into Database Designs - General Questions (Q.No. 12)
12.
Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
Discussion:
4 comments Page 1 of 1.
Deepak kumar said:
7 years ago
An intrarelation constraint limits the values of a column by a comparison to the values of another column in the same table. For example, a column named ProjectEndDate could be limited to a date that is later than the value of ProjectStartDate in the same row.
An interrelation constraint limits the values of a column by a comparison to the values of another column in a different table. For example, a column named WorkerOnProjectStartDate in the WORKER-ASSIGNMENT table could be limited to a date that is later than the value of ProjectStartDate in the PROJECT table for the corresponding project.
An interrelation constraint limits the values of a column by a comparison to the values of another column in a different table. For example, a column named WorkerOnProjectStartDate in the WORKER-ASSIGNMENT table could be limited to a date that is later than the value of ProjectStartDate in the PROJECT table for the corresponding project.
Seema said:
8 years ago
Can anyone explain what is interrelation and interrelation?
Sravanthi said:
8 years ago
Can anyone explain what is interrelation and intrarelation?
Divya said:
1 decade ago
Please anyone tell me what is interrelation & intrarelation?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers