VOOZH about

URL: https://www.geeksforgeeks.org/quizzes/gate-er-model-pyq-2010-to-2025/

⇱ Quiz about GATE || ER MODEL || Pyq ( 2010 to 2025 )

Last Updated :
Discuss
Comments

Question 1

In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?
[GATE 2024|| SET -2 MCQ || 1-mark ]

  • 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

Question 2

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 2024|| SET-1 MCQ || 1-mark]

👁 qz29
fig


  • (i)

  • (ii)

  • (iii)

  • (iv)

Question 3

Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?

  • Diamonds with double/bold border

  • Rectangles with double/bold border

  • Ovals with double/bold border

  • Ovals that contain underlined identifiers

Question 4

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 the cardinality of E1 is greater than the cardinality of E2.

Which one of the following is true about R? [GATE 2018 ||MCQ ||1-mark]

  • 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

Question 5

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?
[GATE 2017 || SET -2 MCQ || 1-mark]

  • 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

Question 6

Consider an Entity-Relationship (ER) model in which entity sets E1 and E2 are connected by an m:n relationship R12. E1 and E3 are connected by a 1:n (1 on the side of E1 and n on the side of E3) relationship R13.

E1 has two-singled attributes a11 and a12 of which a11 is the key attribute. E2 has two singled-valued attributes a21 and a22 of which a21 is the key attribute. E3 has two single-valued attributes a31 and a32 of which a31 is the key attribute. The relationships do not have any attributes.

If a relational model is derived from the above ER model, then the minimum number of relations that would be generated if all relation are in 3NF is________________.
[GATE 2015 || SET-1 NAT ||2-mark]

  • 4

Question 7

Given the basic ER and relational models, which of the following is INCORRECT? [GATE 2012 || MCQ ||1-mark]

  • An attribute of an entity can have more than one value

  • An attribute of an entity can be composite


  • In a row of a relational table, an attribute can have more than one value


  • In a row of a relational table, an attribute can have exactly one value or a NULL value

There are 7 questions to complete.

Take a part in the ongoing discussion