INMT 342 EXAM 1 QUESTIONS WITH VERIFIED
ANSWERS
What does ERD stand for? - Answers - Entity-Relationship Diagram
What is a table in conceptual modeling? - Answers - An Entity
What is a field in Conceptual Modeling? - Answers - An attribute
What are the two requirements of entities? - Answers - 1) must have many instances
2) must have multiple fields or attributes
What are the three types of entities? - Answers - Strong entity, Weak entity, and
associative entity
What are the five types of attributes (fields)? - Answers - Identifier, Required/Optional,
Simple/composite, single valued/multivalued, stored/derived
How do you represent a multi-valued attribute? - Answers - {}
How do you show a derived attribute? - Answers - [ ]
When do you create an associative entity? - Answers - 1) When there is a M:M
relationship
2) When there is a relationship attribute
3) When the relationship degree is ternary or above
What are the two types of subtype constraints? - Answers - Completeness constraint
and disjoint constraint
What is total specialization and how is it shown? - Answers - When all instances MUST
be a subtype; bold field name and a double line
What is partial specialization and how is it shown? - Answers - When all instances DO
NOT have to be a subtype; normal text field name and a single line
What is disjointness and how is it shown? - Answers - When all instances can only be
one subtype; discriminator field is a simple field, discriminator label in space has an '=',
hub contains a 'd', connectors have single value labels
What is overlap and how is it shown? - Answers - When instances can be a part of one
or multiple subtypes; discriminator field is a composite field "Manf?", discriminator label
has a ':', hub contains an 'o', and connectors have Y/N questions
ANSWERS
What does ERD stand for? - Answers - Entity-Relationship Diagram
What is a table in conceptual modeling? - Answers - An Entity
What is a field in Conceptual Modeling? - Answers - An attribute
What are the two requirements of entities? - Answers - 1) must have many instances
2) must have multiple fields or attributes
What are the three types of entities? - Answers - Strong entity, Weak entity, and
associative entity
What are the five types of attributes (fields)? - Answers - Identifier, Required/Optional,
Simple/composite, single valued/multivalued, stored/derived
How do you represent a multi-valued attribute? - Answers - {}
How do you show a derived attribute? - Answers - [ ]
When do you create an associative entity? - Answers - 1) When there is a M:M
relationship
2) When there is a relationship attribute
3) When the relationship degree is ternary or above
What are the two types of subtype constraints? - Answers - Completeness constraint
and disjoint constraint
What is total specialization and how is it shown? - Answers - When all instances MUST
be a subtype; bold field name and a double line
What is partial specialization and how is it shown? - Answers - When all instances DO
NOT have to be a subtype; normal text field name and a single line
What is disjointness and how is it shown? - Answers - When all instances can only be
one subtype; discriminator field is a simple field, discriminator label in space has an '=',
hub contains a 'd', connectors have single value labels
What is overlap and how is it shown? - Answers - When instances can be a part of one
or multiple subtypes; discriminator field is a composite field "Manf?", discriminator label
has a ':', hub contains an 'o', and connectors have Y/N questions
