Question

Consider the following statements relating to database:
A. Composite primary key is used to represent the relationship between two relations.
B. A foreign key is used to represent the relationship between two relations.
C. The tuples within a relation must be distinct.
Choose the correct answer from the options given below:

• A. B and C are false
• B. A and B are false
• C. B and C are true
• D. A and C are true

Hint:

Composite keys identify records, foreign keys connect tables, and tuples must always be unique.

Answer 1

The Correct Option is C

- Statement A is false: Composite primary keys uniquely identify a row within a relation, not necessarily define relationships between relations. - Statement B is true: Foreign keys are used to establish relationships between tables. - Statement C is true: Tuples (rows) in a relational table must be unique.