Recent questions tagged er-diagram / GATE Overflow for GATE CSE

1 votes

2 answers

1

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

2

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

3

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

341 views

Ramayya asked Jan 7

0 votes

0 answers

4

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

376 views

practicalmetal asked Oct 26, 2023

0 votes

0 answers

5

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

500 views

rexritz asked Aug 29, 2023

0 votes

1 answer

6

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

7

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

Pradeep_Kumar

487 views

Pradeep_Kumar asked Jul 13, 2023

0 votes

0 answers

8

Applied root course

priyansh_1705

179 views

priyansh_1705 asked Jun 8, 2023

0 votes

0 answers

9

Database ER model
Consider the following relation (capitalized letters are attributes and lower letters are values). X: From the given FDs find the dependencies that seems to apply on X and identify a possible key (Candidate key) for X. A→C,D→E,C→A,E→B E→A,C→B,B→D,B→A

Consider the following relation (capitalized letters are attributes and lower letters are values).X:From the given FDs find the dependencies that seems to apply on X and ...

Ashutosh_17

433 views

Ashutosh_17 asked Apr 13, 2023

1 votes

2 answers

10

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

972 views

Ashutosh_17 asked Apr 13, 2023

2 votes

1 answer

11

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

734 views

GO Classes asked Mar 26, 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