Recent questions tagged er-diagram

1 votes
0 answers
91
Consider the following ER diagramThe minimum no of foreign key required for RDBMS design of given ER model _______________
0 votes
1 answer
94
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 ma...
1 votes
0 answers
95
0 votes
0 answers
97
0 votes
0 answers
98
How 1:1 cardinality with total participation of atleast 1 entity needs min no. of tables = 1 ?1:1 with partial participation of both entities needs min no of tables = 2?
1 votes
2 answers
101
The minimum number of tables needed to represent M,N,P,R1,R2 is …The given ans is 2.I think the ans should be 3.
0 votes
0 answers
102
How many number of tables are required to convert the ER diagram into relational model?it is 3 or 4 or 2 or 1?
1 votes
0 answers
104
How to do these type of questions?Given correct answer is 4 . i’m getting answer as 6. Pls explain.
1 votes
0 answers
106
Consider the following ER-diagram for simple database for the National Hockey League given below:The minimum number of table required for database to be in 2NF is _______...
0 votes
0 answers
107
1 votes
0 answers
108
0 votes
0 answers
109
In case of 1:1 relationships, when can we have a minimum of 1 table?when both the entities have total participationwhen atleast one entity have total participation
1 votes
1 answer
110
0 votes
2 answers
111
0 votes
2 answers
114
0 votes
0 answers
115
Consider ER Diagram Identify the Minimum number of relation satisfying 2nf ?A. 1B. 2C. 3D. 4
3 votes
1 answer
116
Is multivalued attribute always create extra table in ER diagram?
0 votes
1 answer
118
According to me two tables are enough to represent this ER diagram [Loan,Loans] [Bank,Branches,BankBranch].let me know if I am wrong.
1 votes
0 answers
119
0 votes
0 answers
120