GATEverse Practice, past papers & mock tests
GATE 2027: 115 days Sign in Create account
GATE 2017 · CS2 - Afternoon
Database ManagementDatabase Design: Functional Dependencies and NormalizationmediumNAT1 mark
Consider tables T1(P, Q) and T2(R, S). In table T1, P is primary key and Q is foreign key referencing R in T2 with on-delete cascade and on-update cascade. In table T2, R is primary key and S is foreign key referencing P in T1 with on-delete set NULL and on-update cascade. In order to delete record (3, 8) from table T1, the number of additional records that need to be deleted from table T1 is _______
Save your progress

Related Database Management PYQs

GATE 2017 · CS2 - Afternoon

An ER model of a database consists of entity types A and B. These are connected by a relationship R which does not have its own at…

GATE 2017 · CS2 - Afternoon

Two transactions T1 and T2 are given as: T1: r1(X) w1(X) r1(Y) w1(Y) T2: r2(Y) w2(Y) r2(Z) w2(Z) The total number of conflict seri…

GATE 2017 · CS2 - Afternoon

Consider table top_scorer(player, country, goals). Query: SELECT ta.player FROM top_scorer AS ta WHERE ta.goals >ALL (SELECT tb.go…

GATE 2017 · CS2 - Afternoon

In a B+ tree, if the search-key value is 8 bytes long, the block size is 512 bytes and the block pointer size is 2 bytes, then the…

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?