Advertisements
Advertisements
प्रश्न
In another class having 2 sections, the two respective class representatives have prepared 2 separate Sports Preferences tables, as shown below:
Sports preference of section 1 (arranged on roll number column)
| Sports Preferences | |
| Roll_no | Sports |
| 9 | Cricket |
| 13 | Football |
| 17 | Badminton |
| 21 | Hockey |
| 24 | Cricket |
Sports preference of section 2 (arranged on Sports name column, and column order is also different)
| Sports Preferences | |
| Sports | Roll_no |
| Badminton | 17 |
| Cricket | 9 |
| Cricket | 24 |
| Football | 13 |
| Hockey | 21 |
Are the states of both relations equivalent? Justify.
टिप्पणी लिखिए
Advertisements
उत्तर
Yes, the states of both the relations are equivalent because in the database the row order does not matter also there is no distinction of tables based on the order of attributes (columns) they have, so both relations are equivalent.
shaalaa.com
क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
