Database Management System
Er Diagrams
Marks 1Marks 2
Functional Dependencies and Normalization
Marks 1Marks 2
Structured Query Language
Marks 1Marks 2
Relational Algebra
Marks 1Marks 2
Transactions and Concurrency
Marks 1Marks 2
File Structures and Indexing
Marks 1Marks 2
1
GATE CSE 2024 Set 1
MCQ (Single Correct Answer)
+1
-0.33

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 diagrams CORRECTLY represents S?

GATE CSE 2024 Set 1 Database Management System - Er Diagrams Question 2 English 1 GATE CSE 2024 Set 1 Database Management System - Er Diagrams Question 2 English 2

A

(i)

B

(ii)

C

(iii)

D

(iv)

2
GATE CSE 2023
MCQ (Single Correct Answer)
+1
-0.33

Which one of the options given below refers to the degree (or arity) of a relation in relational database systems?

A
Number of attributes of its relation schema.
B
Number of tuples stored in the relation.
C
Number of entries in the relation.
D
Number of distinct domains of its relation schema.
3
GATE CSE 2020
MCQ (Single Correct Answer)
+1
-0.33
Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?
A
Rectangles with double/bold border
B
Diamonds with double/bold border
C
Ovals that contain underlined identifiers
D
Ovals with double/bold border
4
GATE CSE 2016 Set 1
MCQ (Single Correct Answer)
+1
-0.3
Which of the following is NOT a superkey in a relational schema with attributes $$V, W, X, Y, Z$$ and primary key $$V Y?$$
A
$$VXYZ$$
B
$$VWXZ$$
C
$$VWXY$$
D
$$VWXYZ$$
GATE CSE Subjects
Theory of Computation
Operating Systems
Algorithms
Digital Logic
Database Management System
Data Structures
Computer Networks
Software Engineering
Compiler Design
Web Technologies
General Aptitude
Discrete Mathematics
Programming Languages
Computer Organization