Week 3 : Managing Assets and Resources in the Digital Firm - Homework
|1. A characteristic or quality describing an entity is called a(n) (Points : 1) |
|2. The confusion created by _____ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources. (Points : 1) |
|3. Duplicate data in multiple data files is called (Points : 1) |
|4. A DBMS (Points : 1) |
makes the physical database available for different logical views.
makes the logical database available for different analytical views.
makes the physical database available for different analytical views.
makes the relational database available for different analytical views.
|5. The logical view (Points : 1) |
shows how data are organized and structured on the storage media.
presents an entry screen to the user.
allows the creation of supplementary reports.
presents data as they would be perceived by end users.
|6. The type of logical database model that treats data as if they were stored in two-dimensional tables is the (Points : 1) |
|7. A field identified in a table as holding the unique identifier of the table's records is called the (Points : 1) |
|8. The data dictionary serves as an important data management tool by (Points : 1) |
assigning attributes to the data.
creating an inventory of data contained in the database.
presenting data as end users or business specialists would perceive them.
maintaining data in updated form.
|9. An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the (Points : 1) |
data definition diagram.
|10. Which is the type of database management approach that can handle a large number of pages or documents? (Points : 1) |
|11. Which is the most prominent data manipulation language today? (Points : 1) |
|12. DBMSs typically include report-generating tools in order to (Points : 1) |
retrieve and display data.
display data in an easier-to-read format.
display data in graphs.
perform predictive analysis.
|13. A schematic of the entire database that describes the relationships in a database is called (Points : 1) |
the data dictionary.
the intersection relationship diagram.
the entity-relationship diagram.
the data definition diagram.
|14. What is the process of streamlining data to minimize redundancy and awkward many-to-many relationships? (Points : 1) |
|15. Cloud computing offers (Points : 1) |
no database functions.
some database functions.
products only from Amazon and Microsoft.
None of the above
|16. A data warehouse is composed of (Points : 1) |
historical data from legacy systems.
internal and external data sources.
historic and current internal data.
|17. A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because (Points : 1) |
a data mart typically focuses on a single subject area or line of business.
all the information is historical.
a data mart requires a Web interface.
all of the information belongs to a single company.
|18. Data mining is a tool that allows users to (Points : 1) |
quickly compare transaction data gathered over many years.
find hidden relationships in data.
obtain online answers to ad hoc questions in a rapid amount of time.
summarize massive amounts of data into much smaller, traditional reports.
|19. What is the tool that enables users to view the same data in different ways using multiple dimensions? (Points : 1) |
|20. OLAP is a tool that enables (Points : 1) |
users to obtain online answers to ad hoc questions in a short amount of time.
users to view both logical and physical views of data.
programmers to quickly diagram data relationships.
programmers to normalize data.