GATE CSE concept:er-model PYQs & Answers

Home
GATE
Computer Science and Information Technology
Topics
concept:er-model

Attempt a question, record the concept and assumptions, then check the available answer. Rework mistakes after revising the relevant concepts. Topic tags can overlap; review the question context.

Questions 1–2 of 2. Imported answers require independent review unless marked reviewed.

Topic practice 2 questionsPage 1 of 1

In an Entity-Relationship (ER) model, suppose R is a many-to-one relation from entity set E1 to entity set E2. Assume that E1 and E2 participate totally in R and that the cardinality of E1 is greater than the cardinality of E2.

Which one of the following is true about R?

Your answerChoose one option.

Every entity in E1 is associated with exactly one entity in E2.

Some entity in E1 is associated with more than one entity in E2.

Every entity in E2 is associated with exactly one entity in E1.

Every entity in E2 is associated with at most one entity in E1.

You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answer

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 conditions, can the relational table for R be merged with that of A?

Your answerChoose one option.

Relationship R is one-to-many and the participation of A in R is total.

Relationship R is one-to-many and the participation of A in R is partial.

Relationship R is many-to-one and the participation of A in R is total.

Relationship R is many-to-one and the participation of A in R is partial.

You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answer

GATE CSE concept:er-model PYQs

How to practice concept:er-model

Question 11

Question 17