Question

Why are duplicate tuples not allowed in a relation?

Answer 1

Answer:

Duplicate tuples are not allowed in a relation because they created redundancy of data base which makes the data processing like querying, inserting, deleting, updating etc slow the speed of data base.

Answer 2

Duplicate tuples not allowed in a relation

Explanation:

A tuple is one record (one row) in relation to the relational databases. The tuples (rows) represent all the information associated with a single record from each field.  

• Duplicate tuples are not allowed in a relation because they violate the requirements of the constraints of relational integrity. It refers in particular to the main constraint which states that no two tuples at any relationship state of a database can contain the same values for their attributes.
• Duplicate tuples not permitted in a relation, as it violates the specifications of the relational integrity constraints.