ITM 111 Study Guide exam with correct |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
answers
Data - correct answer✔✔The bits and pieces, like numbers, characters or symbols with no
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
relevance.
Information - correct answer✔✔A set of data with relevance. At a certain place in time, or for |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
a certain person, the data makes sense.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Knowledge - correct answer✔✔Information that has been acquired and gives understanding |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
about the importance of the information. Used to make decisions.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Decision-making - correct answer✔✔Acting on the knowledge obtained, to achieve some |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
benefit.
Entity - correct answer✔✔A person, place, thing or concept about which data can be
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
collected.
Attribute - correct answer✔✔Describes the facts, details or characteristics of an entity.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Query - correct answer✔✔A request for data or information. Asking a question from the data.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Sort - correct answer✔✔Arrange data or information in a specific way to make it more useful.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Such as alphabetizing from A to Z.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Filter - correct answer✔✔Hiding or filtering out unwanted data or information so only the
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
information you want to see is displayed. |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
,Statement of Work (SOW) - correct answer✔✔A document used to plan a successful execution |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
of a project or system. Used in planning for data systems such as databases.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Data Integrity - correct answer✔✔Ensuring the accuracy and reliability of data, making sure it
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
remains intact. It can be maintained by standards implemented during the design phase |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Data Consistency - correct answer✔✔The usability of data, or having only valid data written to
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
the database. All values in a single attribute of an entity should be of the same data type.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Data Redundancy - correct answer✔✔The repetition of data where the same data value is
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
stored in more than one place in the database. This wastes space and necessitates multiple
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
changes in different places when editing the value. |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Entity Data Storage - correct answer✔✔A single thing, person, place, or object; usually
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
represented as a single row in data storage. Also referred to as a record. |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Attribute Data Storage - correct answer✔✔A value that describes a characteristics of the |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
entity. A set of these related values for many entities are represented as a column in data
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
storage. Also referred to as a field. |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Filtering - correct answer✔✔If you had a class list but only needed to see those students from
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
the list majoring in Data Science, you could hide all unwanted information to display only the
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
students you needed. This is called ______________. |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
If the data for a product price is entered as text instead of a number, what is being violated? -
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
correct answer✔✔Data consistency |||\\\ |||\\\ |||\\\
Sort - correct answer✔✔This term means to arrange a list of numbers in a way so that the
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
smallest numbers are first and the largest numbers are last. Here is an example: 3,6,10,22,24. |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
, What should one column of a database table contain? - correct answer✔✔A set of values
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
belonging to an attribute of the entity |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
If you had unreliable data that let a user register a student for a class that isn't offered that
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
semester, this would be violating ______________. - correct answer✔✔Data integrity
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
When a student's last name changes and the last name value has to be changed in multiple
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
locations in the system, this is an example of ______________. - correct answer✔✔Data
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
redundancy
According to our reading, rather than just making decisions based on intuition or observations
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
alone, organizations should use ______________ to make ______________-driven decisions.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
(Same word is used in both blanks.) - correct answer✔✔Data
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
What might be a part of a Statement of Work, according to our reading? - correct
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
answer✔✔All of the above |||\\\ |||\\\ |||\\\
A starting point of creating a data-driven system or project
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Beginning steps to a successful execution of a project or system |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
The purpose of a project and how long it might take to complete
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Requirements and expectations of the project |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
What should each row of a database table contain? - correct answer✔✔Only one entity (or
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
instance of an entity) |||\\\ |||\\\ |||\\\
answers
Data - correct answer✔✔The bits and pieces, like numbers, characters or symbols with no
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
relevance.
Information - correct answer✔✔A set of data with relevance. At a certain place in time, or for |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
a certain person, the data makes sense.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Knowledge - correct answer✔✔Information that has been acquired and gives understanding |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
about the importance of the information. Used to make decisions.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Decision-making - correct answer✔✔Acting on the knowledge obtained, to achieve some |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
benefit.
Entity - correct answer✔✔A person, place, thing or concept about which data can be
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
collected.
Attribute - correct answer✔✔Describes the facts, details or characteristics of an entity.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Query - correct answer✔✔A request for data or information. Asking a question from the data.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Sort - correct answer✔✔Arrange data or information in a specific way to make it more useful.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Such as alphabetizing from A to Z.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Filter - correct answer✔✔Hiding or filtering out unwanted data or information so only the
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
information you want to see is displayed. |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
,Statement of Work (SOW) - correct answer✔✔A document used to plan a successful execution |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
of a project or system. Used in planning for data systems such as databases.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Data Integrity - correct answer✔✔Ensuring the accuracy and reliability of data, making sure it
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
remains intact. It can be maintained by standards implemented during the design phase |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Data Consistency - correct answer✔✔The usability of data, or having only valid data written to
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
the database. All values in a single attribute of an entity should be of the same data type.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Data Redundancy - correct answer✔✔The repetition of data where the same data value is
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
stored in more than one place in the database. This wastes space and necessitates multiple
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
changes in different places when editing the value. |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Entity Data Storage - correct answer✔✔A single thing, person, place, or object; usually
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
represented as a single row in data storage. Also referred to as a record. |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Attribute Data Storage - correct answer✔✔A value that describes a characteristics of the |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
entity. A set of these related values for many entities are represented as a column in data
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
storage. Also referred to as a field. |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Filtering - correct answer✔✔If you had a class list but only needed to see those students from
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
the list majoring in Data Science, you could hide all unwanted information to display only the
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
students you needed. This is called ______________. |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
If the data for a product price is entered as text instead of a number, what is being violated? -
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
correct answer✔✔Data consistency |||\\\ |||\\\ |||\\\
Sort - correct answer✔✔This term means to arrange a list of numbers in a way so that the
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
smallest numbers are first and the largest numbers are last. Here is an example: 3,6,10,22,24. |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
, What should one column of a database table contain? - correct answer✔✔A set of values
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
belonging to an attribute of the entity |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
If you had unreliable data that let a user register a student for a class that isn't offered that
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
semester, this would be violating ______________. - correct answer✔✔Data integrity
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
When a student's last name changes and the last name value has to be changed in multiple
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
locations in the system, this is an example of ______________. - correct answer✔✔Data
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
redundancy
According to our reading, rather than just making decisions based on intuition or observations
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
alone, organizations should use ______________ to make ______________-driven decisions.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
(Same word is used in both blanks.) - correct answer✔✔Data
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
What might be a part of a Statement of Work, according to our reading? - correct
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
answer✔✔All of the above |||\\\ |||\\\ |||\\\
A starting point of creating a data-driven system or project
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Beginning steps to a successful execution of a project or system |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
The purpose of a project and how long it might take to complete
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Requirements and expectations of the project |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
What should each row of a database table contain? - correct answer✔✔Only one entity (or
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
instance of an entity) |||\\\ |||\\\ |||\\\
