A relation can contain several foreign-key constraints referencing different relations or keys, so S1 is false. Self-referencing foreign keys are also valid, for example an employee’s manager ID referencing another employee row. Thus S2 is false and D is correct.
More ER-Model and Database Architecture questions
GATE 2026 CS (CS2) Q15– In the context of DBMS, consider the two sets T and S given below. I: Logical schema II:…
GATE 2025 CS (CS1) Q47– Consider a relational schema team(name, city, owner), with functional dependencies \name…
GATE 2024 CS (CS1) Q20– Let S be the specification: "Instructors teach courses. Students register for courses.…
GATE 2024 CS (CS2) Q20– In the context of owner and weak entity sets in the ER (Entity-Relationship) data model,…
GATE 2020 CS Q24– Which one of the following is used to represent the supporting many-one relationships of a…
GATE 2018 CS Q21– In an Entity-Relationship (ER) model, suppose R is a many-to-one relationship from entity…