Font size
WorksheetsDATABASE 2 (22/7/18) D2T2
Total questions: 80
Worksheet time: 40mins
Data is collection of unprocessed item, which can include text, numbers, images, audio and video.
TRUE
FALSE
Information is data that has been processed into meaningful and useful form.
TRUE
FALSE
Examples of data such as ...
Collection of patient's names
Telephone bills
List of names in ascending order
List of marks
Collection of student's photo
Examples of information such as ...
Collection of patient's names
Telephone bills
List of names in ascending order
List of marks
List of student's name
Data that has been processed or given some structure that brings meaning to an individual or organization.
Information
Data
Collection's of students photo
List of students' matric number
List of students' date of birth
Data
Information
List of students' name
List of students' mark
These are not an information because ...
these are data that has been processed into meaningful and useful form
these are collections of unprocessed item or raw material.
Electric bills
Telephone bills
List of test marks sorted in descending order
List of students name in ascending order and lives in Melaka
Data
Information
Data is a collection of unprocessed item.
Information is data that has been processed into useful form.
TRUE
FALSE
List of names sorted in alphabetical order.
This is an example of Information.
TRUE
FALSE
Collection of patients’ names categorized by illness.
This is an example of Data.
TRUE
FALSE
Collection of students’ photos classified into classes.
This is an example of Data.
TRUE
FALSE
List of marks.
This is an example of Data.
TRUE
FALSE
Define database.
Data that has been processed into meaningful and useful form.
A collection of unprocessed item, which can include text, numbers, images, audio and video.
A system used to store and manage data in which each department within an organization has its own set of files.
A collection of data organized in a manner that allows access, retrieval and use of that data.
A software that allows you to create a computerized database.
Examples of databases.
List of students mark
Employee Database in HRMIS
A group of patients’ names categorized by illness.
Students Database in MIS
Patients Database at a clinic
Define File System.
Data that has been processed into meaningful and useful form.
A collection of unprocessed item, which can include text, numbers, images, audio and video.
A system used to store and manage data in which each department within an organization has its own set of files.
A collection of data organized in a manner that allows access, retrieval and use of that data.
A software that allows you to create a computerized database.
Define Database Management System (DBMS).
Data that has been processed into meaningful and useful form.
A collection of unprocessed item, which can include text, numbers, images, audio and video.
A system used to store and manage data in which each department within an organization has its own set of files.
A collection of data organized in a manner that allows access, retrieval and use of that data.
A software that allows you to create a computerized database.
This diagram refers to?
File System
Database
This diagram refers to?
File System
Database
Explain this concept.
File system is a system used to store and manage data in which each department within an organization has its own set of files.
Database is a collection of data organized in a manner that allows access, retrieval and use of that data.
Explain this concept.
File system is a system used to store and manage data in which each department within an organization has its own set of files.
Database is a collection of data organized in a manner that allows access, retrieval and use of that data.
Informix
Base
Sybase
These are examples of DBMS
TRUE
FALSE
UNIX
LINUX
SOLARIS
These are examples of DBMS
TRUE
FALSE
Choose three (3) examples of DBMS.
Android
MS_Access
OpenOffice.org Base
IOS
ORACLE
This figure shows one type of application software. State the type of this application software.
Word Processing Software
Spreadsheet Software
Presentation Software
Database Software
Web Browser
State three (3) limitations of File System.
Creates data isolation
Complex and time consuming to design
Require additional hardware cost
Creates data inconsistency
Creates data redundancy
State three (3) advantages of database.
Helps to reduce data redundancy
Need additional hardware cost
Helps to reduce data isolation
Need higher cost of training
Helps to reduce data inconsistency
State three (3) disadvantages of database.
Helps to reduce data redundancy
Need additional hardware cost
Helps to reduce data isolation
Need higher cost of training
Complex and time consuming to design
Explain data isolation.
Same data exist in many copies, it is difficult to update data and wastes storage space.
Data exist in separate files, it is difficult to access and update.
Different files contain different data of a particular object or person.
Explain data redundancy.
Same data exist in many copies, it is difficult to update data and wastes storage space.
Data exist in separate files, it is difficult to access and update.
Different files contain different data of a particular object or person.
Explain data inconsistency.
Same data exist in many copies, it is difficult to update data and wastes storage space.
Data exist in separate files, it is difficult to access and update.
Different files contain different data of a particular object or person.
Explain how database helps to reduce data redundancy?
By implementing database, all data in an organisation can be integrated into a single database, so it is easy to update data.
By implementing database, these could allows data sharing among users in an organisation, so it is easy to access the data.
By implementing database, changes of data can be done easily in database, and data are updated automatically.
Explain how database helps to reduce data isolation?
By implementing database, all data in an organisation can be integrated into a single database, so it is easy to update data.
By implementing database, these could allows data sharing among users in an organisation, so it is easy to access the data.
By implementing database, changes of data can be done easily in database, and data are updated automatically.
Explain how database helps to reduce data inconsistency?
By implementing database, all data in an organisation can be integrated into a single database, so it is easy to update data.
By implementing database, these could allows data sharing among users in an organisation, so it is easy to access the data.
By implementing database, changes of data can be done easily in database, and data are updated automatically.
Data is isolated in separate files so it is difficult to access and update.
Data redundancy
Data inconsistency
Data isolation
Same data may exist in many copies, so it is difficult to update data and wastes storage space.
Data redundancy
Data inconsistency
Data isolation
Different files may contain different information of a particular object or person.
Data redundancy
Data inconsistency
Data isolation
Explain why database is complex and time consuming to design.
because it needs high speed processor and larger storage for database.
because it needs to integrate all data of many parts of organization, so this could take much time in developing database.
because an organization needs to train all staff to use the database system.
Explain why database require an additional hardware cost.
because it needs high speed processor and larger storage for database.
because it needs to integrate all data of many parts of organization, so this could take much time in developing database.
because an organization needs to train all staff to use the database system.
Explain why database need higher cost of training .
because it needs high speed processor and larger storage for database.
because it needs to integrate all data of many parts of organization, so this could take much time in developing database.
because an organization needs to train all staff to use the database system.
Choose two (2) disadvantages of Database.
Database creates data inconsistency
Database is complex and time consuming to design.
Database require additional hardware cost
Database creates data isolation
Database creates data redundancy
Identify P
Data
Information
File System
Database
DBMS
Identify Q
Data
Information
File System
Database
DBMS
Identify R
Data
Information
File System
Database
DBMS
Identify S
Data
Information
File System
Database
DBMS
Identify T
Data
Information
File System
Database
DBMS
Identify V
Character
Field
Record
Table
Database
Identify W
Character
Field
Record
Table
Database
Identify X
Character
Field
Record
Table
Database
Identify Y
Character
Field
Record
Table
Database
Identify Z
Character
Field
Record
Table
Database
Identify M and N
M is Table, N is Field
M is Field, N is Table
Identify T and S
T is Database, S is Character
T is Character, S is Database
How many tables shown in this figure?
1
2
3
4
5
State two(2) name for tables in this figure.
Personal
Person
Position
Employee
Position_1
How many query in this figure?
1
2
3
4
5
State two (2) queries in this figure.
Salary
Personal
Position
Supervisor
How many report shown in this figure?
1
2
3
4
5
What is the name of this table?
Position
Person
Personal
Employee
Student
How many records?
4
5
6
7
8
Which record match with the Staff_ID 34
12
820521-02-5145
Yusri Bin Ahmad
Tapan
012-7890889
M1
34
730902-12-5667
Wafi Bin Azmi
Kinta
019-2345678
V3
56
801223-01-2334
Syasya Binti Said
Muar
017-6789456
T2
78
791203-03-4556
Azizah binti Aziz
Dungun
019-6787879
T2
89
850304-07-6779
Abdul Satar bin Ramli
Jerantut
017-7878789
V3
How many fields?
4
5
6
7
8
Listed below are referred to?
Staff_ID
IC
Name
Address
Phone
Position_ID
Character
Field
Record
Table
Database
Listed below are referred to?
12
820521-02-5145
Yusri Bin Ahmad
Tapan
012-7890889
M1
Character
Field
Record
Table
Database
All data in field names have been sorted according to?
Ascending order
Descending order
Which of the following buttons is used to sort ascending order?
Which of the following buttons is used to sort descending order?
Which of the following buttons is used to remove sort?
Which of the following record below, will be the first record after it has been sorted ascending order based on name field?
67
830903-09-5668
Azean Binti Zulfitri
Dungun
019-6543789
V3
78
791203-03-4556
Azizah binti Aziz
Dungun
019-6787879
T2
89
850304-07-6779
Abdul Satar bin Ramli
Jerantut
017-7878789
V3
23
800416-02-5116
Mazni Binti Zamri
Batu Pahat
013-4563457
S4
56
801223-01-2334
Syasya Binti Said
Muar
017-6789456
T2
State the primary key for this table.
IC
Name
Address
Position_ID
Staff_ID
State three (3) fields names.
IC
Name
Address
Position
Staff
State the suitable data type for field Data of Birth?
Text
Hyperlink
Date/Time
State the suitable data type for field Address?
Text
Hyperlink
Date/Time
State the suitable data type for field Email Address?
Text
Hyperlink
Date/Time
An object in a system that has data.
Entity
Attribute
Relationship
Each data element in an object.
Entity
Attribute
Relationship
A relationship is a link between entities.
Entity
Attribute
Relationship
Borrower is an example of?
Entity
Attribute
Relationship
Borrower ID
Borrower Name
Borrower Module
Listed above are referred to?
Entity
Attribute
Relationship
State the type of relationship shown in the diagram.
1:1
1:M
M:1
M:N
