ER Model and Relational Schema Design: GATE CS previous year questions (Databases)

GATE CS 2026 Set 2MCQ1 markEasy (estimate)
GATE CS 2026 Set 2, Q.15
In the context of DBMS, consider the two sets T and S given below. T S I: Logical schema L: Views II: Physical schema M: File organization and indexes III: External schema N: Re...
ER Model and Relational Schema Design
GATE CS 2024 Set 1MCQ1 markEasy (estimate)
GATE CS 2024 Set 1, Q.20
Let S be the specification: "Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students." Which one of the following...
ER Model and Relational Schema Design
GATE CS 2024 Set 2MCQ1 markEasy (estimate)
GATE CS 2024 Set 2, Q.20
In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?
ER Model and Relational Schema Design
GATE CS 2023MCQ1 markEasy (estimate)
GATE CS 2023, Q.16
Which one of the options given below refers to the degree (or arity) of a relation in relational database systems?
ER Model and Relational Schema Design
GATE CS 2021 Set 2MCQ1 markEasy (estimate)
GATE CS 2021 Set 2, Q.16 (CS Q.6)
Consider the following statements $S_{1}$ and $S_{2}$ about the relational data model: $S_{1}$ : A relation scheme can have at most one foreign key. $S_{2}$ : A foreign key in a relation...
ER Model and Relational Schema Design
GATE CS 2020MCQ1 markEasy (estimate)
GATE CS 2020, Q.24 (CS Q.14)
Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?
ER Model and Relational Schema Design
GATE CS 2018MCQ1 markEasy (estimate)
GATE CS 2018, Q.21 (CS Q.11)
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 and E2 participate totally in $R$ and that th...
ER Model and Relational Schema Design
GATE CS 2017 Set 2MCQ1 markMedium (estimate)
GATE CS 2017 Set 2, Q.17 (CS Q.17)
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 attribute. Under which one of the following condi...
ER Model and Relational Schema Design
GATE CS 2017 Set 2NAT1 markMedium (estimate)
GATE CS 2017 Set 2, Q.19 (CS Q.19)
Consider the following tables T1 and T2. Table T1 | P | Q | | :-: | :-: | | 2 | 2 | | 3 | 8 | | 7 | 3 | | 5 | 8 | | 6 | 9 | | 8 | 5 | | 9 | 8 | Table T2 | R | S | | :-:...
ER Model and Relational Schema Design · SQL Queries and Integrity Constraints
GATE CS 2016 Set 1MCQ1 markEasy (estimate)
GATE CS 2016 Set 1, Q.31 (CS Q.21)
Which of the following is NOT a superkey in a relational schema with attributes $V, W, X, Y, Z$ and primary key $V Y$ ?
ER Model and Relational Schema Design
GATE CS 2015 Set 1NAT2 marksMedium (estimate)
GATE CS 2015 Set 1, Q.51 (CS Q.41)
Consider an Entity-Relationship (ER) model in which entity sets $E_{1}$ and $E_{2}$ are connected by an $m : n$ relationship $R_{12}$ . $E_{1}$ and $E_{3}$ are connected by a $1 : n$ ( $1$ on...
ER Model and Relational Schema Design
GATE CS 2014 Set 2NAT1 markEasy (estimate)
GATE CS 2014 Set 2, Q.32 (CS Q.22)
Given an instance of the STUDENTS relation as shown below: | StudentID | StudentName | StudentEmail | StudentAge | CPI | | :--- | :--- | :--- | :--- | :--- | | 2345 | Shankar |...
ER Model and Relational Schema Design
GATE CS 2012MCQ1 markEasy (estimate)
GATE CS 2012, Q.14 (CS Q.14)
Given the basic ER and relational models, which of the following is INCORRECT?
Relational Algebra and Tuple Relational Calculus · ER Model and Relational Schema Design
GATE CS 2011MCQ1 markEasy (estimate)
GATE CS 2011, Q.12 (CS Q.12)
Consider a relational table with a single record for each registered student with the following attributes. 1. Registration_Num: Unique registration number of each registered st...
ER Model and Relational Schema Design

Questions

Other topics of Databases