INMT 342 Final Exam Questions with
Solutions UTK
subjects = data entities, objects = descriptions - Answer-Conceptual Modeling
Subjects = ?
Objects = ?
Unique identifiers - Answer-Conceptual Modeling
unique characteristics that distinguish between objects/subjects of the same type
attributes (describe each subject), alternate keys (describe each object) - Answer-Conceptual Modeling
______________ describe each subject and _____________ describes each object
relationships and cardinalities - Answer-Conceptual Modeling
events that occur that imply associations between objects
, ERD (Entity-Relationship Diagram) - Answer-Conceptual Modeling
identifies the people, places, objects, things, events, or concepts, their characteristics and relationships,
for an organization or business area
metadata - Answer-Conceptual Modeling
data that describes the properties of other data
better data quality, reduced program maintenance, improved data sharing - Answer-Conceptual
Modeling
What are some of the advantages of database systems?
The logical design - 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 - Answer-
Conceptual Modeling
What is an advantage of unstructured database processing?
entity - Answer-Conceptual Modeling
collection of persons, places, objects, events, or concepts in a table
Solutions UTK
subjects = data entities, objects = descriptions - Answer-Conceptual Modeling
Subjects = ?
Objects = ?
Unique identifiers - Answer-Conceptual Modeling
unique characteristics that distinguish between objects/subjects of the same type
attributes (describe each subject), alternate keys (describe each object) - Answer-Conceptual Modeling
______________ describe each subject and _____________ describes each object
relationships and cardinalities - Answer-Conceptual Modeling
events that occur that imply associations between objects
, ERD (Entity-Relationship Diagram) - Answer-Conceptual Modeling
identifies the people, places, objects, things, events, or concepts, their characteristics and relationships,
for an organization or business area
metadata - Answer-Conceptual Modeling
data that describes the properties of other data
better data quality, reduced program maintenance, improved data sharing - Answer-Conceptual
Modeling
What are some of the advantages of database systems?
The logical design - 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 - Answer-
Conceptual Modeling
What is an advantage of unstructured database processing?
entity - Answer-Conceptual Modeling
collection of persons, places, objects, events, or concepts in a table
