Exam 2: Database Concepts and Applications in Human Resource Information Systems
Which of the following is NOT a shortcoming of early file-oriented database structures?
D
Relational database data is stored in tables where each table represents one 'entity' in the real world and the information associated with that 'entity' is stored only in that table.Tables are related to each other through a common attribute or key.
True
What are the implications for databases and information sharing in today's global environment?
In today's global environment, access to data from any physical location in the world is increasingly important.Computer networks are created that provide instant access to these operational data, allowing real-time managerial decision capability regardless of physical location. A centralized database allows a company to confine its data to a single location and, therefore, more easily control data integrity, updating, backup, query, and control access to the database.A company with many locations and telecommuters, however, must develop a communications infrastructure to facilitate data sharing over a wide geographical area.The advent of the Internet and a standardized communication protocol made the centralized database structures and geographically dispersed data sharing feasible.
_________________ is a broad category of business applications and technologies for creating data warehouses and for analyzing and providing access to these specialized data to help enterprise users make better business decisions.
A foreign key represents the primary key from another table that is stored as an attribute in another table.
The advent of the Internet and a standardized communication protocol have contributed to:
A ________ allows you to ask a question based on one or more tables in a database.
One of the benefits of a relational database systems is that:
MS Access would be appropriate for an organization that had a small database and limited knowledge of database programming.
Compare the typical users of an action query with those of a cross-tab query.
What are some examples how an organization might use the data sharing ability of a relational database system?
Functional units, management levels, and geographically dispersed locations may all have the need to:
Provide some examples of actions that might be performed as a result of an action query.
One of the benefits of a relational database systems is that end users who generally had limited programming experience can still utilize the query functionality.
The database design process begins with determining what the users want.
Transaction processing systems are business applications that focus on processing operational data.
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)