FUNDAMENTALS OF DATABASE SYSTEM

The result of processing raw data to reveal its meaning.

• Data

• Database

• End-user data

• Information

A collection of programs that manages the database structure and controls access to the data stored in the database.

• Database Management System (DBMS)

• Database Design

• Multiuser database

• Data Warehouse Database

A type of database that supports only one user at a time.

Which File System Data Processing Issue problem with the file system approach is that even the simplest data-retrieval task requires extensive programming.

• Difficulty of getting quick answers

• Lengthy development times

• Complex system administration

• Lack of security and limited data sharing

A data characteristic in which a change in the database schema affects data access, thus requiring changes in all access programs.

• Data independence

• Structural independence

• Structural dependence

• Data dependence

Which Advantage of DBMS makes wider access to well-managed data promotes an integrated view of the organization’s operations and a clearer view of the big picture.

• Improved decision making

• Better data integration

• Improved data security

• Increased end-user productivity

Which Advantage of DBMS makes it possible to produce quick answers to ad hoc queries.

• Improved data access

• Improved data security

• Improved decision making

• Improved data sharing

A type of database designed primarily to support a company's day-to-day operations.

• Distributed database

• Centralized database

• Operational database

• Multiuser database

A type of database that supports data located at a single site.

• Distributed database

• Centralized database

• Single-user database

• Data Warehouse Database

Raw facts, or facts that have not yet been processed to reveal their meaning to the end user.

• Database

• Information

• Data

• Metadata