WorksheetsChapter 1 - Introduction to Database
Total questions: 20
Worksheet time: 13mins
Data that has been processed and meets the information needs of the user.
Data
DBMS
Database
Environment
Information
The organisation where the database is developed.
Data
DBMS
Database
Environment
Information
A collection of logically related data.
Data
DBMS
Database
Environment
Information
Raw facts about something
Data
DBMS
Database
Environment
Information
A software to manage and collect data.
Data
DBMS
Database
Environment
Information
Language use to request to the DBMS via the application programs.
LQS
SLQ
SQL
LSQ
QSL
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
Categories of traditional file-based system
Cabinet
Manual
Spreadsheet
Computerised
Why use database
Improved data integrity
Improved data security
Improved data sharing
Improved data pricing
Improved data definition
Which of the following is data ?
School
Student Name
University
Matrix Number
ISBN
Limitation of traditional file-based system
Fixed reports and queries
Incompatible file formats
Program-data dependence
Difficult access to the data
Uncontrolled data duplication
Which of the following is database environment ?
School
Student Name
University
Matrix Number
ISBN
Which of the following is data in bookstore ?
Book Title
ISBN
Author
Total books
Publisher
Which of the following is information in school environment ?
Grade
Student Name
Test score <20
Total student
Exam score
Which of the following is data in school environment ?
Grade
Student Name
Test score <20
Total student
Exam score
Which data is overlapping both to bookstore and library environment.
Book Title
ISBN
Author
Book price
Publisher
Which data is related only to the bookstore but not in the library environment.
Book Title
ISBN
Author
selling price
Publisher
Everyday people will interacts with the same database for various purposes.
TRUE
FALSE
Which of the following is information in supermarket environment?
Selling price
Expiry date
Quantity
Best selling item
Profit / loss margin
Which of the following is the example of application programs.
Inventory
Point of Sales (POS)
Number of customers
Assessment record
Subject registration
