22 Questions
Database management involves the proper generation, storage, and retrieval of ______.
data
A ______ is a shared, integrated computer structure that stores a collection of data.
database
File systems store data as a collection of ______.
files
[Blank] is the result of processing raw data to reveal its meaning.
information
Data-modeling skills are vital in the data design process because good data modeling facilitates communication between the ______, user, and the developer
designer
Most users lack the skill to properly design ______, despite multiple personal productivity tools being available
databases
The ______ is the intermediary between the user and the database.
DBMS
DBMS enables data to be shared among multiple ______ or applications.
users
Database Systems Database system consists of logically related data stored in a single logical ______ repository
data
Data ______ occurs when different versions of the same data appear in different places.
inconsistency
Data designs created by end users are rarely ______ and never with appropriate standardized data –modeling technique
documented
Improved data ______ is one of the advantages of a DBMS.
security
Using databases changed the way end users store, access and manage data using ______
DBMS
A ______ database supports multiple users at the same time.
multiuser
People naturally have an integrated view of data and forcing this into single 2-dimensional structure is poor ______ design
data
A ______ database stores data used for tactical or strategic decisions.
data warehouse
Changing existing ______ is difficult in file system environments.
structure
[Blank] dependence occurs when data access changes when data storage characteristics change.
Data
In a file system, ______ redundancy occurs when the same data is stored unnecessarily in different places.
Data
Uncontrolled ______ redundancy can lead to poor data security and data inconsistency.
Data
Data ______ occurs when not all changes in redundant data are made correctly.
anomalies
[Blank] independence means data storage characteristics do not affect data access.
Data
Test your knowledge on common issues in data modeling, including insertion and deletion anomalies, poor design, and the importance of data-modeling skills. Learn how to overcome these challenges and create effective database designs.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free