ISM 4212 MIDTERM VERIFIED STUDY GUIDE
Database Management Systems - Answers - Software system that helps the process
of defining, creating, using and maintaining databases.
Databases - Answers - An organized collection of logically related data.
Metadata - Answers - Data that describes data.
Queries - Answers - Databanks that allow the retrieval of data, manipulation of data, or
the deletion of data.
Data Modeling - Answers - A design technique for capturing reality
Conceptual Data Modeling - Answers - Uses an ERD to understanding of the principal
data source
ERD - Answers - Entity- Relationship Diagram
Logical Data Modeling - Answers - Uses a relational schema. convert a model into a
form that can be utilized in a relationship database/
Physical Data Modeling - Answers - Data Dictionary
Entity - Answers - Something of interest in the environment. (It can be a person place
object event concept.) That will have numerous instances(occurrences)
Instances - Answers - One occurrence of an entity.
Attribute - Answers - A data element used to describe an entity.
Attribute types - Answers - Simple, Composite, Single valued, multivalued, derived,
identifier.
Attribute type:Single - Answers - Basic attribute singular
Attribute type:Composite - Answers - A group of related attributes.( address)
Attribute type: Single Valued - Answers - Only one value per entity instance. (last
name, Date of Birth)
Database Management Systems - Answers - Software system that helps the process
of defining, creating, using and maintaining databases.
Databases - Answers - An organized collection of logically related data.
Metadata - Answers - Data that describes data.
Queries - Answers - Databanks that allow the retrieval of data, manipulation of data, or
the deletion of data.
Data Modeling - Answers - A design technique for capturing reality
Conceptual Data Modeling - Answers - Uses an ERD to understanding of the principal
data source
ERD - Answers - Entity- Relationship Diagram
Logical Data Modeling - Answers - Uses a relational schema. convert a model into a
form that can be utilized in a relationship database/
Physical Data Modeling - Answers - Data Dictionary
Entity - Answers - Something of interest in the environment. (It can be a person place
object event concept.) That will have numerous instances(occurrences)
Instances - Answers - One occurrence of an entity.
Attribute - Answers - A data element used to describe an entity.
Attribute types - Answers - Simple, Composite, Single valued, multivalued, derived,
identifier.
Attribute type:Single - Answers - Basic attribute singular
Attribute type:Composite - Answers - A group of related attributes.( address)
Attribute type: Single Valued - Answers - Only one value per entity instance. (last
name, Date of Birth)
