Quiz for ER Modeling

Q1: What does ER in ER diagram stand for?

A. Entity Relational B. Entity Relationship C. Entry Record D. Extended Relation

Q2: What does ER in ER model stand for?

A. Entity Relationship B. Entity Record C. Extended Relational D. Entity Resource

Q3: Which symbol is used to represent an entity in an ER diagram?

A. Rectangle B. Oval C. Diamond D. Parallelogram

Q4: Which symbol is used to represent a relationship in an ER diagram?

A. Rectangle B. Oval C. Diamond D. Triangle

Q5: Which symbol is used to represent attributes in an ER diagram?

A. Diamond B. Oval C. Rectangle D. Circle

Q6: What is a weak entity?

A. An entity with no attributes B. An entity that can exist without any other entity C. An entity that depends on another entity for its identification D. An entity with many relationships

Q7: What connects a weak entity to its identifying entity?

A. Primary Key B. Foreign Key C. Identifying Relationship D. Multivalued Attribute

Q8: What does a double rectangle represent in ER diagrams?

A. Multivalued Attribute B. Weak Entity C. Derived Attribute D. Strong Relationship

Q9: What is a derived attribute?

A. An attribute that is stored B. An attribute that is derived from other attributes C. An attribute with multiple values D. An attribute with no value

Q10: Which notation represents total participation of an entity in a relationship?

A. Single line B. Double line C. Dotted line D. Dual arrow

Q11: What is cardinality in ER modeling?

A. The number of attributes in an entity B. The number of values in a relation C. The number of entities involved in a relationship D. The number of rows in a table

Q12: Which of the following best describes a one-to-many relationship?

A. One entity instance relates to only one instance of another entity B. Many entity instances relate to one instance of another entity C. One entity instance relates to many instances of another entity D. Many entity instances relate to many others

Q13: Which of the following is used to represent attributes in an ER diagram?

A. Rectangle B. Oval C. Diamond D. Line

Q14: What symbol is used to represent a relationship in ER diagrams?

A. Oval B. Rectangle C. Diamond D. Triangle

Q15: Which of the following best represents a weak entity?

A. Entity with no attributes B. Entity with no key attribute C. Entity with no relationship D. Entity that cannot be stored

Q16: What is a derived attribute in ER modeling?

A. Attribute that can be calculated from other attributes B. Attribute derived from another table C. Attribute that stores default values D. Attribute that has multiple values

Q17: What does a double rectangle represent in an ER diagram?

A. Entity Set B. Weak Entity Set C. Multivalued Attribute D. Derived Attribute

Q18: Which of the following shows the relationship between entities?

A. Attributes B. Keys C. Cardinality D. Entity Sets

Q19: What does a double oval indicate in ER diagrams?

A. Derived attribute B. Multivalued attribute C. Key attribute D. Weak attribute

Q20: Which is true about an ER diagram?

A. It describes the database schema structure using SQL B. It visually represents entities and relationships C. It is used for indexing D. It shows stored procedures

Q21: Which of the following is a type of entity in ER modeling?

A. Primary Entity B. Secondary Entity C. Strong Entity D. Flat Entity

Q22: Which of the following is an example of a one-to-many relationship?

A. One customer has one address B. One student has many courses C. One city has one airport D. Many books have one author