ISM 4212 FINAL EXAM STUDY GUIDE 2026
COMPLETE QUESTIONS WITH CORRECT
DETAILED ANSWERS ||
100% GUARANTEED PASS
<RECENT VERSION>
1. Database Management Systems - ANSWER ✔ Software system that helps
the process of defining, creating, using and maintaining databases.
2. Databases - ANSWER ✔ An organized collection of logically related data.
3. Metadata - ANSWER ✔ Data that describes data.
4. Queries - ANSWER ✔ Databanks that allow the retrieval of data,
manipulation of data, or the deletion of data.
5. Data Modeling - ANSWER ✔ A design technique for capturing reality
6. Conceptual Data Modeling - ANSWER ✔ Uses an ERD to understanding of
the principal data source
7. ERD - ANSWER ✔ Entity- Relationship Diagram
8. Logical Data Modeling - ANSWER ✔ Uses a relational schema. convert a
model into a form that can be utilized in a relationship database/
,9. Physical Data Modeling - ANSWER ✔ Data Dictionary
10.Entity - ANSWER ✔ Something of interest in the environment. (It can be a
person place object event concept.) That will have numerous
instances(occurrences)
11.Instances - ANSWER ✔ One occurrence of an entity.
12.Attribute - ANSWER ✔ A data element used to describe an entity.
13.Data - ANSWER ✔ Stored representations of meaningful objects and events
Facts and Figures
14.Structured Data - ANSWER ✔ Numbers, text, dates
15.Unstructured Data - ANSWER ✔ Images, video, documents
16.Information - ANSWER ✔ Data processed to increase knowledge in the user
Data in context
17.Knowledge - ANSWER ✔ Information put into action
, What we know
18.Declarative (what we know), Procedural (how to do something), Tacit
(difficult to transfer to another person), Explicit (readily articulated,
codified, accessed and verbalized)
19.relational database management system - ANSWER ✔ A DBMS that
manages data as a collection of tables in which all relationships are
represented by common values in related tables
¤
20.a relational database management system (DBMS) is a software package
that manages the connection between the database and the schema -
ANSWER ✔ false
21.the CREATE TABLE SQL statement defines a new table and its columns -
ANSWER ✔ true
22.the ALTER TABLE statement allows you to change column specifications -
ANSWER ✔ true
23.a constraint that states that the foreign key values of a table must match the
primary key values of a related table is called: - ANSWER ✔ referential
integrity
24.in SQL, the UPDATE statement modifies data in an existing row or rows -
ANSWER ✔ true
, 25.In SQL a ________ allows a question to be asked of the database and returns
an answer - ANSWER ✔ query
26.A functional dependency in which one or more nonkey attributes are
functionally dependent on part, but not all, of the primary key is called a
________ dependency - ANSWER ✔ partial functional
27.A relation that contains no multi-valued attributes and has nonkey attributes
solely dependent on the primary key but contains transitive dependencies is
in which normal form? - ANSWER ✔ 2nd normal form
28.A two dimensional table is called a: - ANSWER ✔ relation
29.A two tier database includes: - ANSWER ✔ the database server tier and the
client/user tier
30.Common database development approaches include: - ANSWER ✔ SDLC
(Systems Development Life Cycle), Prototyping and Agile
31.GPA, major, and class standing are _________ of the STUDENT entity -
ANSWER ✔ attributes
32.Which of the following are purposes of a database management system
(DBMS)? - ANSWER ✔ storing data, creating data, and updating data
33.__________are established between entities in a database so that
information can be retrieved. - ANSWER ✔ relationships
COMPLETE QUESTIONS WITH CORRECT
DETAILED ANSWERS ||
100% GUARANTEED PASS
<RECENT VERSION>
1. Database Management Systems - ANSWER ✔ Software system that helps
the process of defining, creating, using and maintaining databases.
2. Databases - ANSWER ✔ An organized collection of logically related data.
3. Metadata - ANSWER ✔ Data that describes data.
4. Queries - ANSWER ✔ Databanks that allow the retrieval of data,
manipulation of data, or the deletion of data.
5. Data Modeling - ANSWER ✔ A design technique for capturing reality
6. Conceptual Data Modeling - ANSWER ✔ Uses an ERD to understanding of
the principal data source
7. ERD - ANSWER ✔ Entity- Relationship Diagram
8. Logical Data Modeling - ANSWER ✔ Uses a relational schema. convert a
model into a form that can be utilized in a relationship database/
,9. Physical Data Modeling - ANSWER ✔ Data Dictionary
10.Entity - ANSWER ✔ Something of interest in the environment. (It can be a
person place object event concept.) That will have numerous
instances(occurrences)
11.Instances - ANSWER ✔ One occurrence of an entity.
12.Attribute - ANSWER ✔ A data element used to describe an entity.
13.Data - ANSWER ✔ Stored representations of meaningful objects and events
Facts and Figures
14.Structured Data - ANSWER ✔ Numbers, text, dates
15.Unstructured Data - ANSWER ✔ Images, video, documents
16.Information - ANSWER ✔ Data processed to increase knowledge in the user
Data in context
17.Knowledge - ANSWER ✔ Information put into action
, What we know
18.Declarative (what we know), Procedural (how to do something), Tacit
(difficult to transfer to another person), Explicit (readily articulated,
codified, accessed and verbalized)
19.relational database management system - ANSWER ✔ A DBMS that
manages data as a collection of tables in which all relationships are
represented by common values in related tables
¤
20.a relational database management system (DBMS) is a software package
that manages the connection between the database and the schema -
ANSWER ✔ false
21.the CREATE TABLE SQL statement defines a new table and its columns -
ANSWER ✔ true
22.the ALTER TABLE statement allows you to change column specifications -
ANSWER ✔ true
23.a constraint that states that the foreign key values of a table must match the
primary key values of a related table is called: - ANSWER ✔ referential
integrity
24.in SQL, the UPDATE statement modifies data in an existing row or rows -
ANSWER ✔ true
, 25.In SQL a ________ allows a question to be asked of the database and returns
an answer - ANSWER ✔ query
26.A functional dependency in which one or more nonkey attributes are
functionally dependent on part, but not all, of the primary key is called a
________ dependency - ANSWER ✔ partial functional
27.A relation that contains no multi-valued attributes and has nonkey attributes
solely dependent on the primary key but contains transitive dependencies is
in which normal form? - ANSWER ✔ 2nd normal form
28.A two dimensional table is called a: - ANSWER ✔ relation
29.A two tier database includes: - ANSWER ✔ the database server tier and the
client/user tier
30.Common database development approaches include: - ANSWER ✔ SDLC
(Systems Development Life Cycle), Prototyping and Agile
31.GPA, major, and class standing are _________ of the STUDENT entity -
ANSWER ✔ attributes
32.Which of the following are purposes of a database management system
(DBMS)? - ANSWER ✔ storing data, creating data, and updating data
33.__________are established between entities in a database so that
information can be retrieved. - ANSWER ✔ relationships
