COMPREHENSIVE QUESTIONS AND
SOLUTIONS GRADED A+
◉ information. Answer: Processed data that possesses context,
relevance, and meaning to users.
◉ knowledge. Answer: Information that facilitates action
◉ Database. Answer: a collection of organized data that allows
access, retrieval, and use of data
◉ Database Technology. Answer: It provides organizations with data
integration, data sharing, reporting flexibility, minimal data
redundancy and data inconsistencies, data independence, central
management of data, cross-functional analysis.
◉ Data Resource Management. Answer: a managerial activity that
applies information systems technology and management tools to
manage the company's data resources
,◉ data warehouse. Answer: A logical collection of information -
gathered from many different operational databases - that supports
business analysis activities and decision-making tasks
◉ data mining. Answer: the process of analyzing data to extract
information not offered by the raw data alone
◉ explicit knowledge. Answer: knowledge that is easily
communicated and available to everyone... expressed in words or
numbers.
◉ tacit knowledge. Answer: Knowledge contained in people's heads.
Insights and intuitions.
◉ wisdom. Answer: The combination of knowledge and experience.
◉ Big Data. Answer: a broad term for datasets so large or complex
that traditional data processing applications are inadequate.
◉ Common defects in data resource management. Answer: 1. No
control of redundant data
2. Violation of data integrity
3. Relying on human memory to store and search the dataset
, ◉ relational database model. Answer: data model based on the
simple concept of tables in order to capitalize on characteristics of
rows and columns of data
◉ Primary Key. Answer: a field that uniquely identifies a record in a
table
◉ Foreign Key. Answer: A primary key of one table that appears as
an attribute in another table and acts to provide a logical
relationship between the two tables
◉ Normalization (database). Answer: Design it in a way that:
1. Reduces data redundancy
2. Ensures data integrity
◉ Boolean. Answer: a data type with two possible value
representing true and false, 0 and 1, etc.
◉ currency. Answer: Special form of number data that formats all
values with a currency indicator.
◉ paragraph text. Answer: Text longer than 256 characters