Leson 1 Flashcards
(32 cards)
Is a shared, integrated computer structure that houses a collection of the end-user data and metadata
Database
Is a systematic collection of data which support electronic storage and manipulation of data.
Database
Is a collection of programs that manages the database structure and controls access to the data stored in the database.
Database Management System
Serves as the intermediary between the user and the database.
DBMS
Advantages of DBMS
Improved _______ sharing
Improved _______ security
Better data _______
Minimized data _______
Improved data _______
Improved decision _______
Increased end-user _______
Advantages of DBMS
Improved data sharing
Improved data security
Better data integration
Minimized data inconsistency
Improved data access
Improved decision making
Increased end-user productivity
A type of database that supports only one user at a time. In other words, if user A is using the database, users B and C must wait until user A is done.
Single-user Database
A single-user database that runs on a personal computer is called a
Desktop Database
A type of database that supports multiple users at the same time.
Multiuser Database
– A type of database that supports a relatively small number (usually fewer than 50) of users or a specific department within an organization.
Workgroup Database
A type of database that is used by the entire organization and supports many user (more than 50, usually hundreds) across many departments.
Enterprise Database
A type of database that supports data located at a single site
Centralized Database
A type of database that supports data distributed across several different sites.
Distributed Database
A database that is created and maintained using cloud services, such as Microsoft Azure or Amazon AWS.
Cloud Database
A database that contains a wide variety of data used in multiple disciplines.
General-purpose Database
A type of database that contains data focused on specific subject area.
Discipline-specific Database
A type of database designed primarily to support a company’s day-to-day operations.
Operational Database
A type of database focused primarily on storing historical data and business metrics used for tactical or strategic decision making.
Analytical Database
refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data. A database that meets all user requirements does not just happen; its structure must be designed carefully.
Database Design
Problems associated with File Systems:
Lengthy _______ times
Difficulty of getting quick _______
Complex system _______
Lack of _______ and limited _______ sharing
Extensive _______
Problems associated with File Systems:
Lengthy development times
Difficulty of getting quick answers
Complex system administration
Lack of security and limited data sharing
Extensive programming
– is a data abnormality in which inconsistent changes have been made to a database. It develops when not all the required changes in the redundant data are made successfully.
Data Anomalies
File System Data Processing Issue
Structural ___________
Structural ____________
_______ Dependence
_______ Independence
Data ____________
Data _________
File System Data Processing Issue
Structural Dependence
Structural Independence
Data Dependence
Data Independence
Data Redundancy
Data Anomalies
Uncontrolled data redundancy sets the stage for the following:
Poor data _______
Data _______
Data-entry _______
Data _______ problems
Uncontrolled data redundancy sets the stage for the following:
Poor data security
Data inconsistency
Data-entry errors
Data integrity problems
A data characteristic in which a change in the database schema affects data access, thus requiring changes in all access programs.
Structural Dependence
A data characteristic in which changes in the database schema do not affect data access.
Structural Independence