Register

Recent questions tagged er-diagram

1 votes
1 answer
32
#selfdoubt
 In the above ER diagram how many relational table and attributes will be in respective table??
In the above ER diagram how many relational table and attributes will be in respective table??
User Avatar
1 votes
2 answers
33
Minimum number of tables needed to construct a self referential relation with many to many relationship?
I think it needs three tables but have lil bit confusion
User Avatar
0 votes
0 answers
34
#DBMS #E-R diagram
Can anyone verify this? What is the minimum number of tables required in the given situation? Assume there are two entities E1 containing attributes A1 and A2 and E2 containing attributes B1 and B2 attributes respectively, and between E1 and E2 relationship is R, which contains attribute C.
Can anyone verify this?What is the minimum number of tables required in the given situation?Assume there are two entities E1 containing attributes A1 and A2 and E2 contai...
User Avatar
0 votes
2 answers
35
ER Model to Relational Model Conversion
What is the minimum number of relations required to represent a one-to-many relationship having total participation on the many side? Can i have just a single table with all attributes and (A1,B1) as a composite primary key?
What is the minimum number of relations required to represent a one-to-many relationship having total participation on the many side?Can i have just a single table with a...
User Avatar
1 votes
1 answer
36
What is the degree of a Recursive Relation in Er Modelling?
What is the degree of a Recursive Relation in Er Modelling? I think its 1 since only one entity set is participating but can it be 2 since role is different for entity set?
What is the degree of a Recursive Relation in Er Modelling?I think its 1 since only one entity set is participating but can it be 2 since role is different for entity set...
User Avatar
2 votes
3 answers
37
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$
User Avatar
1 votes
1 answer
38
GATE Overflow Test Series | Mock GATE | Test 4 | Question: 59
The minimum numbers of relations required when the below ER diagram is converted to Relational model ensuring no redundancies is ________
The minimum numbers of relations required when the below ER diagram is converted to Relational model ensuring no redundancies is ________
User Avatar
1 votes
1 answer
39
GATE Overflow Test Series | Mixed Subjects | Test 3 | Question: 21
The numbers of relations required when the below ER diagram is converted to Relational model is ________
The numbers of relations required when the below ER diagram is converted to Relational model is ________
User Avatar
2 votes
1 answer
40
GATE Overflow Test Series | Mixed Subjects | Test 3 | Question: 22
The numbers of relations required when the below ER diagram is converted to Relational model is ________
The numbers of relations required when the below ER diagram is converted to Relational model is ________
User Avatar
1 votes
1 answer
47
ER Model Self Doubt
How to represent referential integrity constraint in ER model? pls explain with diagram
How to represent referential integrity constraint in ER model?pls explain with diagram
User Avatar
0 votes
2 answers
49
Self Doubt: Databases ER diagram
Here if check_txn contains its own attributes then during converting into a relational model where does its attributes will be placed either in account side ( strong entity set) or check side (weak entity set)? and why?
Here if check_txn contains its own attributes then during converting into a relational model where does its attributes will be placed either in account side ( strong enti...
User Avatar
1 votes
0 answers
50
#self doubt
my doubt is- when question is said find minimum no.of table to given E-R diagram,and additional condition table are satisfying 1NF/2NF/3NF. how we conclude table is 1NF/2NF/3NF.
my doubt is- when question is said find minimum no.of table to given E-R diagram,and additional condition table are satisfying 1NF/2NF/3NF. how we conclude table is 1NF/2...
User Avatar
0 votes
0 answers
51
self doubt
What is the correct answer of this Question and what are the Minimized tables ???
What is the correct answer of this Question and what are the Minimized tables ???
User Avatar
2 votes
0 answers
55
DBMS Korth Edition 6 Exercise 7 Question 27 (Page No. 321)
Explain the distinction between condition-defined and user-defined constraints. Which of these constraints can the system check automatically? Explain your answer.
Explain the distinction between condition-defined and user-defined constraints.Which of these constraints can the system check automatically?Explain your answer.
User Avatar
Page: