Free Test ER Model and ER Diagrams – Databas...

Q1: What does ER stand for in database design?

A. Entity-Relationship B. Entity-Record C. Entity-Relation D. Entity-Report

Q2: Which symbol represents an entity in an ER diagram?

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

Q3: What symbol represents an attribute in an ER diagram?

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

Q4: Which symbol is used for relationships in ER diagrams?

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

Q5: What is a primary key in ER modeling?

A. An attribute that uniquely identifies an entity B. An entity set C. A relationship D. An attribute that can be null

Q6: Which of the following represents a weak entity?

A. Double rectangle B. Single rectangle C. Double oval D. Dashed diamond

Q7: What type of relationship is represented by a diamond connected to multiple entities?

A. Many-to-many B. One-to-one C. One-to-many D. Recursive

Q8: What is a composite attribute?

A. An attribute that can be divided into smaller parts B. An attribute that is unique C. An attribute that cannot be divided D. An attribute with NULL values

Q9: What is a derived attribute?

A. An attribute whose value is calculated from other attributes B. An attribute stored physically C. An attribute that uniquely identifies entities D. An attribute that cannot be null

Q10: How is a multivalued attribute represented in an ER diagram?

A. Double oval B. Single oval C. Dotted rectangle D. Diamond

Q11: What is a recursive relationship?

A. An entity relates to itself B. Two different entities related C. A weak entity relationship D. A relationship with multiple attributes

Q12: Which is NOT a valid cardinality ratio?

A. 4:5 B. 1:1 C. 1:N D. N:M

Q13: What does participation mean in ER modeling?

A. Whether all or some entity instances participate in a relationship B. Number of attributes in an entity C. Number of entities in a relationship D. How many keys exist

Q14: What is total participation?

A. All instances of an entity must participate in the relationship B. Some instances participate C. No participation D. Partial attribute participation

Q15: What is partial participation?

A. Only some instances of an entity participate in the relationship B. All instances participate C. No participation D. All attributes involved

Q16: How is a weak relationship represented?

A. Dashed diamond B. Solid diamond C. Dashed rectangle D. Oval

Q17: Which is true about an identifying relationship?

A. It connects weak entity to owner entity B. It connects two strong entities C. It is optional D. It is a multivalued attribute

Q18: What is an attribute key?

A. An attribute that can uniquely identify an entity instance B. An attribute with multiple values C. A derived attribute D. A composite attribute

Q19: What is the purpose of an ER diagram?

A. To model database structure graphically B. To write SQL queries C. To optimize database D. To create indexes

Q20: What does ER stand for in database design?