Advertisements
Advertisements
Question
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.
Short/Brief Note
Advertisements
Solution
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
Is there an error in this question or solution?
