This set of Advanced Database Management System focuses on “Entity Relationship Diagram MCQs (Multiple Choice Questions and Answers )”.
PRACTICE IT NOW TO SHARPEN YOUR CONCEPT AND KNOWLEDGE
1. An ER diagram can express the overall __________of a database graphically
- View Structure
- Logical Structure
- Model Structure
- Architectural structure
B. Logical Structure
2. Which of the following structure represent the entity sets?
- Double rectangle
- Diamond
- Rectangle
- Ellipses
C. Rectangle
3. Ellipses represent_________
- Relationship sets
- Attributes
- Derived attributes
- Multivalued attributes
B. Attributes
4. Diamond Represents______
- Relationship sets
- Attributes
- Derived attributes
- Multi-valued attributes
A. Relationship sets
5. Which of the following diagram link attributes to entity sets and entity sets to relationship sets?
- Double lines
- Dashed Ellipses
- Double ellipses
- Lines
D. Lines
6. Double ellipses represents_____
- Derived attributes
- Multi-valued Attributes
- Total participation of an entity in a relationship set
- Weak entity sets
B. Multi-valued Attributes
7. Dashed ellipses represents_____
- Derived attributes
- Multi-valued Attributes
- Total participation of an entity in a relationship set
- Weak entity sets
A. Derived attributes
8. Double Line indicate_____
- Derived attributes
- Multi-valued Attributes
- Total participation of an entity in a relationship set
- Weak entity sets
C. Total participation of an entity in a relationship set
Double lines are used in ER diagram to indicate that the participation of an entity set in a relationship set is total: that is each entity in the entity set occurs in at least one relationship in that relationship set. For example consider the relationship borrower between customers and loans. A double line from loan to borrower indicates that each loan must have at least one associated customer.
9. Double Rectangle represent_____
- Derived attributes
- Multi-valued Attributes
- Total participation of an entity in a relationship set
- Weak entity sets
D. Weak entity sets
10. Consider the entity relationship which consists of two entity sets, customer and loan, related through a binary relationship set borrower. A directed line(->) from the relationship set borrower to the entity set loan specified that borrower is either a_________ or _______ relationship.
- One to one, many to one
- many to many, one to many
- Many to many, one to one
- One to One, Many to Many
A. One to one, many to one
11. Consider the entity relationship which consists of two entity sets, customer and loan, related through a binary relationship set borrower. An undirected line (--) from the relationship set borrower to the entity set loan specifies that borrower is either a __________ or __________relationship set from customer to loan.
- One to one, many to one
- many to many, one to many
- Many to many, one to one
- One to One, Many to Many
B. many to many, one to many
12. An Edge between a entity set and a binary relationship set can have an associated minimum and maximum cardinality, shown in the form of l and h, where l is the minimum and h is the maximum cardinality. What a minimum Cardinality value of 1 indicates?
- Partial Participation of the entity set in the relationship
- Total Participation of the entity set in the relationship
- The entity participates in at most one relationship
- No limit on participation
B. Total Participation of the entity set in the relationship
13. An Edge between a entity set and a binary relationship set can have an associated minimum and maximum cardinality, shown in the form of l and h, where l is the minimum and h is the maximum cardinality. What a Maximum Cardinality value of 1 indicates?
- Partial Participation of the entity set in the relationship
- Total Participation of the entity set in the relationship
- The entity participates in at most one relationship
- No limit on participation
C. The entity participates in at most one relationship
14. An Edge between a entity set and a binary relationship set can have an associated minimum and maximum cardinality, shown in the form of l and h, where l is the minimum and h is the maximum cardinality. What a Maximum Cardinality value of * indicates?
- Partial Participation of the entity set in the relationship
- Total Participation of the entity set in the relationship
- The entity participates in at most one relationship
- No limit on participation
D. No limit on participation
15. An entity set may not have sufficient attributes to form a primary key; such an entity set is termed as______
- Strong Entity set
- Weak Entity set
- Composite Entity set
- Owner entity set
B. Weak Entity set
For example consider the entity set payment, which has the three attributes; payment –number, payment-date, and payment-amount. Payment-numbers are typically sequence numbers, starting from 1.generated separately for each loan. Thus although each payment entity is distinct, payment for different loan may share the same payment numbers. Thus this entity set does not have a primary key; it is weak entity set.
16. An entity set that has attributes to form a primary key; such an entity set is termed as______
- Strong Entity set
- Weak Entity set
- Composite Entity set
- Owner entity set
A. Strong Entity set
17. For a weak entity set to be meaningful, it must be associated with another entity set called the ___________
- Strong entity set
- stronger entity set
- Owner entity set
- All of the above
C. Owner entity set
