INMT 342 Exam 1 questions with
correct answers
What does ERD stand for? - correct answer ✔✔ Entity-Relationship Diagram
What is a table in conceptual modeling? - correct answer ✔✔ An Entity
What is a field in Conceptual Modeling? - correct answer ✔✔ An attribute
What are the two requirements of entities? - correct answer ✔✔ 1) must have many instances
2) must have multiple fields or attributes
What are the three types of entities? - correct answer ✔✔ Strong entity, Weak entity, and
associative entity
What are the five types of attributes (fields)? - correct answer ✔✔ Identifier,
Required/Optional, Simple/composite, single valued/multivalued, stored/derived
How do you represent a multi-valued attribute? - correct answer ✔✔ {}
How do you show a derived attribute? - correct answer ✔✔ [ ]
When do you create an associative entity? - correct answer ✔✔ 1) When there is a M:M
relationship
2) When there is a relationship attribute
3) When the relationship degree is ternary or above
correct answers
What does ERD stand for? - correct answer ✔✔ Entity-Relationship Diagram
What is a table in conceptual modeling? - correct answer ✔✔ An Entity
What is a field in Conceptual Modeling? - correct answer ✔✔ An attribute
What are the two requirements of entities? - correct answer ✔✔ 1) must have many instances
2) must have multiple fields or attributes
What are the three types of entities? - correct answer ✔✔ Strong entity, Weak entity, and
associative entity
What are the five types of attributes (fields)? - correct answer ✔✔ Identifier,
Required/Optional, Simple/composite, single valued/multivalued, stored/derived
How do you represent a multi-valued attribute? - correct answer ✔✔ {}
How do you show a derived attribute? - correct answer ✔✔ [ ]
When do you create an associative entity? - correct answer ✔✔ 1) When there is a M:M
relationship
2) When there is a relationship attribute
3) When the relationship degree is ternary or above
