Chapter 1 - Introduction to Database

Data that has been processed and meets the information needs of the user.

• Data

• DBMS

• Database

• Environment

• Information

Answer explanation

Information is a meaningful data for a specific use and user.

The organisation where the database is developed.

• Data

• DBMS

• Database

• Environment

• Information

Answer explanation

The organisation or places is the environment for a database. Example university , bookstore, library.

A collection of logically related data.

• Data

• DBMS

• Database

• Environment

• Information

Answer explanation

Data base is where all data that shared the categories and information needs are placed.

Raw facts about something

• Data

• DBMS

• Database

• Environment

• Information

Answer explanation

The facts that has not been processed is called data.

A software to manage and collect data.

• Data

• DBMS

• Database

• Environment

• Information

Answer explanation

DBMS is a physical implementation of the database.

Language use to request to the DBMS via the application programs.

• LQS

• SLQ

• SQL

• LSQ

• QSL

Answer explanation

SQL is stand for Structured Query Language. It is a statement of request for data from the database.

The facts about file based system includes

• Stores in DBMS

• Stores files in cabinets

• Used by small organisations

• Keeping track of data is difficult

• Collection of application program

Answer explanation

The hassle to manage file manually when the data grew.

Categories of traditional file-based system

• Cabinet

• Manual

• Spreadsheet

• Computerised

Answer explanation

Traditional file-based system are the predecessor of database system.

Why use database

• Improved data integrity

• Improved data security

• Improved data sharing

• Improved data pricing

• Improved data definition

Answer explanation

Database approaches has advantages to overcome limitation of traditional file based system.

Which of the following is data ?

• School

• Student Name

• University

• Matrix Number

• ISBN

Answer explanation

Database environment represent the organisation or places that have some sort of rules or policy.