Search results for er-diagram / GATE Overflow for GATE CSE

56 votes

8 answers

1

GATE CSE 2015 Set 1 | Question: 41
Consider an Entity-Relationship $(\text{ER})$ model in which entity sets $E_{1}$ and $E_{2}$ are connected by an $m:n$ relationship $R_{12}$. $E_{1}$ and $E_{3}$ are connected by a $1 : n$ ($1$ ... from the above $\text{ER}$ model, then the minimum number of relations that would be generated if all relation are in $\text{3NF}$ is________________.

Consider an Entity-Relationship $(\text{ER})$ model in which entity sets $E_{1}$ and $E_{2}$ are connected by an $m:n$ relationship $R_{12}$. $E_{1}$ and $E_{3}$ are conn...

makhdoom ghaya

18.9k views

makhdoom ghaya asked Feb 13, 2015

44 votes

5 answers

2

GATE CSE 2018 | Question: 11
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 ... 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

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

gatecse

28.0k views

gatecse asked Feb 14, 2018

64 votes

6 answers

3

GATE CSE 2008 | Question: 82
Consider the following $\text{ER}$ diagram The minimum number of tables needed to represent $M$, $N$, $P$, $R1$, $R2$ is $2$ $3$ $4$ $5$

Consider the following $\text{ER}$ diagramThe minimum number of tables needed to represent $M$, $N$, $P$, $R1$, $R2$ is$2$$3$$4$$5$

Kathleen

26.8k views

Kathleen asked Sep 11, 2014

59 votes

5 answers

4

GATE IT 2004 | Question: 73
Consider the following entity relationship diagram $(ERD)$, where two entities $E1$ and $E2$ have a relation $R$ of cardinality 1:m. The attributes of $E1$ are $A11$, $A12$ and $A13$ where $A11$ is the key attribute. The attributes of $E2$ are $A21$ ... normal form ($3NF$) is designed from the above $ERD$. The number of tables in the database is $2$ $3$ $5$ $4$

Consider the following entity relationship diagram $(ERD)$, where two entities $E1$ and $E2$ have a relation $R$ of cardinality 1:m.The attributes of $E1$ are $A11$, $A12...

Ishrat Jahan

19.1k views

Ishrat Jahan asked Nov 2, 2014

30 votes

2 answers

5

GATE CSE 2008 | Question: 83
Consider the following $\text{ER}$ diagram The minimum number of tables needed to represent $M$, $N$, $P$, $R1$, $R2$ is Which of the following is a correct attribute set for one of the tables for the minimum number of tables needed to represent $M$, $N$, $P$, $R1$, $R2$? ${M1, M2, M3, P1}$ ${M1, P1, N1, N2}$ ${M1, P1, N1}$ ${M1, P1}$

Consider the following $\text{ER}$ diagramThe minimum number of tables needed to represent $M$, $N$, $P$, $R1$, $R2$ is Which of the following is a correct attribute set ...

Arjun

10.9k views

Arjun asked Nov 27, 2016

1 votes

2 answers

6

GATE CSE 2024 | Set 1 | Question: 10
Let $\mathrm{S}$ be the specification: "Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students." Which one of the following $\mathrm{ER}$ diagrams CORRECTLY represents $\mathrm{S}$? $\text{(i)}$ $\text{(ii)}$ $\text{(iii)}$ $\text{(iv)}$

Let $\mathrm{S}$ be the specification: "Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students." Which one...

Arjun

2.1k views

Arjun asked Feb 16

3 votes

0 answers

7

GO Classes Test Series 2024 | Mock GATE | Test 11 | Question: 13
Given the portion of an ER diagram shown above (with a thickened arrow from $R$ to $A),$ which of the following statements are true? $R$ connects each entity in $A$ to at least one entity in $B$ $R$ connects each entity in $A$ to at ... in $B$ to at most one entity in $A$ only I and II only II and III only I and IV only III and IV

Given the portion of an ER diagram shown above (with a thickened arrow from $R$ to $A),$ which of the following statements are true?$R$ connects each entity in $A$ to at ...

GO Classes

633 views

GO Classes asked Jan 13

0 votes

2 answers

8

ISRO 2024
Entity Relationship model shows the Static view Functional view Dynamic view All of the above

Entity Relationship model shows theStatic viewFunctional viewDynamic viewAll of the above

Ramayya

342 views

Ramayya asked Jan 7

36 votes

4 answers

9

GATE CSE 2005 | Question: 75
Let $E_1$ and $E_2$ be two entities in an $E/R$ diagram with simple-valued attributes. $R_1$ and $R_2$ are two relationships between $E_1$ and $E_2$, where $R_1$ is one-to-many and $R_2$ is many-to-many. $R_1$ and $R_2$ do not have ... of their own. What is the minimum number of tables required to represent this situation in the relational model? $2$ $3$ $4$ $5$

Let $E_1$ and $E_2$ be two entities in an $E/R$ diagram with simple-valued attributes. $R_1$ and $R_2$ are two relationships between $E_1$ and $E_2$, where $R_1$ is one-t...

Kathleen

18.5k views

Kathleen asked Sep 22, 2014

0 votes

0 answers

10

ER Diagram
Can someone please provide me with the correct explanation for this question

Can someone please provide me with the correct explanation for this question

practicalmetal

377 views

practicalmetal asked Oct 26, 2023

0 votes

0 answers

11

Finding minimum number of tables needed to represent ER diagram
Find minimum number of tables needed to represent following ER diagram? This question would have been relatively simple as we would implicitly convert the ERD to 3NF (asked in GATE 2008). But what if the questions asks us to find minimum tables needed to represent above ERD in 1NF or 2NF?. What would our approach will be in that case?

Find minimum number of tables needed to represent following ER diagram?This question would have been relatively simple as we would implicitly convert the ERD to 3NF (aske...

rexritz

501 views

rexritz asked Aug 29, 2023

0 votes

1 answer

12

Dbms practice - Self doubt
Consider the below instance of relation : Employee: Emp_rating Emp_name Emp_mail Emp_sal 1. Surabhi sm301@gj 40000 2. Vishu sp11@ap 60000 1. Surabhi Null 50000 3. Yashy ar@dy 60000 The maximum possible number of alternate keys for the above relational instance is/are _____

Consider the below instance of relation : Employee: Emp_ratingEmp_nameEmp_mailEmp_sal1.Surabhism301@[email protected]@dy60000 The maxi...

Rahhul A

434 views

Rahhul A asked Aug 3, 2023

0 votes

1 answer

13

Confused about cardinality of ER diagram which one is whose cardinality ,look on my notes and clear it out.

Pradeep_Kumar

489 views

Pradeep_Kumar asked Jul 13, 2023

1 votes

2 answers

14

Database ER model
An ER diagram is having two strong entities E1 and E2. The relationship between the entities ‘R’ is having partial participation from E1 side and total participation from E2 side with 1:1 cardinality. The entities E1 and E2 are having one multivalued attribute each. How many numbers of relations are required to represent the ER model into the relational model?

An ER diagram is having two strong entities E1 and E2. The relationship between the entities ‘R’ is having partial participation from E1 side and total participation ...

Ashutosh_17

974 views

Ashutosh_17 asked Apr 13, 2023

18 votes

3 answers

15

GATE CSE 2020 | Question: 14
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

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 bor...

Arjun

13.2k views

Arjun asked Feb 12, 2020

2 votes

3 answers

16

UGC NET CSE | December 2019 | Part 2 | Question: 23
Find minimum number of tables required for converting the following entity relationship diagram into relational database? $2$ $4$ $3$ $5$

Find minimum number of tables required for converting the following entity relationship diagram into relational database?$2$$4$$3$$5$

soujanyareddy13

2.3k views

soujanyareddy13 asked May 12, 2021

28 votes

5 answers

17

GATE CSE 2012 | Question: 14
Given the basic ER and relational models, which of the following is INCORRECT? 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

Given the basic ER and relational models, which of the following is INCORRECT?An attribute of an entity can have more than one valueAn attribute of an entity can be compo...

gatecse

16.6k views

gatecse asked Aug 5, 2014

2 votes

3 answers

18

ER Diagram: What is the cardinality of this relationship? is m-n cardinality correct? if not, why?
What is the cardinality of this relationship? is m-n cardinality correct? if not, why?

What is the cardinality of this relationship? is m-n cardinality correct? if not, why?

daksirp

1.4k views

daksirp asked Apr 23, 2022

2 votes

1 answer

19

GO Classes 2023 | IIITH Mock Test 1 | Question: 17
Consider the following ER diagram : borrower mapping cardinality is many-to-many. While converting the ER diagram into a relational DBMS model, the relationship set borrower is converted into a relation borrower(cust_id, loan_id, ... , what is the primary key of borrower ? cust_id loan_id (cust_id, loan_id) (cust_id, loan_id, access_date)

Consider the following ER diagram :“borrower” mapping cardinality is many-to-many. While converting the ER diagram into a relational DBMS model, the relationship set ...

GO Classes

737 views

GO Classes asked Mar 26, 2023

0 votes

0 answers

20

Applied root course

priyansh_1705

179 views

priyansh_1705 asked Jun 8, 2023

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true