011-40705070  or  
Call me
Download our Mobile App
Select Board & Class
  • Select Board
  • Select Class
Pradeep Karthik from ATOMIC ENERGY CENTRAL SCHOOL, asked a question
Subject: Accountancy , asked on 8/7/10

Why are duplicate tuples not allowed in a relation?

EXPERT ANSWER

Saurabh Mehta , Meritnation Expert added an answer, on 8/7/10

Tuple refers to a row in a table that represents a set or collection of related data values. It corresponds to the relationship which represents entity type as a set of tuples, where each tuple is an ordered list of values corresponding to attributes of relation. As each tuple represents a distinct data record entity, so no two tuples in a relation (i.e. a table) can have the same combination of values for all their data items. Moreover, if a new tuple is added in the relation, then it should not reflect the existing data-values, otherwise, it will violate the uniqueness constraint and the relation as a whole will not have a minimal super-key.

This conversation is already closed by Expert

  • Was this answer helpful?
  • 1
100% of users found this answer helpful.
View More
{{ displayOption}}
You don't have any friends yet, please add some friends to start chatting
Not Connected. Connecting in {{ reconnectInSeconds}}s...Try now
{{ item_category['category']}}
{{ item_friends['first_name']}} {{ item_friends['last_name']}}
{{ item_friends['first_name']}} {{ item_friends['last_name']}}
{{ item_friends["first_name"]}} {{ item_friends["last_name"]}} {{ item_friends["subText"]}}
{{ item_friends["notification_counter"]}} 99+
Recent chats:
{{ item_friends['name']}}
{{ item_friends['name']}}
{{ item_friends["name"]}} {{ item_friends["subText"]}}
{{ item_friends["notification_counter"]}} 99+
No recent chats
Blocked List:
{{ item_friends['name']}}
{{ item_friends['name']}}
{{ item_friends["name"]}} {{ item_friends["subText"]}}
{{ item_friends["notification_counter"]}} 99+
No blocked user
Pending Requests:
{{ item_friends['first_name']}} {{ item_friends['last_name']}}
{{ item_friends['first_name']}} {{ item_friends['last_name']}}
{{ item_friends["first_name"]}} {{ item_friends["last_name"]}} {{ item_friends["school_name"]}}
No pending requests
Suggested Friends:
{{ item_friends['first_name']}} {{ item_friends['last_name']}}
{{ item_friends["first_name"]}} {{ item_friends["last_name"]}} {{ item_friends["school_name"]}}
Friends
{{ item_friend["first_name"]}} {{ item_friend["last_name"]}} {{ item_friend["school_name"]}}
Classmate
{{ item_classmate["first_name"]}} {{ item_classmate["last_name"]}} {{ item_classmate["school_name"]}}
School
{{ item_school["first_name"]}} {{ item_school["last_name"]}} {{ item_school["school_name"]}}
Others
{{ item_others["first_name"]}} {{ item_others["last_name"]}} {{ item_others["school_name"]}}
  • Recent Chats
  • Friends
  • {{ item_category['category']}}
  • Pending Requests
  • Blocked