INMT 342 FINAL UTK EXAM WITH ALL CORRECT &
100% VERIFIED ANSWERS|ACTUAL COMPLETE EXAM|
ALREADY GRADED A+
subjects = data entities, objects = descriptions ✔Correct Answer-Conceptual Modeling
Subjects = ?
Objects = ?
Unique identifiers ✔Correct Answer-Conceptual Modeling
unique characteristics that distinguish between objects/subjects of the same type
attributes (describe each subject), alternate keys (describe each object) ✔Correct Answer-
Conceptual Modeling
______________ describe each subject and _____________ describes each object
relationships and cardinalities ✔Correct Answer-Conceptual Modeling
events that occur that imply associations between objects
ERD (Entity-Relationship Diagram) ✔Correct Answer-Conceptual Modeling
identifies the people, places, objects, things, events, or concepts, their characteristics and
relationships, for an organization or business area
metadata ✔Correct Answer-Conceptual Modeling
data that describes the properties of other data
better data quality, reduced program maintenance, improved data sharing ✔Correct Answer-
Conceptual Modeling
What are some of the advantages of database systems?
The logical design ✔Correct Answer-Conceptual Modeling
Where are the detailed technology-dependent specifications of the database design created?
does not have a predefined data structure, providing more flexibility for organizing data ✔Correct
Answer-Conceptual Modeling
What is an advantage of unstructured database processing?
entity ✔Correct Answer-Conceptual Modeling
collection of persons, places, objects, events, or concepts in a table
, Strong entity ✔Correct Answer-Conceptual Modeling
What type of entity is as follows: typical object of interest, exists independently, and has
characteristics of interest
Weak entity ✔Correct Answer-Conceptual Modeling
What type of entity is as follows: cannot exist without a relationship to a strong (parent) entity, and
has an identifier that is derived from the parent entity
Associative Entity ✔Correct Answer-Conceptual Modeling
What is the entity that describes a relationship amongst two entities?
-create when there is a many to many (M:M) relationship
-modeled with a diamond
-convert the verb to a noun, add any relationship attributes, flip cardinalities so that manys are facing
the AE ✔Correct Answer-Conceptual Modeling
What are some characteristics of an associative entity?
Identifier ✔Correct Answer-Conceptual Modeling
an attribute that identities individual instances of an entity type. Represented by an underline, will
always be bold
Required attribute ✔Correct Answer-Conceptual Modeling
an attribute that must be captured for a valid entity instance. Represented by bold
Composite attribute ✔Correct Answer-Conceptual Modeling
an attribute that can be broken down into other attributes/composed of multiple pieces of
information. Represented by (...)
Multivalued attrribute ✔Correct Answer-Conceptual Modeling
an attribute that may have more than one value for the same type of data. Represented by {}
Derived attribute ✔Correct Answer-Conceptual Modeling
an attribute that can be calculated from other available attributable values. Represented by []
Relationship attribute ✔Correct Answer-Conceptual Modeling
an attribute that captures data about the relationship between entities rather than any entity on its
own
Relationship degree
100% VERIFIED ANSWERS|ACTUAL COMPLETE EXAM|
ALREADY GRADED A+
subjects = data entities, objects = descriptions ✔Correct Answer-Conceptual Modeling
Subjects = ?
Objects = ?
Unique identifiers ✔Correct Answer-Conceptual Modeling
unique characteristics that distinguish between objects/subjects of the same type
attributes (describe each subject), alternate keys (describe each object) ✔Correct Answer-
Conceptual Modeling
______________ describe each subject and _____________ describes each object
relationships and cardinalities ✔Correct Answer-Conceptual Modeling
events that occur that imply associations between objects
ERD (Entity-Relationship Diagram) ✔Correct Answer-Conceptual Modeling
identifies the people, places, objects, things, events, or concepts, their characteristics and
relationships, for an organization or business area
metadata ✔Correct Answer-Conceptual Modeling
data that describes the properties of other data
better data quality, reduced program maintenance, improved data sharing ✔Correct Answer-
Conceptual Modeling
What are some of the advantages of database systems?
The logical design ✔Correct Answer-Conceptual Modeling
Where are the detailed technology-dependent specifications of the database design created?
does not have a predefined data structure, providing more flexibility for organizing data ✔Correct
Answer-Conceptual Modeling
What is an advantage of unstructured database processing?
entity ✔Correct Answer-Conceptual Modeling
collection of persons, places, objects, events, or concepts in a table
, Strong entity ✔Correct Answer-Conceptual Modeling
What type of entity is as follows: typical object of interest, exists independently, and has
characteristics of interest
Weak entity ✔Correct Answer-Conceptual Modeling
What type of entity is as follows: cannot exist without a relationship to a strong (parent) entity, and
has an identifier that is derived from the parent entity
Associative Entity ✔Correct Answer-Conceptual Modeling
What is the entity that describes a relationship amongst two entities?
-create when there is a many to many (M:M) relationship
-modeled with a diamond
-convert the verb to a noun, add any relationship attributes, flip cardinalities so that manys are facing
the AE ✔Correct Answer-Conceptual Modeling
What are some characteristics of an associative entity?
Identifier ✔Correct Answer-Conceptual Modeling
an attribute that identities individual instances of an entity type. Represented by an underline, will
always be bold
Required attribute ✔Correct Answer-Conceptual Modeling
an attribute that must be captured for a valid entity instance. Represented by bold
Composite attribute ✔Correct Answer-Conceptual Modeling
an attribute that can be broken down into other attributes/composed of multiple pieces of
information. Represented by (...)
Multivalued attrribute ✔Correct Answer-Conceptual Modeling
an attribute that may have more than one value for the same type of data. Represented by {}
Derived attribute ✔Correct Answer-Conceptual Modeling
an attribute that can be calculated from other available attributable values. Represented by []
Relationship attribute ✔Correct Answer-Conceptual Modeling
an attribute that captures data about the relationship between entities rather than any entity on its
own
Relationship degree
