GATE CS 2017 (Afternoon) — Question 17

Database Management Systems (DBMS)ER-ModelMCQ1 mark · −1/3 if wrongMedium

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?
  1. A
    Relationship R is one-to-many and the participation of A in R is total.
  2. B
    Relationship R is one-to-many and the participation of A in R is partial.
  3. C
    Relationship R is many-to-one and the participation of A in R is total.
  4. D
    Relationship R is many-to-one and the participation of A in R is partial.
Practise the full 2017-AN paper
Challenge a friend: WhatsApp Telegram
From RENYXERAWhat rank do your marks get?GATE score, likely All-India Rank and qualifying marks for your category.
Practise more on ER-ModelTimed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group