73- Business intelligence (BI) is focused upon helping your organization use its own data to reach its _______________.
74-Thomas Friedman says all but one of these statements in his video “The World is Flat.”
a. Whatever can be done will be done.
b. Whatever can be done will be done by you or to you.
c. Don’t wait – because (if you do) it will be done to you.
d. All of the above are said by Friedman
75- An example of data redundancy is:
a. Disconnected or “orphaned” relational tables.
b. Too much unnecessary data collected in the relational tables.
c. Having a customer’s phone number in several separate tables.
d. None of the above
76- Which of the following sentence(s) is true of relational databases?
a. If you think of a relational database as looking like an Excel spreadsheet, the “rows” that run vertically are known as “attributes.”
b. If you think of a relational database as looking like an Excel spreadsheet, the “columns” that run vertically are known as “entities.”
c. A subordinate database is one that is related to a primary database.
d. Only A and B are true.
e. None of the above is true.
77- Software that seeks long term profitability and sustainability with your customers and helps your staff to close deals faster is a characteristic of what software?
a. Enterprise resource planning software
b. Customer relationship management software
c. Supply chain management software
d. All of the above
e. None of the above
78- Which of the following are Information Technology jobs, as we learned from an outside reading?
a. Software engineers
b. Business analysts
c. Software testers
d. Web Developers
e. All of the above
f. Only A, B and D
79 -From an outside video we learned that Key Performance Indicators (KPI) comprise (make up) the “scorecard” part of your balanced scorecard.
80- When establishing a primary key for a database, we need to remember that:
a. The primary key must be a unique piece of data.
b. The primary key in one file may be a foreign key in another file.
c. We access data records in the file by retrieving them directly using the primary key.
d. All of the above
81- The ETL process prepares database data for a data warehouse. The initials ETL stand for Answer—————-. (Hint 3 words – please do not capitalize them)
82- Answer———————— systems are computer program applications that analyze business data and present it so that users can make business decisions more easily; it is often used by the end user himself.
(Hint 2 words)
83- A(n) Answer ———– can be defined as a temporary endeavor undertaken to create a unique product or service at a defined cost.
84- A Answer ———–is a group of related files or tables that are organized so that they appear to be in a central location and accessible by various departments or programs.
85- A Answer————– is the individual who oversees the entire effort of a project and has the responsibility for bringing it in on time, within budget, and to specifications. (Hint: 2 words)
86- As we discussed in week 5, this common Microsoft software product can help analyze large amounts of data: Answer.————
87- A Answer——— is a collection of data selected from all that is gathered by the organization, cleaned up and stored in a special area where it does not compete with the transactional (aka operational) systems. (Hint: two words – don’t capitalize them)
88- Decision support systems are a subset/form of Answer———- (hint 2 words).
89- In an organization, this leadership position focuses on current IT needs and strategies: Answer __________ __________ (hint: 3 words, but do not capitalize please.)
90- Baltzan (2015) identifies two types of information your textbook. Answer—————- information is that which has been copied to special databases called a data warehouse where it can be analyzed without affecting the operations or performance of the organization.