Entity Relationship MCQs is the set of solved MCQs of ERD(Entity relationship diagram) with repeatedly asked questions and answers.
In an E-R, B is the dominant entity and A is a subordinate entity. Select which one is incorrect?
(A). An A existence is dependent on B
(B). operationally, if A is deleted, B remains the same
(C). operationally, if A is deleted, so is B
(D). operationally, If B is deleted, so is
Answer:(A). An A existence is dependent on B
The number of entities to which another entity can be related through a relationship set is called?
(A). Cardinality
(B). Entity
(C). Schema
(D). Attributes
Answer: (A). Cardinality
The Relations bring from an E-R model will usually be in :
(A). Third normal form
(B). Second normal form
(C). First normal form
(D). Fourth normal form
Answer : (A). Third normal form
Select the attributes which made up of more than one single attribute.
(A). Multi-value attribute
(B). Derived attribute
(C). Single value attribute
(D). Composite attribute
Answer : (D). Composite attribute
An association of various entities in an Entity-Relation model is known as
(A). Relationship
(B). Record
(C). Tuple
(D). Field
Answer : (A). Relationship
If two entities have many to many relationships mostly results in how many tables.
(A). Three
(B). Two
(C). One
(D). Four
Answer :
(A). Three
Which is a set of entities of the same type that share the same properties, or attributes.
(A). Relation set
(B). Attribute set
(C). Entity set
(D). Entity model
Answer : (C). Entity set
Select about the Entity
(A). The thing in the real world
(B). Present working model
(C). Object of relation
(D). Model of relation
Answer: (A). The thing in the real world
How the Every weak entity set can be changed into a strong entity set through?
(A). using generalization
(B). using aggregation
(C). adding appropriate attributes
(D). none of the above
Answer (C). adding appropriate attributes
Select the E-R modeling technique is a _____________?
(A). Left-right approach
(B). Bottom-up approach
(C). Top-down approach
(D). None of the above
Answer :(C). Top-down approach
This process of hiding the details of entities in the ER model is known as?
(A). generalization
(B). abstraction
(C). specialization
(D). none of these above
Answer: (B). abstraction
The attribute AGE is?
(A). Single valued
(B). Derived
(C). Composite
(D). Multi-valued
Answer : (B). Derived
Select from the following the multi-valued attribute.
(A). Date_of_birth
(B). Name
(C). Phone_number
(D). All of the mentioned
Answer :(C). Phone_number
Which one is a single-valued attribute?
(A). Reference
(B). Address
(C). SUBJECT_TAKEN
(D). Register_number
Answer : (D). Register_number
The primary key in a many to one relationship, acts as a foreign key on which side?
(A). On the side where many relationships are defined
(B). On the side where a single (one) relationship is defined
(C). On both the sides
(D). Neither of them
Answer : (A). On the side where many relationships is defined
Select about weak entity set in an E-R diagram.
(A). has a primary key
(B). is not existence dependent on a dominant entity
(C). must be part of a one to many relationship set
(D). must not participate as owner in an identifying relationship with another entity set
Answer : (C). must be part of a one to many relationship set
Read More MCQs on UML Diagrams
- Deployment Diagram MCQs | UML
- Class diagram and object diagram MCQs | UML
- Use Case Diagram MCQs | UML
- UML diagrams solved MCQs UML
- UML Diagrams MCQs set 2
- Entity Relationship Diagram MCQs New
- Object-oriented analysis and design MCQs | UML
- Behavioral Modeling MCQs | UML Diagrams
- OOAD MCQs (Multiple Choice Questions Answers)
- Object-Oriented Analysis And Design MCQs
- Activity Diagram MCQs
- Sequence Diagram MCQs
- Communication Diagram MCQs
- State Machine Diagram MCQs
- Component Diagram MCQs
- Package Diagram MCQs
- Composite Structure Diagram MCQs
- Timing Diagram MCQs
- Interaction Overview Diagram MCQs
- Profile Diagram MCQs
- Behavioral Modeling MCQs
- MCQs: How many use cases, classes, sequences, DFD, ERD diagrams, etc are drawn for a system in the Final year project?