CIS2700 Ch 6 ; 7 – Flashcards
Unlock all answers in this set
Unlock answersquestion
What are the different types of information?
answer
levels, formats, granularities
question
Which of the following represents the different information levels?
answer
individual, department, enterprise
question
Which of the following represents the different information formats?
answer
document, presentation, spreadsheet, database
question
Which of the following represents the different information granularities?
answer
detail, summary, aggregate
question
All of the following are characteristics of information, except:
answer
Quantity
question
What encompasses all of the information contained within a single business process or unit of work and it's primary purpose is to support the performance of daily operational tasks?
answer
Transactional information
question
Which of the following is an example of transactional information?
answer
Withdrawing cash from an ATM, making an airline reservation, purchasing stock, trends, and sales projections.
question
What encompasses all organizational information and its primary purpose is to support the performance of managerial analysis tasks?
answer
Analytical information
question
What is immediate, up-to-date information?
answer
Real-time information
question
What provides real-time information in response to requests?
answer
Real-time systems
question
What is one of the biggest pitfalls associated with real-time information?
answer
It continually changes
question
Which of the following is not one of the five characteristics common to high quality information?
answer
Quantity
question
Which of the following implies that aggregate or summary information is in agreement with detailed information?
answer
Consistency
question
Which of the following implies that information is current with respect to the business requirement?
answer
Timeliness
question
Which of the following types can be found in a database?
answer
Inventory, Transactions, Employees- All of these
question
In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?
answer
Entity
question
In the relational database model, what is a characteristic or property of an entity?
answer
Attribute
question
What are characteristics or properties of an entity called?
answer
Attributes, Fields, Columns- All of these
question
Why do relational databases use primary and foreign keys?
answer
To create logical relationships
question
What is a primary key?
answer
A field (or group of fields) that uniquely identifies a given record in a table.
question
What is a 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
question
All of the following are advantages of database-stored information except:
answer
Increased information redundancy
question
Which of the following is incorrect in reference to a database?
answer
Information is accessed by physical structure
question
What is the physical view of information?
answer
Deals with physical storage of information on a storage device such as a hard disk.
question
Which of the following is correct in reference to a database?
answer
A database can support many logical views
question
What refers to how well a system can adapt to increased demands?
answer
Scalability
question
Which of the following measures how quickly a system performs a certain process or transaction?
answer
Performance
question
What is information redundancy?
answer
Duplication of information, Storing the same information in multiple places, Storing duplicate information in multiple places- All of these.
question
What is the primary problem with redundant information?
answer
It is difficult to determine which values are the most current It is often inconsistent It is difficult to determine which values are the most accurate All of these
question
Which of the following is true in regard to eliminating redundant information?
answer
Improves information quality
question
What are the rules the help ensure the quality of information?
answer
Integrity constraints
question
What is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database?
answer
Data-driven website
question
What type of website is best to build for a general informational website with static information?
answer
Static website
question
What type of website is best to build for a continually changing information, including press releases, new product information, and updated pricing?
answer
Data-driven website
question
Which of the following is not an advantage of building a data-driven website?
answer
Minimizes or reduces efficiency
question
What is forward integration?
answer
Takes information entered into a given system and sends it automatically to all downstream systems and processes
question
What is backward integration?
answer
Takes information entered into a given system and sends it automatically to all upstream systems and processes
question
What is an integration?
answer
Allows separate systems to communicate directly with each other
