GATE CSE 2023 | Er Diagrams Question 1 | Database Management System

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 2016 Set 1

MCQ (Single Correct Answer)

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

$$VXYZ$$

$$VWXZ$$

$$VWXY$$

$$VWXYZ$$

GATE CSE 2014 Set 2

Numerical

-0

Given an instance of the STUDENTS relation as shown below: GATE CSE 2014 Set 2 Database Management System - Er Diagrams Question 12 English

For (StudentName, StudentAge) to be a key for this instance, the value $$X$$ should NOT be equal to ________.

Your input ____

GATE CSE Subjects

Discrete Mathematics

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

Programming Languages

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

Theory of Computation

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

Operating Systems

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

Digital Logic

K Maps Boolean Algebra Combinational Circuits Number Systems Sequential Circuits

Computer Organization

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

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 Lan Technologies and Wi-Fi Data Link Layer and Switching Network Layer Routing Algorithm TCP UDP Sockets and Congestion Control Application Layer Protocol Network Security

Algorithms

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

Compiler Design

Lexical Analysis Parsing Syntax Directed Translation Code Generation and Optimization

Software Engineering

Web Technologies

General Aptitude

Verbal Ability Numerical Ability