Skip to content
Exercises · Q7
Q.

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)

Table: Sports Preferences

Roll_noSports
9Cricket
13Football
17Badminton
21Hockey
24Cricket

Sports preference of section 2 (arranged on Sports name column, and column order is also different)

Table: Sports Preferences

SportsRoll_no
Badminton17
Cricket9
Cricket24
Football13
Hockey21

Are the states of both the relations equivalent? Justify.

Uttarakhand UbseTextbookSubjective· 3mImportance★★★★★est
57% · 8/14 Questions
🔒 Locked · start free trial →

You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.

Start your 14-day free trial to unlock the full solution →

Yes — equivalent. In the relational model a relation is a set of tuples, and its attributes are identified by name, not by position. Sorting the rows differently or writing the columns in a different order does not change the relation. Both tables hold exactly the same five (Roll_no, Sports) pairs, so their states are equal.

The two relational-model properties that decide this

  1. Tuples are unordered. A relation state is a set of tuples; a set has no first or last element. Arranging Section 1's list by Roll_no and Section 2's list alphabetically by Sports is merely a display choice — the underlying set is untouched.
  2. Attributes are identified by name, not position. Whether the column Roll_no is printed first or second is irrelevant; each value is associated with its attribute name. So (Roll_no: 17, Sports: Badminton) and (Sports: Badminton, Roll_no: 17) are the same tuple.

Checking the actual data

Rewriting both relations as sets of (Roll_no, Sports) pairs:

TupleSection 1Section 2
(9, Cricket)✓✓
(13, Football)✓✓
(17, Badminton)✓✓
(21, Hockey)✓✓
(24, Cricket)✓✓

Same attribute set {Roll_no, Sports}, same cardinality (5), and every tuple of one appears in the other. Two relations with the same schema and the same set of tuples have equal states.

You can see the same fact in SQL — row order and column order in a query never define the relation:

SELECT Roll_no, Sports FROM Section1 ORDER BY Roll_no;
SELECT Roll_no, Sports FROM Section2 ORDER BY Roll_no;

Both queries return the identical result: …

Unlock everything free for 14 days

  • Full step-by-step solutions
  • Concept-first explanations
  • Methods, shortcuts & mistakes
  • PYQ mapping + timed mock tests

Full access for 14 days. No credit card required.