Suppose the user finds the usage of room number and phone number in a…
2023
Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by
- A.
Unique-role assumption
- B.
Unique-key assignment
- C.
Role intergral assignment
- D.
None of the mentioned
Attempted by 1248 students.
Show answer & explanation
Correct answer: A
Answer: a
Explanation: The unique-role assumption is a key principle in database design that ensures each attribute name has a single, unambiguous meaning. This prevents confusion when the same attribute name (e.g., 'room number' or 'phone number') is used in different contexts. By assigning unique roles to attributes, the schema becomes more consistent and easier to interpret. This approach enhances clarity and reduces ambiguity in relational databases.