Register

Recent questions tagged er-diagram

1 votes
1 answer
241
ER model
After mapping an ER diagram relationship to Relational model using the set of rules for 1:n,m:n etc,will the achieved tables will always be in BCNF ?
After mapping an ER diagram relationship to Relational model using the set of rules for 1:n,m:n etc,will the achieved tables will always be in BCNF ?
User Avatar
4 votes
3 answers
242
er model,databases
IF A RELATION HAS ______________ CARDINALITY, THEN NO MINIMIZATION CAN TAKE PLACE. a) 1:n b)m:m c)n:1 d) none
IF A RELATION HAS ______________ CARDINALITY, THEN NO MINIMIZATION CAN TAKE PLACE.a) 1:nb)m:mc)n:1d) none
User Avatar
1 votes
4 answers
243
UGC NET CSE | June 2010 | Part 2 | Question: 16
An entity instance is a single occurrence of an ______. Entity type Relationship type Entity and relationship type None of these
An entity instance is a single occurrence of an ______.Entity typeRelationship typeEntity and relationship typeNone of these
User Avatar
0 votes
3 answers
244
UGC NET CSE | December 2010 | Part 2 | Question: 16
In generalisation, the differences between members of an entity is Maximized Minimized Both (A) & (B) None of these
In generalisation, the differences between members of an entity isMaximizedMinimizedBoth (A) & (B)None of these
User Avatar
2 votes
3 answers
245
doubt | ER Diagram
wat does arrow represent in er diagram when can we many to one or one to many by seeing arrows
wat does arrow represent in er diagramwhen can we many to one or one to many by seeing arrows
User Avatar
4 votes
1 answer
247
UGC NET CSE | December 2013 | Part 3 | Question: 55
Consider the following ER diagram: The minimum number of tables required to represent $M, N, P, R_1, R_2$ is 2 3 4 5
Consider the following ER diagram:The minimum number of tables required to represent $M, N, P, R_1, R_2$ is2345
User Avatar
2 votes
1 answer
251
UGC NET CSE | September 2013 | Part 3 | Question: 48
Match the following $:$ ... $\text{(a)-(iii), (b)-(iv), (c)-(ii), (d)-(i)}$
Match the following $:$$\begin{array}{} \text{(a)} & \text{Create} & \text{(i)} & \text{The ER model} \\ \text{(b)} & \text{Select} & \text{(ii)} & \text{Relationship m...
User Avatar
4 votes
3 answers
252
UGC NET CSE | December 2014 | Part 2 | Question: 18
What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity-relationship diagram Generalization Aggregation Specialization Adding suitable attributes
What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity-relationship diagramGeneralization Aggregation Specia...
User Avatar
4 votes
2 answers
253
ISRO2016-56
Goals for the design of the logical scheme include avoiding data inconsistency being able to construct query easily being able to access data efficiently All of the above
Goals for the design of the logical scheme includeavoiding data inconsistencybeing able to construct query easilybeing able to access data efficientlyAll of the above
User Avatar
1 votes
2 answers
254
E-R and Relational Model
Which of the following are true for relational database? Number of rows is cardinality, number of columns is degree Tuple is an entity, column is a relation Relation is an entity, tuple is a relationship Row is a tuple, column is an attribute b & d a & d b & c c & d
Which of the following are true for relational database?Number of rows is cardinality, number of columns is degreeTuple is an entity, column is a relationRelation is an e...
User Avatar
8 votes
3 answers
255
ISRO2015-16
Consider the following Relationship Entity Diagram(ERP) Which of the following possible relations will not hold if the above ERD is mapped into a relation model? Person (NID, Name) Qualification (NID, ExamID, QualifiedDate) Exam (ExamID, NID, ExamName) Exam (ExamID, ExamName)
Consider the following Relationship Entity Diagram(ERP)Which of the following possible relations will not hold if the above ERD is mapped into a relation model?Person (NI...
User Avatar
0 votes
2 answers
256
ER diagram
if anyone got this then plz explain me as well..
if anyone got this then plz explain me as well..
User Avatar
3 votes
3 answers
260
entities
User Avatar
0 votes
2 answers
262
net june 15
User Avatar
1 votes
2 answers
264
Consider the following ER-Model
User Avatar
3 votes
3 answers
265
how many tables will get generated for following E-R
how many tables will get generated for following E-R I believe an answer is 3. 2 tables for 2 different multivalued attributes and one for entity "Dept.".
how many tables will get generated for following E-RI believe an answer is 3.2 tables for 2 different multivalued attributes and one for entity "Dept.".
User Avatar
2 votes
1 answer
266
Primary key
R(A,B) have tuples 1,null Null,2 1,5 Then what is primary key A Or B or AB
R(A,B) have tuples 1,null Null,2 1,5Then what is primary key A Or B or AB
User Avatar
1 votes
1 answer
267
Minimum number of relation for given ER diagram
Given answer is 2, but I think that for each multivalue attribute we need a relation and one for the main entity, therefore 3 should be the answer. Please correct me if I am wrong
Given answer is 2, but I think that for each multivalue attribute we need a relation and one for the main entity, therefore 3 should be the answer. Please correct me if I...
User Avatar
3 votes
4 answers
269
Minimum Number of tables for given ER-Diagram
User Avatar
3 votes
1 answer
270
ER DIAGRAM
I think ans is A,Please Confirm?
I think ans is A,Please Confirm?
User Avatar
Page: