Register

Recent questions tagged er-diagram

4 4 votes
2 answers 2 answers
5.0k
5.0k views
Number of tables
What is minimum number of tables requires, to represent above ER diagram?(Does total participation and partial participation will take a role in this question)?
User Avatar
38 38 votes
2 answers 2 answers
19.1k
19.1k views
WHAT AN INTERESTING DBMS QUESTION!!
Let $E1$ and $E2$ be two entities and $R$ is a relation between $E1$ and $E2$, then what is the minimum no of tables required to represent $E1, E2$ and $R$ if -1. $E1$ an...
User Avatar
0 0 votes
0 0 answers
878
878 views
Strong And Weak Entity
Why there is always $1:M$ relationship between a strong entity set and a weak entity set ,why not $M:1$ and $M:N$?
User Avatar
2 2 votes
1 answers 1 answer
2.3k
2.3k views
ER Diagram
Consider the following $ER$ model: If $‘n’$ entries in $E_1$ and $‘m’$ entries in $E_2$. How many entries in relationship set $(R)$?At least $n$At most $n$Exactly $n$At l...
User Avatar
1 1 vote
2 2 answers
1.3k
1.3k views
Made Easy Workbook : Relational Model
What should be correct option for 1. and why...?
User Avatar
0 0 votes
3 3 answers
902
902 views
relational model
minimum no. of tables required....!!!How to do such question where aggregation generalization or specialization is involved
User Avatar
0 0 votes
0 0 answers
1.7k
1.7k views
ER Diagram to Relation Doubt
When we have a many to one relationship between two entities and participation is total on many side then we can combine them and result in two tables. But why can't we d...
User Avatar
1 1 vote
0 0 answers
908
908 views
Er diagram to table Doubt
Please clarify me:-In one to one with total participation on any side we can simply merge everything to one table because it's one to one so no redundancy will be there,b...
User Avatar
3 3 votes
3 3 answers
2.4k
2.4k views
ER Diagram to table 2
Please Explain in detail i am weak in this topic
User Avatar
1 1 vote
1 1 answer
2.6k
2.6k views
Er Diagram to Table 1
The number of minimum Relations which satisfy 1NF _________. (Partial participation between E1 and R should not lost in RDBMS design).Please explain every point in detail...
User Avatar
3 3 votes
1 1 answer
1.9k
1.9k views
ER diagram to relational model conversion
Let E1 and E2 be two entities and R is a relation between E1 and E2, then what is the minimum no of tables required to represent E1, E2 and R if - E1 and E2 have 1:m card...
User Avatar
2 2 votes
3 3 answers
1.7k
1.7k views
INTERESTING QUESTION ON ER DIAGRAMS
How many minimum number of tables are required for this ER Diagram?
User Avatar
10 10 votes
2 2 answers
8.6k
8.6k views
ISRO CSE 2018 | Question: 52
In $\text{E-R}$ model, $\text{Y}$ is the dominant entity and $\text{X}$ is subordinate entity If $\text{X}$ is deleted, then $\text{Y}$ is also deleted If $\text{Y}$ is d...
User Avatar
0 0 votes
1 answers 1 answer
473
473 views
Self Doubt on DBMS
Please tell if this formula is correct:Minimum number of tables for an ER Diagram = Number of Weak Entities + Number of Strong Entities + Number of Composite Attributes +...
User Avatar
0 0 votes
1 1 answer
1.8k
1.8k views
Er diagram to table
I am confused in deciding the number of tables required for converting er diagram i know :- 1. One to one with partial participation required two tables2. Many to one re...
User Avatar
0 0 votes
0 0 answers
662
662 views
ER diagram Doubts.
Minimization of ER diagram. Need explanation.
User Avatar
68 68 votes
5 answers 5 answers
46.9k
46.9k views
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 ...
User Avatar
3 3 votes
0 0 answers
3.2k
3.2k views
ER diagram
Minimum number of tables required for above diagram ________
User Avatar
2 2 votes
1 answers 1 answer
1.3k
1.3k views
MadeEasy Test Series 2018: Databases - Er Diagram
$E_{11}\left (\underline AB \right )$ and $E_{12}\left (\underline {AC} \right )$ is obvious separation but can we not merge like this to satisfy 2NF $E_{11}R\left (\unde...
User Avatar
2 2 votes
1 1 answer
856
856 views
MadeEasy Test Series 2018: Databases - Er Diagram
User Avatar
2 2 votes
1 1 answer
2.4k
2.4k views
Can a weak entity be dependent on another weak entity in ER-Model?
This is an excerpt which i found on Quora that answered the question. But I still wanted to know few more things.1. If there is no strong entity in the schema then can th...
User Avatar
2 2 votes
0 0 answers
1.1k
1.1k views
ACE Test Series
User Avatar
1 1 vote
0 0 answers
490
490 views
Total Participation
What effect does Total Participation of an entity have in MInimisation of ER diagram? I have read a lot of questions and even this articlehttps://www.geeksforgeeks.org/mi...
User Avatar
3 3 votes
2 answers 2 answers
1.5k
1.5k views
ER Diagram- min no of relations
How the correct answer is 2?
User Avatar
2 2 votes
1 1 answer
885
885 views
er diagram
User Avatar
3 3 votes
1 1 answer
1.0k
1.0k views
Gate model paper
Explain it ::: Cardinality ratio not given then how can be find?
User Avatar
2 2 votes
1 1 answer
1.0k
1.0k views
ER model
How multivalued attributes should be seperated ?
User Avatar
1 1 vote
1 1 answer
649
649 views
Ace Test Series: Databases - Er Diagram
User Avatar
2 2 votes
1 1 answer
1.2k
1.2k views
DBMS ER-Diagram (No of Relations)
Options was:- 4,5,6,7
User Avatar
4 4 votes
1 1 answer
1.3k
1.3k views
Ace Test series: Databases - Er Diagram
What type of representation is this ??No cardinality ratio and what is diffrence between arrowed line (between R and B) and solid line (between A and R)
User Avatar
Page: