K201 Lecture – Flashcards
Unlock all answers in this set
Unlock answersquestion
People because they are in every information system used
answer
According to your textbook, in the five-component framework of an information system, which is the most important?
question
Hardware Software Data Procedures People
answer
Each Information System is comprised of five components. .
question
False
answer
The number of components in the Five Component Model increases in proportion to an Information System's complexity and/or size.
question
Data
answer
A graph represents...
question
False
answer
In order for data to be considered timely it must be delivered in real time.
question
False
answer
Good data are always worth the cost, no matter how expensive
question
a relational database
answer
Keeping track of data involving multiple themes such as employees, transactions, customers, supplies, etc. should be done with which of the following?
question
Metadata
answer
The data displayed in Design View of a table in an Access database is an example of
question
False A Database is not just a group of tables, it also includes relationships among the rows in those tables and metadata
answer
A database is simply a group of tables or files.
question
column
answer
Field is referred to as
question
characters
answer
Bytes is referred to as
question
File
answer
Table is referred to as
question
Row
answer
Records is referred to as
question
Three
answer
How many primary functions does a database management system (DBMS) have?
question
SQL
answer
Which of the following is an international standard language for processing a database?
question
False The lost-update problem is actually caused by multi-user database processing. Some type of locking must be used to coordinate activities among the multiple users.
answer
The lost-update problem can be resolved by implementing multi-user database processing.
question
Personal DBMS
answer
Microsoft Access belongs to which of the following DBMS categories?
question
Data Model
answer
describes the data and relationships that will be stored in a database.
question
False A normalized table should contain data with one and only one theme.
answer
A table containing normalized data should have 3 or fewer themes.
question
Determine Requirements
answer
Which phase of the SDLC is the most important phase?
question
Form the project team
answer
If a defined project is determined to be feasible in the SDLC, the immediate next step is to
question
diseconomies of scale
answer
The situation that occurs when adding more resources creates inefficiencies is known as
question
Business Intelligence (BI) Systems
answer
Information systems that process operational, social, and other data to identify patterns, trends, and relationships for use by business professionals are known as
question
business intelligence
answer
The patterns, trends, and relationships produced by these information systems are referred to as
question
False This is an example of push publishing because the report is executed automatically as a result of an event.
answer
An inventory report set to run automatically when an item reaches a critical low point is an example of pull publishing.
question
Acquire Data
answer
Which of the following is the first primary activity in the BI process?
question
False No matter how advanced a system is, the only safeguard against inaccurate analyses from inconsistent data is for the analyst and knowledge worker to realize inconsistencies are a common occurrence and to be on the lookout.
answer
One of the main benefits of BI Analysis is that there are no discrepancies in the data acquired from multiple sources.
question
Purchased data often contains missing elements.
answer
Which of the following statements is true about operational and purchased data?
question
True
answer
Operational data is structured for fast and reliable transaction processing
question
Data Mart
answer
a data collection that addresses a particular department or functional area of the business.
question
False
answer
Data mart is another term used for a data warehouse
question
Data Warehouse
answer
Takes data from the data manufacturers, cleans and processes the data, and then stores it.
