Dark Mode

Recent questions tagged er-diagram

3 votes

1 answer

181

ER Diagram: Minimum number of tables needed
this question is from virtual gate test series. what is the minimum number of RDBMS tables needed for the following er diagram:

Manu Thakur asked in Databases Sep 17, 2017

1.9k views

5 votes

4 answers

182

UGC NET CSE | December 2009 | Part 2 | Question: 17
Specialization is __________ process. (A) top-down (B) bottom up (C) both (A) and (B) (D) none of these

rishu_darkshadow asked in Databases Sep 17, 2017

by rishu_darkshadow

6.3k views

2 votes

4 answers

183

UGC NET CSE | December 2009 | Part 2 | Question: 16
The E-R model is expressed in term of I. Entities II. The relationship among entities. III. The attributes of the entities. IV. Functional relationship. (A) I, II (B) I, II, IV (C) II, II, IV (D) I, II, III

rishu_darkshadow asked in Databases Sep 17, 2017

by rishu_darkshadow

4.6k views

1 vote

1 answer

184

set2018 asked in Databases Sep 14, 2017

2.6k views

1 vote

3 answers

185

er diagram
model----> make make----->model both none

set2018 asked in Databases Sep 11, 2017

563 views

2 votes

1 answer

186

Test by Bikram | Databases | Test 2 | Question: 18
The above ER diagram depicts a book rental scheme. If this ER diagram is mapped to a relational model, to correctly depict this above scenario, the total number of relations required will be _________.

Bikram asked in Databases Aug 26, 2017

by Bikram

436 views

0 votes

2 answers

187

How to find Key Constraint in 1:M cardinality Entity set?
I have a problem in identifying the key constraints of the Entity set. As in the relation, the key constraint should be from M-side. But here, in this case, according to me Father is the key constraint. So for this, the relation is 1:M. In this case, it doesn't satisfy Father to be the key constraint.

Pavan Boro asked in Databases Aug 19, 2017

484 views

9 votes

3 answers

188

#ER model
Answer should be 1:1 isn't it ? Please Clear If i am wrong. Consider a business rule such as “Each department is manged by atmost one employee”? What is the cardinality from employee to the department? $1:1$ $\text{1 : m}$ $\text{m : 1}$ $\text{m : n}$

junaid ahmad asked in Databases Aug 14, 2017

by junaid ahmad

982 views

7 votes

3 answers

189

ER-MODEL
I think there is one to one relation and participation from professor and course side is partial.

junaid ahmad asked in Databases Aug 14, 2017

by junaid ahmad

928 views

15 votes

13 answers

190

Minimum number of tables to represent ER-Diagram
How many minimum relations required for given ER diagram ?

targate2018 asked in Databases Aug 12, 2017

8.8k views

11 votes

4 answers

191

Minimum number of tables to represent ER-Diagram
The minimum number of tables to represent ER-Diagram such that the relational database satisfies 1NF.

targate2018 asked in Databases Aug 11, 2017

11.8k views

3 votes

0 answers

192

ER diagrams and functional dependency
Let R represents an one to many relationship between entities E1 and E2 and the set A, B attributes represent the key of R (A is key for E1 and B is key for E2) then which of the following statements is correct? The FD, A→B will only holds The FD, B→A will only holds (a) and (b) hold together Neither (a) nor (b) holds

just_bhavana asked in Databases Aug 4, 2017

by just_bhavana

716 views

2 votes

1 answer

193

how to represent foreign key in er diagram
how to represent foreign key in er diagram

Arjun Kumar 1 asked in Databases Jul 31, 2017

by Arjun Kumar 1

3.5k views

1 vote

1 answer

194

ER to relational model
what is the minimum number of tables required to this ER-model. Consider Only "works_for" and "manages" relationship

reena_kandari asked in Databases Jul 15, 2017

by reena_kandari

574 views

0 votes

2 answers

195

ACE Practice book DBMS
Participation Constraints can not be represented for a. Unary relationships b. Binary relationships c. Ternary relationships d. None

Arnab Bhadra asked in Databases Jun 21, 2017

by Arnab Bhadra

1.3k views

6 votes

3 answers

196

ISRO2017-8
Which symbol denote derived attributes in ER Model? Double ellipse Dashed ellipse Squared ellipse Ellipse with attribute name underlined

sh!va asked in Databases May 7, 2017

by sh!va

9.1k views

18 votes

3 answers

197

Self doubt
The number of tables required in SELF-REFERENTIAL relation when different mappings(1: M, M:1, 1:1, M: N) are used with different participation (Partial Participation at both sides, Total Participation at both sides and partial participation at one side). (Tabular Format answer will be appreciated).

Shubhanshu asked in Databases Apr 2, 2017

6.5k views

1 vote

2 answers

198

ME Workbook
1. How many minimum tables required which satisfy 1NF. 2. How many minimum tables required which satisfy BCNF. 3. How many minimum tables required which satisfy 4NF.

Shubhanshu asked in Databases Apr 2, 2017

1.9k views

62 votes

3 answers

199

GATE CSE 2017 Set 2 | Question: 17
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? Relationship ... of $A$ in $R$ is total Relationship $R$ is many-to-one and the participation of $A$ in $R$ is partial

Madhav asked in Databases Feb 14, 2017

by Madhav

22.3k views

1 vote

2 answers

200

E R model
why not b) option

Sanket_ asked in Databases Feb 8, 2017

729 views

0 votes

3 answers

201

Self Doubt
Do we need to create a separate table for each of the multivalued attribute irrespective of normal form always?

Gate Madrista asked in Databases Feb 3, 2017

by Gate Madrista

594 views

0 votes

1 answer

202

AmitPatil asked in Databases Feb 3, 2017

719 views

2 votes

1 answer

203

Ace Test Series: Databases - Er Diagram

AmitPatil asked in Databases Feb 1, 2017

897 views

8 votes

2 answers

204

Higher normal form decomposition
$X$ is an entity set. $E$ and $F$ are multivalued attributes. How many minimum tables which satisfy 1NF ? How many minimum tables which satisfy 2NF ? How many minimum tables which satisfy 3NF ? How many minimum tables which satisfy BCNF ? How many minimum tables which satisfy 4NF ?

dd asked in Databases Feb 1, 2017

by dd

2.6k views

0 votes

2 answers

205

ER Diagram to RDMS Model
while converting one to one relationship from ER diagram to RDMS, without total participation on either side, we can represent the relationship using primary- foreign key contraint without making a new table?? Am i right??

sushmita asked in Databases Jan 31, 2017

1.1k views

0 votes

0 answers

206

MadeEasy Subject Test: Databases - Er Diagram

vaishali jhalani asked in Databases Jan 30, 2017

by vaishali jhalani

426 views

4 votes

2 answers

207

MadeEasy CBT 2017: Databases - Er Diagram
Please explain how they merged.(Modified)

target2017 asked in Databases Jan 30, 2017

2.1k views

5 votes

2 answers

208

Understanding How to Identify Number of Tables for ER Diagram
Doubts - 1) When a ER diagram is given and no cardinalities are provided. How to determine relationship type 1:1 or 1:N or M:N ? Generally in such ER diagrams arrows are given. Referring to this article where arrow is a ... ternary relation? Is there a relationship between E3 and E2 via R1 in below example ? Question 1 - Question 2 -

yg92 asked in Databases Jan 29, 2017

by yg92

7.2k views

1 vote

2 answers

209

GATEFORUM TEST
Is the explaination Correct ?

Dhawal Gajwe asked in Databases Jan 29, 2017

by Dhawal Gajwe

395 views

0 votes

0 answers

210

Ace Test Series: Databases - Er Diagram
Since A---> R1<--B is 1 : m and n : 1 type relationship yet of having total participation we have 1-- >m<--1 so how can merge table A into table B ? As R1 can map more than one tuples.

Decota asked in Databases Jan 28, 2017

by Decota

262 views

Page:

« prev
1
2
3
4
5
6
7
8
9
10
next »

Recent questions tagged er-diagram