This set of Advanced Database Management System focuses on “Entity Relationship Diagram MCQs (Multiple Choice Questions and Answers )”.
1. An ER diagram can express the overall __________of a database graphically
- View Structure
- Logical Structure
- Model Structure
- Architectural structure
2. Which of the following structure represent the entity sets?
- Double rectangle
- Diamond
- Rectangle
- Ellipses
3. Ellipses represent_________
- Relationship sets
- Attributes
- Derived attributes
- Multivalued attributes
4. Diamond Represents______
- Relationship sets
- Attributes
- Derived attributes
- Multi-valued attributes
5. Which of the following diagram link attributes to entity sets and entity sets to relationship sets?
- Double lines
- Dashed Ellipses
- Double ellipses
- Lines
6. Double ellipses represents_____
- Derived attributes
- Multi-valued Attributes
- Total participation of an entity in a relationship set
- Weak entity sets
7. Dashed ellipses represents_____
- Derived attributes
- Multi-valued Attributes
- Total participation of an entity in a relationship set
- Weak entity sets
8. Double Line indicate_____
- Derived attributes
- Multi-valued Attributes
- Total participation of an entity in a relationship set
- Weak entity sets
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
- One to one, many to one
- many to many, one to many
- Many to many, one to one
- One to One, Many to Many
- One to one, many to one
- many to many, one to many
- Many to many, one to one
- One to One, Many 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
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
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
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
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
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