GATEverse Practice, past papers & mock tests
GATE 2027: 115 days Sign in Create account
GATE 2018
Database ManagementDatabase Design: Functional Dependencies and NormalizationmediumMCQ2 marks
Consider the following relational schemas and non-trivial functional dependencies: Schema I: Registration (rollno, courses) with rollno -> courses (courses is set-valued) Schema II: Registration (rollno, courseid, email) with rollno, courseid -> email; email -> rollno Schema III: Registration (rollno, courseid, marks, grade) with rollno, courseid -> marks, grade; marks -> grade Schema IV: Registration (rollno, courseid, credit) with rollno, courseid -> credit; courseid -> credit Which one of the relational schemas above is in 3NF but not in BCNF?
Save your progress

Related Database Management PYQs

GATE 2018

Consider relations r(A, B) and s(B, C), where s.B is primary key and r.B is foreign key referencing s.B. Consider query Q: r ⋈ (σ_…

GATE 2018

In an Entity-Relationship (ER) model, suppose R is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 …

GATE 2018

Consider the following two tables and four queries in SQL: Book (isbn, bname), Stock (isbn, copies) Query 1: SELECT B.isbn, S.cop…

GATE 2026 · CS1 - Forenoon

Let P, Q, R and S be the attributes of a relation in a relational schema. Let X → Y indicate functional dependency in the context …

GATE 2026 · CS1 - Forenoon

In the context of relational database normalization, which of the following statements is/are true?

GATE 2026 · CS1 - Forenoon

Consider a relational database schema with two relations R(P,Q) and S(X,Y). Let E = {<u> | there ∃ v, there ∃ w, <u,v> in R and <v…