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

GATE CSE 2024 Set 2

MCQ (Single Correct Answer)

-0.33

In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?

The weak entity set MUST have total participation in the identifying relationship

The owner entity set MUST have total participation in the identifying relationship

Both weak and owner entity sets MUST have total participation in the identifying relationship

Neither weak entity set nor owner entity set MUST have total participation in the identifying relationship

GATE CSE 2024 Set 1

MCQ (Single Correct Answer)

-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

(i)

(ii)

(iii)

(iv)

GATE CSE 2023

MCQ (Single Correct Answer)

-0.33

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

Number of attributes of its relation schema.

Number of tuples stored in the relation.

Number of entries in the relation.

Number of distinct domains of its relation schema.

GATE CSE 2020

MCQ (Single Correct Answer)

-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?

Rectangles with double/bold border

Diamonds with double/bold border

Ovals that contain underlined identifiers

Ovals with double/bold border

GATE CSE Subjects

Theory of Computation

Finite Automata and Regular Language Push Down Automata and Context Free Language Undecidability Recursively Enumerable Language and Turing Machine

Operating Systems

Process Concepts and Cpu Scheduling Synchronization and Concurrency Deadlocks Memory Management File System IO and Protection

Algorithms

Complexity Analysis and Asymptotic Notations Searching and Sorting Divide and Conquer Method Greedy Method Dynamic Programming P and NP Concepts

Digital Logic

Number Systems Boolean Algebra K Maps Combinational Circuits Sequential Circuits

Database Management System

Er Diagrams Functional Dependencies and Normalization Structured Query Language Relational Algebra Transactions and Concurrency File Structures and Indexing

Data Structures

Arrays Stacks and Queues Linked List Trees Graphs Hashing

Computer Networks

Concepts of Layering Data Link Layer and Switching Network Layer Application Layer Protocol Routing Algorithm TCP UDP Sockets and Congestion Control Lan Technologies and Wi-Fi Network Security

Software Engineering

Compiler Design

Lexical Analysis Parsing Syntax Directed Translation Code Generation and Optimization

Web Technologies

General Aptitude

Verbal Ability Logical Reasoning Numerical Ability

Discrete Mathematics

Set Theory & Algebra Linear Algebra Graph Theory Combinatorics Mathematical Logic Probability Calculus

Programming Languages

Basic of Programming Language Function and Recursion Pointer and Structure in C

Computer Organization

Computer Arithmetic Pipelining Machine Instructions and Addressing Modes Memory Interfacing IO Interface Alu Data Path and Control Unit Secondary Memory