1 · Web viewPerisian aplikasi yang membenarkan pengguna melakukan tugas-tugas khas. ... Oracle /...

6.1.1.1 Give the meaning of data, information and information systems.

Section A

1. Choose the correct statement about information system.Pilih pernyataan yang betul mengenai sistem maklumat.

A A system that comprises a set of interrelated elements that transform data into information.Sistem yang terdiri daripada satu set elemen yang saling berkaitan bagi mengubah datamenjadi maklumat.

B A collection of facts that are meaningfully organised and are useful to their users.Satu set fakta bermakna yang tersusun dan berguna kepada pengguna.

C It can exist in the form of text, numbers, images, audio and video.Terdiri daripada teks, nombor, imej, audio dan video.

D It collects information, stores and manipulates it into raw facts.Mengumpul, menyimpan dan memanipulasi maklumat menjadi fakta mentah.

ASource Yea

rLevel

Bloom

KEDAH 2010

2. Figure 5 shows the concept of Information SystemRajah 5 menunjukkan konsep Sistem Maklumat.

Figure 5Rajah 5For the statement given state X, Y or Z.Berdasarkan pernyataan yang diberi nyatakan X, Y atau Z.i) Raw material, not organized and has little value.

Bahan mentah, tidak tersusun dan mempunyai nilai yang kecil.ii) Organized data that is valuable and meaningful to user.

Data tersusun yang mempunyai nilai dan bermakna kepada pengguna.iii) A set of related components that collects data, processes data and provides information.

Satu set komponen berkaitan yang mengumpul data, memproses data dan menyediakanmaklumat.

i X ii Y iii Z

Source Year

Level

Bloom

TERENGGANU 2010

22. A collection of information that is organized so that it can easily be accessed, managed, and updated is known as ____________________.

Source Year

Level

Bloom

PENANG 2008

02 What is data?Apa itu data?

1

A The facts of the information. Fakta maklumat

B The collection of information Koleksi maklumat

C The collection of raw unprocessed facts, figures and symbols. Koleksi data-data, rajah-rajah dan symbol-simbol yang belum diproses.

D The information which had been processed as something meaningful. Maklumat yang telah diproses dan menjadi bermakna.

Source Year Level BloomSARAWAK

(A)2008

22 When __________ is arranged and organized in a meaningful way, it becomes information.

A file B dataC folderD document


(A)2008

4. What is data?Apa itu data?

A The facts of the information.Fakta maklumat

B The collection of informationKoleksi maklumat

C The collection of raw unprocessed facts, figures and symbols.Koleksi data-data, rajah-rajah dan symbol-simbol yang belum diproses.

D The information which had been processed as something meaningful.Maklumat yang telah diproses dan menjadi bermakna.

Source Year Level

Bloom

PAHANG

2009

21. A collection of information that is organized so that it can easily be accessed, managed and updated

is known as __________________________.

Sekumpulan maklumat yang disusun supaya ia boleh dicapai, diurus dan dikemaskini dengan mudah dikenali sebagai ________________________.

Source Year Level

Bloom

N.SEMBILAN

2009

2

25. State True or False for the following statements.Nyatakan Benar atau Salah bagi pernyataan-pernyataan berikut

i. Information are the raw , unprocessed facts, including text, numbers, images and sound.Maklumat adalah mentah, belum diproses terdiri daripada teks, angka, imej dan bunyi.

ii. A field is a collection of related records. Medan merupakan koleksi rekod yang terhubung.

Source Year Level

Bloom

PERAK 2008

22. State whether the following statement is True or False. Nyatakan sama ada pernyataan berikut Benar atau Palsu.

An information system is a set of hardware, data, people and procedures that works together to produce information.

Sistem maklumat adalah satu himpunan perkakasan, data, manusia dan prosedur yang bekerjasama untuk menghasilkan maklumat.

Source Year Level

Bloom

PERAK 2009

22. Table 3 shows some terms used in information and communication technology.Jadual 3 menunjukkan sebahagian terma yang digunakan dalam teknologi maklumat dan komunikasi.

DataData

Information SystemSistem Maklumat

InformationMaklumat

Table 3 Jadual 3

Choose the terms shown in Table 3 which match the following statements :Pilih terma yang ditunjukkan dalam jadual 3 yang sepadan dengan penyataan berikut :

Source Year Level

Bloom

SPM 2008

Section B

3

Collection of hardware, software, data, people and procedures.Himpunan perkakasan, perisian, data, orang dan prosedur

Collection of unprocessed items, which can include text, numbers, images, audio and video.

Himpunan bahan yang belum diproses, termasuk teks, nombor, imej, audio dan video

(i)

(ii)

Section C

6.1.2.1 State the usage of Information Systems in education, business and management.

Section A

1. Both activities above are the usage of Information System in ______.Kedua-dua aktiviti di atas merupakan contoh kegunaan Sistem Maklumat dalam bidang ______.A. Education / PendidikanB. Medicine / PerubatanC. Management / PengurusanD. Art / Kesenian

CSource Yea

rLevel

Bloom

PERLIS 2010

20 Figure 4 shows the activities that use Information System facilities.

Rajah 4 menunjukkan aktiviti – aktiviti yang menggunakan kemudahan Sistem Maklumat.

FIGURE 4 RAJAH 4

Based on Table 6, which field uses facilities at Figure 4? State A, B or C.

Berdasarkan Jadual 6, bidang manakah yang menggunakan kemudahan di Rajah 4?

Nyatakan A, B atau C.

TABLE 6 JADUAL 6

Source Year Level BloomKL 2008

4

Carry out online buying and sellingMenjalankan jual beli atas talian

Planning the delivery of goods and servicesMerancang penghantaran barangan dan perkhidmatan

Hotel room bookingsTempahan bilik hotel

A ManagementPengurusan

B BusinessPerniagaan

C EducationPendidikan

Source Year Level

Bloom

TERENGGANU 2009

Section B

Section C

6.1.3.1 List the Information System components: i. data, ii. hardware, iii. software, iv. people and v. procedure

Section A

1. Choose the correct components of Information System. / Pilih komponen Sistem Maklumat yang betul.I Data / Data II People / ManusiaIII Computer / Komputer IV Procedure / ProsedurA I, II and III / I, II dan IIIB I, II and IV / I, II dan IVC I, III and IV / I, III dan IVD II, III and IV / II, III dan IVB

Source Year

Level

Bloom

JOHOR 2010

6 Table 2 shows the components of an information system

Jadual 2 menunjukkan komponen sistem maklumat

J HardwarePerkakasan

K Software5

Perisian

L DataData

M ProcedureProsedur

N PeopleManusia

Table 2 Jadual 2

i) All computer equipment used to perform input, processing and output functions.

Semua peralatan komputer digunakan untuk melakukan fungsi masukan, memproses dan keluaran

ii) Components that consists program that allow users to do spesific task.

Komponen yang mengandungi program yang membenarkan pengguna elaksanakan tugas tertentu.

iii) Operating instructions or guidelines for the user of an information system.

Arahan pengoperasian atau panduan kepada pengguna system maklumat

Source Year

Level

Bloom

PAHANG 2008

22 Figure 11 shows the five components of an information system.

Figure 11

Based on Figure 11, name component

(i) X(ii) Y

Source Year Level BloomSARAWAK (A) 2009

22. The components of an information system are human, hardware, software, …………………………. and data.

6

X

Y

Komponen sistem maklumat adalah manusia, perkakasan, perisian, ……………………………. dan data.

Source Year Level

Bloom

PUTRAJAYA 2009

22. Write whether the statement below is True or False.

Tuliskan sama ada pernyataan di bawah Benar atau Palsu.

An information system is a collection of hardware, software, data, people and procedures that work together to produce information.

Sistem maklumat adalah sekumpulan perkakasan, perisian, data manusia dan prosedur yang saling bekerjasama untuk menghasilkan maklumat.Source Year Lev

elBloom

N.SEMBILAN

2009

1. Figure 5 below is a component of Information System. Rajah 5 di bawah adalah satu komponen Sistem Maklumat.

State X : Namakan X:

Source Year Level

Bloom

KELANTAN

2009

Section B

Section C

6.1.3.2 Define each of the Information System components.

Section A

2. Figure 12 shows one of Information Systems components. Rajah 12 menunjukkan salah satu daripada komponen Sistem Maklumat.

7

Figure 5 Rajah 5

Figure 12Rajah 12

Component X is operating instructions for the user of an information system. Komponen X adalah arahan operasi untuk pengguna bagi sistem maklumat. Based on Figure 12, state X. Berdasarkan Rajah 12, nyatakan X. Procedure

Source Year

Level

Bloom

PUTRAJAYA 2010

17. Table 3 shows the concept of information systemJadual 3 menunjukkan pernyataan konsep teknologi maklumat

A

Very important in information systems. Without it , decision and conclusion cannot be made. Helps us to make the right decision.

Sangat penting dalam sistem maklumat.Tanpanya, keputusan dan penilaian tidak dapat dibuat. Membantu dalam membuat keputusan.

B

Include all computer equipment and media on which data is recorded, such as paper, floppy disks and compact discs.

Merangkumi kesemua peralatan komputer dan media dimana data direkodkan seperti kertas, disket dan cakera padat.

C

An information system consists of programs for the computers. These programs allow the computers to carry out most of the instructions related to information processing.

Sistem maklumat mengandungi program untuk komputer. Program ini membolehkan komputer untuk melaksanakan kebanyakan arahan yang berkaitan dengan pemprosesan maklumat.

DSystems personnel and end users.

Petugas sistem dan pengguna akhir.

E

Operating instructions for the user of an information system can be in the form of guidelines in the user manuals.

Arahan pengoperasian kepada pengguna sistem maklumat dalam bentuk panduan dalam manual pengguna.

Table 3 Jadual 3

Component X Komponen X

8

Based on Table 3 , match the component of information system with following statement by writing A,B,C,D or E

Berdasarkan Jadual 3, padankan komponen sistem maklumat dengan menulis A,B,C,D atau E

(i) People Manusia (ii) Procedure Prosedur

Source Year

Level

Bloom

PAHANG 2008

Source Year Level

Bloom

TERENGGANU 2009

8 Which of the following statements are the information system components?Antara pernyataan berikut, yang manakah merupakan komponen sistem

maklumat?

I. User manualPanduan pengguna

II. Users of the information system.Pengguna sistem maklumat.

III. Application software that allow users to do specific tasks.Perisian aplikasi yang membenarkan pengguna melakukan tugas-tugas

khas.IV. Computer equipment used to perform input, processing and output functions.

Peralatan computer yang dugunakan untuk menghasilkan fungsi-fumgsi input, proses dan output.

A II and IIIB I, II and IIIC II, III and IVD I, II, III and IV

9

Source Year Level

Bloom

JOHOR 2009

18. Which of the following can be identify as an example of a component on an information system.Yang manakan berikut boleh dikenalpasti sebagai contoh bagi komponen dalam Sistem Maklumat

I. Technician JuruteknikII. System Analyst Juruanalisa SistemIII. Data entry operator . Operator Kemasukan DataIV. Manager of Information Systems. Pengurus Sistem Maklumat

A. I,II, and IIIB. I, II and IVC. I, III, and IVD. I,II, III, and IV

Source Year Level

Bloom

PAHANG

2009

20. The components of an information system are human, hardware, software, procedures and ______________ .

Komponen sistem maklumat adalah manusia, perkakasan, perisian, prosedur, dan _____________ .

Source Year Level

Bloom

SPM 2007

Section B

29. Figure 8 shows interrelationship between information systems component.Rajah 8 menunjukkan perhubungan di antara komponen-komponen sistem

maklumat.

Figure 8 Rajah 8Based on figure 8 :Berdasarkan rajah 8 :

10

a) State two components of information systems other than the ones mentioned.

Senaraikan dua komponen sistem maklumat selain dari yang dinyatakan.b) State the function for the answer in question ( a )

Nyatakan fungsi bagi komponen yang dinyatakan pada soalan ( a )

Section C

6.1.3.3 Describe the interrelation between information system components using a diagram.

Section A

Section B

1. Figure 18 shows the interrelation of five main components of an online ticketing system for a cinema.Rajah 18 menunjukkan hubungan antara lima komponen utama dalam satu sistem jualan tiket atas talian bagi sebuah pawagam.

Based on Figure 18: / Berdasarkan Rajah 18 :(a) state one example of component: / Nyatakan satu contoh komponen: (i) B hardware (ii) C software

.(b) Describe the interrelation between component A and component E.

Huraikan hubungan antara Komponen A dan Komponen E.Customer need user guide because they can know how to enter to the cinema ticketing online system

11

Source Year

Level

Bloom

SPM 2010

2. Figure 6 shows the components in an information system.Rajah 6 menunjukkan komponen-komponen di dalam sistem maklumat.

Figure 6 / Rajah 6Based on Figure 6,Berdasarkan Rajah 6 / (i) Name X. / Namakan X(ii) Which component of the information system is responsible to provide interface for a user to

enter data into the system with the help of input devices?Komponen yang manakah dalam sistem maklumat bertanggungjawab untuk menyediakanantara muka untuk pengguna memasukkan data ke dalam sistem dengan bantuan perantiinput?

(i) Procedure / Prosedur (ii) Software / Perisian

Source Year

Level

Bloom

KEDAH 2010

30. Figure 5 below shows the interrelation between information system components.

12

(a) State TWO missing elements of information system components.

(i) ___________________________________

(ii) ___________________________________ [2 marks]

(b) Describe the interrelation between DATA and SOFTWARE.[2 marks]

Source Year

Level

Bloom

PETALING PERDANA 2008

29. BlueBus Company has just announced the launch of a web-based express bus online ticketing system. This information system offers the customers a comprehensive solution of ease with booking bus tickets anytime and anywhere at no extra cost.Syarikay BlueBus mengumumkan pelancaran sistem jualan tiket berasaskan web. Sistem maklumat ini membolehkan pelanggan menempah tiket perjalanan secara atas talian tanpa sebarang bayaran tambahan.

FIGURE 11 shows the website and five main components of the ticketing system.Rajah 11 menunjukkan halaman web dan 5 komponen sistem jualan tiket tersebut.

13

Figure 5

FIGURE 11 RAJAH 11

Based on the situation given,Berdasarkan situasi yang diberi,

(a) Draw a diagram to show the interrelation among five main IS components of the online ticketing system. Lukis rajah menunjukkan kaitan diantara kelima-lima komponen sistem jualan tiket atas talian tersebut.

[ 2 marks](b) Explain the relationship between Component B and Component D.

Terangkan kaitan diantara Komponen B dan Komponan D.

Source Year Level

Bloom

PCGHS 2009

Component A:Customer Pelanggan

Component D:Ticketing programProgram Jualan Tiket

Component E:

Component C:Computer, printerKomputer, Pencetak

Component B:User’s guidePanduan Pengguna

14

30. Figure 9 shows the interrelation between Information System components.

Figure 9 menunjukkan hubungkait antara komponen Sistem Maklumat.

Figure 9

Rajah 9

a) Identify Y and describe the interrelation between Y and procedure. [2 marks]

Kenalpasti Y dan huraikan hubungkait antara Y dan prosedur. [2 markah]

b) Explain briefly Hardware. [2 marks]

Terangkan secara ringkas perkakasan. [2 markah]

Source Year Level BloomHULU LANGAT 2009

Section C

33. Figure 16 shows the components of the SMK ABC’s Information System.Rajah 16 menunjukkan komponen-komponen Sistem Maklumat SMK ABC.

FIGURE 16 RAJAH 16

15

Data

YSoftware

Procedure Hardware

D

E

A

B

C

(a) Identify component C in SMK ABC. Explain the interrelation between component A and C.

[3 marks] Kenalpasti komponen C dalam Sistem Maklumat SMK ABC. Terangkan hubungan komponen A dan C.

[3 markah] (b) Describe an activity that can threaten the security of B.

[4 marks]Huraikan sebarang aktiviti yang dapat mengancam keselamatan B.

[4 markah]

Source Year

Level

Bloom

PERAK 2008

Source Year Level

Bloom

TERENGGANU 200916

6.1.4.1 List five types of Information Systems: i. Management Information System (MIS), ii. Transaction Processing System (TPS), iii. Decision Support System (DSS), iv. Executive Information System (EIS), v. Expert System (ES)/Artificial Intelligence (AI)

Section A

1. Five types of Information System are Decision Support System (DSS), Management Information System (MIS),

and Expert System (ES), Executive Information System (EIS) and _____________________

Lima jenis Sistem Maklumat ialah Sistem Sokongan Keputusan (DSS), Sistem Pengurusan Maklumat (MIS), Sistem Pakar (ES), Sistem Maklumat Eksekutif (EIS) and ________________________ A. Transaction Processing System (TPS)

Sistem Pemprosesan Transaksi (TPS) B. Executive Assistant System (EAS)

Sistem Bantuan Eksekutif (EAS)C. Decision Information System (DIS)

Sistem Maklumat KeputusanD. Expert Information System (EIS)

Sistem Maklumat PakarA

Source Year

Level

Bloom

MELAKA 2010

2. Which of the following are types of Information Systems?Yang manakah di antara berikut merupakan jenis-jenis Sistem Maklumat?I Transaction Processing System / Sistem Pemprosesan TransaksiII Management Information System / Sistem Pengurusan MaklumatIII Expert Information System / Sistem Maklumat PakarIV Executive Information System / Sistem Maklumat EksekutifA. I, II, IIIB. I, II, IVC. I, III, IVD. II, III, IVB

Source Year

Level

Bloom

N. SEMBILAN 2010

3. Match the information system in column X with statements in column YPadankan sistem maklumat di medan X dengan kenyataan dalam medan Y

Column X Column YA Transaction

Processing System Sistem Pemprosesan Transaksi

I software package that consists of the basic structure used to find answers to questions. Sebuah perisian pakej yang terdiri daripada struktur asas yang digunakan untuk mencari jawapan atas pertanyaan

II The system that concerned with how decisions

17

affect an entire organization Sistem yang berkaitan dengan bagaimana keputusan mempengaruhi seluruh organisasi

III Collect, store, modify and retrieve the transactions of an organization. Mengumpulkan, menyimpan, mengubah dan mengambil transaksi dari sebuah organisasi

B

Executive Information SystemSistem Maklumat Eksekutif

IV supports managers in non routine decision-making tasks menyokong pengurus non rutin turun keputusan tugas

V set of formal business systems designed to provide information for an organization set sistem perniagaan formal yang direka untuk memberikan maklumat bagi suatu organisasi

A=iii B=ii

Source Year

Level

Bloom

SABAH 2010

4. Table 6 shows some terms used in information systems. Jadual 6 menunjukkan sebahagian terma yang digunakan dalam sistem maklumat.

Management Information Systems(MIS)Sistem Maklumat Pengurusan

Executive Information System (EIS)Sistem Maklumat Eksekutif

Transaction Processing Systems (TPS)Sistem Pemprosesan Transaksi

Table 6Jadual 6

Figure 14 shows some diagrams used in information system, A and B.Rajah 14 menunjukkan sebahagian diagram yang digunakan dalam sistem maklumat, A dan B.

18

A

B

Figure 14Rajah 14

Choose the terms shown in Table 6 which match the diagrams A and B.Pilih terma yang ditunjukkan dalam Jadual 6 yang sepadan dengan diagram A dan B.

(i) ATransaction Processing Systems (TPS)

(ii) B Executive Information System (EIS)

Source Year

Level

Bloom

PUTRAJAYA 2010

15. Online Banking is the example of _______________________.

A. Decision Support SystemSistem Sokongan Keputusan

B. Executive Information SystemSystem Maklumat Esekutif

C. Transaction Processing SystemSistem Pemprosesan Tansaksi

D. Management Information SystemSistem Pengurusan Maklumat

Source Year

Level

Bloom

GOMBAK 2008

23 Which of the following are types of information systems?

I. Expert System II. Executive Information System III. Database Management System IV. Management Information System

A. I, II and IIIB. I, II and IVC. I, III and IV D. II, III and IV


(A)2008

i. The following terms in Table 5 are related to information system.Terma di dalam Jadual 5 berikut adalah berkaitan dengan sistem maklumat.

19

A Database Management SystemSistem Pengurusan Pangkalan Data

B Decision Support SystemSistem Sokongan Keputusan

C Executive Information SystemSistem Maklumat Eksekutif

D Management Information SystemSistem Maklumat Pengurusan

E Information SystemSistem Maklumat

F InformationMaklumat

G DataData

Table 5 Jadual 5

Match the following definitions with the terms given by writing A, B, C, D, E, F or G.Padankan definisi berikut dengan terma yang diberikan dengan menulis A, B, C, D, E, F atau G.

(i) A system which is used by senior managers to address strategic long-term planning and objectives.Sistem yang digunakan oleh pengurus “senior” untuk menempatkan perancangan dan objektif strategik jangka panjang.

(ii) A set of hardware, software, people, data and procedures that work together to process data. Set perkakasan, perisian, manusia, data dan prosedur yang bekerjasama untuk memproses data.

Source Year Level

Bloom

KELANG 2009

23 Column A of Table 2 describes information system P and Q. Column B lists four types of information system.

A B

P - often tied to other systems- serves the most elementary day-to-day activities of

an organisation- usually has high volumes of input and output

DSS

ES

Q - contain acquired expert knowledge- usually contain two components: a knowledge base

and an inference engine program- built with decision-making rules

MIS

TPS

Table 2

20

Based on Table 2, identify the type of information described in

(i) P(ii) Q


Source Year Level

Bloom

TERENGGANU 2009

23. An operational-level information system is used to collect, store, modify and retrieve the data of an organization. It ensures the smooth flow of data and the progression of processes throughout the enterprise.

State the type of information system mentioned above.

Source Year Level

Bloom

PCGHS 2009

23. ProcedureProsedur

Decision Support SystemSistem Sokongan

Keputusan

Transaction Processing System

Sistem Pemprosesan

21

Transaksi

Expert SystemSistem Pakar

DataData

SoftwarePerisian

i. _________________________ is an information system that helps an organization to keep track of daily operations and records these events in database. _________________________ adalah sistem maklumat yang membantu organizasi menjejak operasi harian dan merekod semuanya peristiwa ke dalam pangkalan data.

ii. _____________________is operating instructions for user to follow when using software, hardware and data.

______________________ merupakan arahan operasi yang perlu diikuti pengguna apabila menggunakan perisian, perkakasan dan data.

Source Year Level

Bloom

UNKNOWN

23. Doctor uses an information system to help diagnose illnesses. The system has been programmed with facts and rules about the symptoms of illnesses.

Doktor menggunakan suatu sistem maklumat untuk mengesan pelbagai penyakit. Sistem tersebut sudah diprogramkan dengan beberapa fakta dan peraturan mengenai tanda-tanda sesuatu penyakit.

Based on the text, Berdasarkan teks,(i) State the name of the information system.

Nyatakan nama sistem maklumat itu.

(ii) State where the facts and rules come from.Nyatakan dari mana fakta dan peraturan tersebut diperoleh.

Source Year Level

Bloom

SPM 2009

Section B

Section C

6.1.4.2 State the usage of each type of information system.

Section A

23. Table 3 shows types of Information Systems.Jadual 3 menunjukkan jenis-jenis Sistem Maklumat.

22

A Artificial Intelligence (AI)Kepintaran Buatan

B Transaction Processing System (TPS)Sistem Pemprosesan Transaksi

C Decision Support System (DSS)Sistem Bantuan Keputusan

Table 3 Jadual 3

Match A, B or C with the following statements:Padankan A, B atau C dengan pernyataan di bawah:

i) Analyses business data and presents it so that top management can make business decisions easily.Menganalisis data perniagaan dan mempersembahkannya kepada pengurusan tertinggi untuk membuat keputusan perniagaan dengan mudah.

ii) Helps an organisation to keep track of daily operations and records these events in a database.Membantu organisasi mengesan operasi harian dan merekodkan peristiwa tersebut ke dalam pangkalan data.

Source Year Level

Bloom

KEDAH 2009

Section B

Section C

6.1.5.1 Define bit, byte, field, record, and file

Section A

21. Choose the correct answer.

file field record

TABLE 4 shows a list of international dialing codes.

Country name Country CodeAustraliaJapanHong KongMalaysia…

618185260…

TABLE 4

Each column of TABLE 4 is known as _________________.

Source Year Level

Bloom

PCGHS 2009

20. Record is a collection of _________about one person, place or thing in a table.Rekod ialah koleksi__________mengenai seseorang, tempat atau benda dalam jadual.

Source Year Level

Bloom

23

PAHANG

2009

23. Complete the following statements by filling in the blanks.

Isikan ruang kosong untuk melengkapkan pernyataan berikut:

A ________________ is the smallest unit of data.

________________ adalah unit terkecil untuk data

A. Database Pangkalan data

B. Field Medan

C. File Fail

D. Bit Bit

Source Year Level

Bloom

PERLIS 2009

24. Table 5 shows a sample data fileJadual 5 menunjukkan contoh fail data.

Index No Name Gender Class

A101 Ali and Abu M 5SN1

A102 Arita a/p Rama F 5SN1A110

Wong Tat Meng M 5SN1

A118 Sidek bin Muda M 5SN1

Table 5 Jadual 5

Based on Table 5, state what X and Y representBerdasarkan Jadual 5, nyatakan apa yang diwakili oleh X dan Y.

(i) X :

(ii) Y :

Source Year Level

Bloom

SPM 2008

Section B

Section C

24

X

Y

6.1.5.2 State the hierarchy of data: Bit ? Byte (Character) ? Field ? Record ? File ? Database

Section A

1. A ___________ is a collection of many records.___________ ialah koleksi rekod yang banyakFile

Source Year

Level

Bloom

TERENGGANU 2010

2. Figure 11 shows the data hierarchy in an information system. Rajah 11 menunjukkan hierarki data dalam suatu sistem maklumat

Figure 11 / Rajah 11Based on Figure 11, state the name of:Berdasarkan R ajah 11, nyatakan nama:(i) H field(ii) R file (table)

Source Year

Level

Bloom

SPM 2010

3. Figure 7 shows the hierarchy of data. / Rajah 7 menunjukkan hirarki data.

25

Figure 7 / Rajah 7Choose the correct answer. /Pilih jawapan yang betul.A. Q=Field / Medan R=Record/RekodB. Q=Record/ Rekod R=Field/MedanC Q=Record/ Rekod R=File/FailD Q=Table/Jadual R= File/FailC

Source Year

Level

Bloom

KEDAH 2010

25. The following terms are related to database.File Record Field Byte Bit

Title: Discovering Computers 2008Author: Shelly Cashman VermaatPublisher: Thomson Course Technology

Title: Programming With CAuthor: Byron S. GottfriedPublisher: McGraw-Hill

Title: Multimedia ConceptAuthor: Jim ShumanPublisher: Thomson Course Technology

FIGURE 6

(a) The individual element Y is known as ______________.(b) X is known as ________________.

Source Year

Level

Bloom

PENANG 2008

23.

Hierarchy of Data

Data Hirarki

Definition

Definisi

P Combination of 1 and 0

Q Combination of fields

R Combination of bytes (character)

S Combination of records 26

Individual element Y

X

Table 1

Match P, Q, R and S in Table 1 with the correct definition of:

a) Byte : ___________________

Aksara : ___________________

b) Field : ___________________

Medan : ___________________

c) File : ___________________

Fail : ___________________

Source Year Level

Bloom

PERLIS 2008

27

Question 19 is based on Figure 3 below.

Figure 3

10. Figure 3 shows the employee table in the Staff Information System of Kiya’s Company.

Name:

i. P : …………………………

ii. Q : …………………………

Source Year

Level

Bloom


21 Figure 5 shows a hierarchy of data.

Rajah 5 menunjukkan hirarki data.

FIGURE 5 RAJAH 5

Based on the figure, name M and N.

Berdasarkan rajah, namakan M dan N.

Source Year Level Bloom28

Bit

Byte

M

Record

N

Database

P

Q

KL 2008

22. Rearrange the following elements in the ascending hierarchy.

I. RecordII. BitIII. FieldIV. FileV. Byte

Source Year Level

Bloom

PCGHS 2009

23 Table 6 shows some terms used in information system.Jadual 6 menunjukkan sebahagian terma yang digunakan dalam system

maklumat

RecordRekod

FileFail

DatabasePangkalan

Data

FieldMedan

Table 6 Jadual 6

Choose the term shown in Table 6 which match the following statements:Pilih terma yang ditunjukkan dalam Jadual 6 yang sepadan dengan pernyataan

berikut:

(i) A collection of data organised in a systematic way.Koleksi data yang disusun dengan sistematik.

(ii) A combination of one or more characters.Kombinasi satu atau lebih huruf.

Source Year Level

Bloom

JOHOR 2009

21. A _____________is a structured collection of records or data that is stored in a computer system.___________ ialah koleksi rekod atau data yang disimpan dalam sistem komputer.

Source Year Level

Bloom

PAHANG

2009

24. Table 4 shows how data can be represented in a database.Jadual 4 menunjukkan bagaimana data diwakili di dalam pangkalan data.

DescriptionHuraian

BitBit

Consists of only 0 or 1Terdiri hanya 0 atau 1

FieldMedan

The smallest unit of information that can be accessed in a databasesystem which is associated with certain attribute

29

Unit maklumat terkecil yang boleh dicapai di dalam pangkalandata dan ia berkaitan atribut-atribut tertentu..

FileFail

Presented as tables in a databaseBerbentuk jadual dalam pangkalan data.

P A collection of bits that form a characterSatu himpunan bit yang mewakili satu aksara.

Q A group of related fields about a single entitySatu kumpulan medan yang berkait tentang satu entiti.

Table 4 Jadual 4Based on Table 4, nameBerdasarkan Jadual 4, namakan

i) P

ii) Q

Source Year Level

Bloom

KEDAH 2009

22. Figure 5 shows a sample data from a database file.Rajah 5 menunjukkan contoh data dari satu fail pangkalan data.

Based on Figure 5, match P and Q with the following terms.Berdasarkan Rajah 5, padankan P dan Q dengan terma dibawah.

i) Record Rekodii) Field Medan

Source Year Level

Bloom

KEDAH 2009

30

23. A ________________ is the smallest meaningful unit of data.__________________ adalah unit terkecil yang bermakna dalam data

A. Field/medanB. Record/rekodC. File/failD. Database/pangkalan data

Source Year Level

Bloom

WPKL 2009

23. State whether the following statement is True or False.

Nyatakan sama ada pernyataan berikut Benar atau Palsu.

(i) A byte is always one of two values, written as 1 or 0. Satu bait adalah sama ada dua nilai iaitu 1 atau 0.

(ii) In database system, fields are the smallest units of information you can access and each field has a field name.

Dalam sistem pangkalan data, medan adalah unit maklumat terkecil yang anda boleh akses dan setiap medan ada nama medan.

Source Year Level

Bloom

PUTRAJAYA 2009

24. Which of the following is the correct data hierarchy?

Manakah di antara yang berikut merupakan hirarki data yang betul?

A. bit à byte à field à file à database à record

bit à bait à medan à fail à pangkalan data à rekod

B. bit à byte à record à field à file à database

bit à bait à rekod à medan à fail à pangkalan data

C. bit à byte à record à file à field à database

bit à bait à rekod à fail à medan à pangkalan data

D. bit à byte à field à record à file à database

bit à bait à medan à rekod à fail à pangkalan data

Source Year Level

Bloom

N.SEMBILAN

2009

25. State True or False for the following statements.Nyatakan Benar atau Salah bagi pernyataan-pernyataan berikut

ii. Information are the raw , unprocessed facts, including text, numbers, images and sound.

31

Maklumat adalah mentah, belum diproses terdiri daripada teks, angka, imej dan bunyi.

iii. A field is a collection of related records. Medan merupakan koleksi rekod yang terhubung.

Source Year Level

Bloom

UNKNOWN

22. Figure 10 shows a database structure. Rajah 10 menunjukkan struktur pangkalan data.

Figure 10Rajah 10

Q in Figure 8 represents ____________________.Q dalam Rajah 8 mewakili ___________________

Source Year Level

Bloom

UNKNOWN

2. Fill in the blanks with the suitable answer.Isikan pernyataan berikut dengan terma yang betul.

(i) A _________ is a collection of related records. A combination of this file is called a database.

Satu ________ ialah himpunan rekod yang berkaitan. Kombinasi fail ini dipanggil pangkalan data.

(ii) A __________ is a unit of data consisting of one or more bytes. It is the smallest unit of meaningful information in the database.

Satu _________ adalah satu unit data mengandungi satu atau lebih bait. Ia adalah unit maklumat bermakna yang terkecil di dalam pangkalan data.

32

DatabasePangkalan

Data

FileFail

Q

FieldMedan

FieldMedan

FileFail

Q Q Q

FieldMedan

FieldMedan

FieldMedan

FieldMedan

FieldMedan

FieldMedan

Source Year Level

Bloom

KELANTAN

2009

7. Figure 5 shows the hierachy of data.Rajah 5 menunjukkan hiraki bagi data.

Figure 5Rajah 5

Name : Namakan :(i) K : ________________________ (ii) L : ____________________

Source Year Level

Bloom

SPM 2007

Section B

Section C

6.2.1.1 Define database and Database Management Systems (DBMS).

Section A

1. Manager uses an information system to make the business processes and activities more efficient compared to doing them manually. The information system provides regular information about the daily activities of a business to the manager. The information system developed using Database Management System (DBMS) software.Pengurus menggunakan suatu sistem maklumat untuk meningkatkan kecekapan dalam proses dan aktivitiperniagaan berbanding dengan cara manual. Sistem maklumat ini memberikan maklumat lazim berkaitanaktiviti harian perniagaan kepada pengurus. Sistem maklumat tersebut dibangunkan menggunakan perisisanSistem Pengurusan Pangkalan Data (SPPD).

Based on the statements above,Berdasarkan pernyataan di atas,(i) State the type of the information system.

Nyatakan jenis sistem maklumat.(ii) State one example of the DBMS.

Nyatakan satu contoh SPPD.(i) MIS / Management Information System (ii) Oracle / SQL / Microsoft Access

Source Year

Level

Bloom

PAHANG 2010

2. A _________ is a program that accesses information from a database and provide interfacebetween user and database._________ ialah program yang mencapai maklumat dari pangkalan data dan menyediakanantaramuka antara pengguna dan pangkalan data. DBMS

33

Bit K Field L Database

Source Year

Level

Bloom

TERENGGANU 2010

3. Which of the following is the benefit of using database?Manakah antara berikut merupakan faedah menggunakan pangkalan data?A. Low maintenance cost

Kos penyelenggaraan yang rendahB. Data can be hacked by others

Data boleh dicerobohi oleh orang lainC. Minimises data redundancy

Meminimakan pertindihan dataD. The data is valid

Data tersebut adalah sah C

Source Year

Level

Bloom

TERENGGANU 2010

4. Figure 13 shows a program that access information from a database. Y system enables you to extract, modify and store information from the database.

Rajah 13 menunjukkan sebuah program untuk mencapai maklumat dari pangkalan data. Sistem Y membenarkan anda mengekstrak, membaiki dan menyimpan maklumat dari pangkalan data.

Figure 13Rajah 13

Name Y.Namakan Y.DBMS

Source Year

Level

Bloom

PUTRAJAYA 2010

34

Y

Student File

Subject File

Academic File

Parent File

11. ……………………………………… is a program that accesses information from a database. It

provides an interface between the database and the user. It also enables the user to extract, modify and

store information from a database.

Source Year

Level

Bloom


24 A school database records a student's details only once. This prevents data ……………..


(A)2008

24 State whether the following statement is True or False.

A database management system is a collection of programs which allow data to be stored, retrieved, and updated. Information can be generated through queries and reports.


25. Choose the correct answer.

Database Management System Information SystemDatabase Procedure

Data HardwareCopyright Intellectual property

TABLE 6

(i) A series of documented rules or guidelines that users follow to achieve a specific result.(ii) A form of protection provided by laws to authors of their original works.(iii) A set of computer programs that can be used to add, access, and process data in a database.

Source Year Level

Bloom

PCGHS 2009

18 Figure 3 shows the term used in information and communication technology.Rajah 3 menunjukkan terma yang digunakan dalam teknologi maklumat dan

komunikasi.

It is a software that allows users to create a database; retrieve, update anddelete data in the database.

Ia adalah perisian yang membenarkan pengguna menghasilkan pangkalandata ; capai semula, kemaskini dan memadam data dalam pangkalan data.

Figure 3Rajah 3

The statement in Figure 3 refers to ____________________________________________.35

Pernyatan dalam Rajah 3 merujuk kepada ______________________________________.

Source Year Level

Bloom

JOHOR 2009

24. Figure 5 shows a Database Management System (DBMS). It provides an interface

between the database and the end user.

Rajah 5 menunjukkan satu Sistem Pengurusan Pangkalan Data (DBMS). DBMS menyediakan

antaramuka antara pangkalan data dan pengguna

Figure 5 Rajah 5

Database Management System enables users to extract, __________ and store information from a

_________.

Sistem Pengurusan Pangkalan data membolehkan pengguna ekstrak, _________ dan menyimpan

maklumat dari __________.

Source Year Level BloomHULU LANGAT 2009

3. Figure 6 below is about a DatabaseManagement System (DBMS).Rajah 6 di bawah adalah berkenaan satu Sistem Pengurusan Pangkalan Data (SPPD).

36

DBMS

Subject File

Student File

AcademicFile

Software

UserPengguna

InterfaceAntaramuka

DatabasePangkalan Data

http://www.iusb.edu/~extendsb/img/Computer.JPG

Based on the Figure 6 above, which of the following softwares contain DBMS?

Berdasarkan Rajah 6 di atas, perisian manakah mengandungi SPPD ?.

A. MS Excel

B. MS Power Point

C. MS Access

D. MS Money

Source Year Level

Bloom

KELANTAN

2009

23. State whether the following statements are True or False.Nyatakan sama ada pernyataan berikut Benar atau Palsu.(i) Database Management System (DBMS) is a software used in adding, updating,

managing, accessing, and analysing data in a database.Sistem Pengurusan Pangkalan Data (SPPD) merupakan perisian yang digunakan dalam menambah, mengemaskini, mengurus, mencapai, dan menganalisis data dalam pangkalan data.

(ii) Modification of data in one file to be automatically changed in other files is called data integrity.

Pengubahsuaian data dalam satu fail yang menyebabkan perubahan terus pada fail yang lain

dipanggil integriti data.

Source Year Level

Bloom

PERAK 2009

Question 25 is in statement form. Write True or False for the following statements: Soalan 25adalah dalam bentuk pernyataan. Tuliskan Benar atau Palsu untuk pernyataan tersebut.

25. Database Management System (DBMS) is a software used in adding, updating, managing, accessing, and analysing data in a database.Sistem Pengurusan Pangkalan data (SPPD) adalah perisian yang digunakan untuk menambah, mengemas kini, mengurus, mencapai, dan menganalisis data dalam pangkalan data.

Source Year Level

Bloom

SPM 2007

23. Table 4 shows some terms used in information and communication technology.Jadual 4 menunjukkan sebahagain terma yang digunakan dalam teknologi maklumat dan komunikasi.

secondary keykunci sekunder

DMBSSPPD

foreign keykunci asing

databasepangkalan data

Table 4 Jadual 4

Choose the terms shown in Table 4 which match the following statements :37

Figure 6 Rajah 6

Pilih terma yang ditunjukkan dalam Jadual 4 yang sepadan dengan pernyataan berikut.

i) A collection of data organised in a systematic wayKoleksi data yang diurus secara sistematik.

ii) A field key that must match a primary key value in another tableMedan yang diisi mesti dipadankan dengan nilai kunci primer dalam jadual ini.

Source Year Level

Bloom

SPM 2008Section B

30. Figure 07 shows the management system of Jempol Hospital patient records. Answer the questions based on the diagram Rajah 07 menunjukkan sistem pengurusan rekod pesakit di Hospital Jempol

Input X

Verification of patient

Based on Diagram 02,

(a) What is X/Apakah X

(b) State the benefit of using XNyatakan kelebihan menggunakan X

(c) State two consequences if the system is hacked by the unauthorized personnel.Nyatakan dua kesan jika sistem di ceroboh oleh pihak yang tidak bertanggungjawab

Source Year Level

Bloom

WPKL 2009

Section C

6.2.1.2 List the benefits of using database.

Section A

24. Write TRUE or FALSE for the following statement. Tuliskan BENAR atau PALSU pada pernyataan berikut.

38

Diagram 2

(i) A Database Management System allows its contents to be easily accessed, updated, stored and retrieved.Sistem Pengurusan Pangkalan Data membenarkan kandungannya senang diperolehi, dikemaskini, disimpan dan dicapai semula.

(ii) By using database, data integrity can be assured.Dengan menggunakan pangkalan data, integriti data boleh dipastikan betul sentiasa.

Source Year Level

Bloom

KELANG 2009

4. Table 8 shows benefits of using Database.

Jadual 8 menunjukan kelebihan menggunakan Pangkalan Data.

A Data can be sharedData boleh dikongsi

B Minimise data redundancyMengurangkan data bertindih

C Data integrity is assuredUntuk memastikan ketelusan data

Based on the table 8, select A, B, or C for the statements below.

Berdasarkan Jadual 8 , pilih A, B, or C untuk kenyataan di bawah.

(i) Most data item stored in only one file. By using database there is no need to repeat recording the same data.

Kebanyakan item data disimpan di dalam satu fail. Dengan menggunakan pangkalan data, tidak perlu memasukkan data yang sama berulang kali.

(ii) When a user modifies data in one of the files in a database, the same data will change automatically in all files.

Apabila pengguna mengubahsuai data dalam satu fail dalam pangkalan data, data akan bertukar secara automatic dalam semua fail.Source Year Lev

elBloom

KELANTAN

2009

Section B

QUESTION 5Soalan 5

a) State 2 fields that use Information System . Nyatakan 2 bidang yang menggunakan Sistem Maklumat. [2M]

39

Table 8Jadual 8

b) List two benefit of Database. Senaraikan dua kelebihan pangkalan data. [2M]

Source Year Level

Bloom

PERLIS 2008

29. You keep a data base of your friends’ names, addresses and dates of birth. The data base is kept in the school server and can be retrieve by other user. [4 marks]Anda menyimpan pangkalan data berkaitan nama, alamat, dan tarikh lahir rakan-rakan anda. Pangkalan data itu disimpan di dalam komputer pelayan sekolah dan boleh dicapai oleh pengguna lain.

(a) State two uses of the information from the data base to be utilized.Nyatakan dua kegunaan itu maklumat daripada pangkalan data dimanfaatkan.

(b) State two problems that may arised by having shared data base.Nyatakan dua masalah yang mungkin timbul dengan mempunyai perkongsian pangkalan data.

Source Year Level

Bloom

SPM 2007

30. (a) Define Database Management System (DBMS).Berikan definisi Sistem Pengurusan Pengkalan Data (SPPD).

(b) State three advantages of using Databases Management System (DBMS). Senaraikan tiga kelebihan menggunakan Sistem Pengurusan Pengkalan Data (SPPD).

Source Year Level

Bloom

N.SEMBILAN

2009

Section C

6.2.2.1 State the relationship between attribute (field), row (record) and relation (file).

Section A

21. Figure 10 shows a school data baseRajah 10 menunjukkan pangkalan data sekolah.

Figure 10Rajah 10

Name : Namakan :

i) A : _______________________ ii) B : _______________________

40

Studen IDID PelajarName

NamaClassKelas2396Azahrina5A13975Saraswathy5A139

81Tommy5A24782Wahid5A2A

B

Source Year Level

Bloom

SPM 2007

Section B

30 The following are attributes for a library database.Berikut adalah atribut untuk pangkalan data perpustakaan.

(a) (i) Group the attributes into two related tables.Kumpul atribut itu ke dalam dua jadual yang berhubungan.

(ii) Draw a line to show the relationship between the two tables.Lukis satu garisan untuk menunjukkan hubungan di anlara kedua-dua

jadual itu.

(b) State the type of relationship. Nyatakan jenis hubungan itu.

Source Year Level

Bloom

SPM 2009

Section C

6.2.2.2 Define the primary key and foreign key.

Section A

1. State whether the following statement is True or False.Nyatakan sama ada pernyataan berikut Benar atau Palsu.

Foreign keys are the field that uniquely represents each record in a table.Kunci asing merupakan medan unik yang mewakili setiap rekod dalam jadual.False / Palsu

Source Year

Level

Bloom

KEDAH 2010

24. Since the field, FriendID, can uniquely identify each friend, the two tables are said to be

related

by the FriendID field in the FRIEND_INFO table . What is FriendID in the FRIEND_INFO

table?

41

book titletajuk buku

supplier IDID pembekal

book authorpengarang buku

book IDID buku

Supplier addressalamat pembekal

Supplier namenama pembekal

Medan FriendID, boleh mengenalpasti secara unik setiap kawan, rajah bawah dikatakan

ada perhubungan di antara satu sama lain melalui FriendID di medan FREND_INFO.

Apakah FriendID ?

Figure 1 Rajah 1

A. Foreign Key Kunci Asing

B. Primary Key Kunci Primer

C. Secondary Key Kunci Sekunder

D. Unique Key Kunci Unik

Source Year Level

Bloom

PERLIS 2008

24. Figure 7 shows two tables in a database.

Rajah 7 menunjukkan dua jadual dalam satu pangkalan data.

FIGURE 7 RAJAH 7

State a foreign key in table Contact.

Nyatakan kunci asing dalam jadual Contact.

Source Year Level BloomTERANGGAN

U2008

19. A _____________ is a field (or fields) that points to the ____________of another table. The purpose of it is to ensure the integrity of the data.

___________ialah medan yang merujuk kepada___________di jadual yang lain. Tujuannya adalah untuk memastikan integriti /kebolehpercayaan sahan data tersebut.

Source Year Level

Bloom

PAHANG

2009

42

FRIEND_INFO

FriendID NameAddressDate_of_Birth

PHONE_NUM

FriendID Phone_Number

25. Table 5 shows marks of April Monthly Test for students in Puan Kartini’s class.Jadual 5 menunjukkan markah bagi Ujian Bulan April untuk pelajar di dalam kelas Puan Kartini.

Based on the Table 5, the IdentityCardNumber field is used as _____________ to uniquely identify each student in the database.

Berdasarkan Jadual 5, medan IdentityCardNumber digunakan sebagai ____________ untuk mengenalpasti setiap pelajar secara unik di dalam pangkalan data.

Source Year Level

Bloom

KEDAH 2009

23. A field that uniquely represents each record in a table and must not have null value is known as a

_________________________

Medan yang mewakili setiap rekod di dalam jadual dengan unik dan tidak boleh mempunyai nilai nul dikenali sebagai __________________________.

Source Year Level

Bloom

N.SEMBILAN

2009

Question 24 based on Figure 11 .Soalan 24 merujuk kepada Rajah 11

43

Figure 11 Rajah 11

24. Field for Customer_ID was declared as ________________________. The values in this field must be uniqueMedan Customer_ID telah diiisytihar sebagai____________________. Nilai-nilai dalam medan ini mestilah unik.

Source Year Level

Bloom

PERAK 2008

25. Since the field, FriendID, can uniquely identify each friend, the two tables are said to

be related by the FriendID field in the FRIEND_INFO table . What is FriendID called?

Medan FriendID, boleh mengenalpasti secara unik setiap kawan, rajah di bawah

dikatakan ada perhubungan diantara satu sama lain melalui FriendID di medan

FRIEND_INFO. FriendID dipanggil apa?

Figure 4 Rajah 4

E. Foreign Key Kekunci Asing

F. Primary Key Kekunci Primer

G. Secondary Key Kekunci Sekunder

H. Identical Key Kekunci Identikal

Source Year Level

Bloom

PERLIS 2009

25. Figure 6 shows two tables in a database. Rajah 6 menunjukkan dua jadual dalam satu pangkalan data.

Figure 6 Rajah 6

State a foreign key in table CONTACT.

44

FRIEND_INFO

FriendIDNameAddressDate_of_Birth

PHONE_NUM

FriendIDPhone_Number

Nyatakan kunci asing dalam jadual CONTACT.

Source Year Level

Bloom

PERAK 2009

23. Table 4 shows some terms used in information and communication technology.Jadual 4 menunjukkan sebahagain terma yang digunakan dalam teknologi maklumat dan komunikasi.

secondary keykunci sekunder

DMBSSPPD

foreign keykunci asing

databasepangkalan data

Table 4 Jadual 4

Choose the terms shown in Table 4 which match the following statements :Pilih terma yang ditunjukkan dalam Jadual 4 yang sepadan dengan pernyataan berikut.

i) A collection of data organised in a systematic wayKoleksi data yang diurus secara sistematik.

ii) A field key that must match a primary key value in another tableMedan yang diisi mesti dipadankan dengan nilai kunci primer dalam jadual ini.

Source Year Level

Bloom

SPM 2008

Section B

Section C

6.2.2.3 State the importance of the primary key.

Section A

10. What is the importance of primary key?Apakah kepentingan kekunci utama?A A primary key allows duplicating records

Kekunci utama membenarkan penyalinan rekod

B A primary key allows data to be entered repeatedlyKekunci utama membenarkan data dimasukkan berulang kali.

C A primary key can use any values includes null values Kekunci utama boleh menggunakan sebarang nilai termasuk nilai null

D A primary key ensures data integrity by uniquely identifying each record.Kekunci utama memastikan integriti data dengan mengenalpasti setiap rekod secara unik.

Source Year

Level

Bloom

PAHANG 2008

Section B

30. Figure 9 shows a table with some data that was input by a teacher.

Rajah 9 menunjukkan satu jadual dengan beberapa data yang dimasukkan oleh seorang guru.45

Based on the Figure 9:

Berdasarkan Rajah 9:

(a) State numbers of the field and identify the field that can be used to be a Primary Key.

Nyatakan bilangan medan dan kenalpasti medan yang sesuai untuk dijadikan sebagai Kunci Utama

(b) State two importance of primary key.

Nyatakan dua kepentingan kunci utama.

Source Year Level

Bloom

KELANTAN

2009

30 Figure 10 below shows two tables created in the Student Information System atSMK Tanjung Tiga.Rajah 10 di bawah menunjukkan dua jadual yang dibina dalam Sistem Maklumat

46

Figure 9 Rajah 9

Murid di SMK Tanjung Tiga.

Figure 10 Rajah 10

Based on Figure 10 above, answer the following questions.Berdasarkan Rajah 10 di atas, jawab soalan-soalan berikut.

(a) State the importance of Primary Key in both tables.Nyatakan kepentingan Primary Key dalam kedua-dua jadual tersebut.

(b) Database above is used to store students’ information and to record students’ parents information. Give two benefits of using database.Pangkalan data di atas digunakan untuk menyimpan maklumat pelajardan merekod maklumat ibubapa pelajar. Berikan dua kelebihan menggunakan pangkalan data.

Source Year Level

Bloom

PERAK 2009

Section C

1. Figure 14(a) and Figure 14(b) show two tables created in the TechCom Information System at TechCom Sdn Bhd.Rajah 14(a) dan Rajah 14(b) menunjukkan dua jadual yang dibina di dalam sistem maklumat TechCom di TechCom Sdn Bhd.

47

Based on Figure 14(a) and Figure 14(b),Berdasarkan Rajah 14(a) dan Rajah 14(b),(b) State two the importance of the function of primary key.

Nyatakan dua kepentingan fungsi kekunci primer.

It prevents null values being entered in the unique field.

A primary key ensures data integrity by uniquely identifying each record.

It helps to avoid duplicating records.

33. Figure 13 shows an interface of an automated library system of SMK Indah. Rajah 13 menunjukkan antara muka sistem perpustakaan berautomasi bagi SMK lndah.

SMK IndahLibrary Management System

Book Information

Book ID QuantityTitle AuthorEdition YearPublisherSynopsis

Update Menu Insert Delete

Figure 13 Rajah 13

Based on Figure 13:Berdasarkan Rajah 13:

a) Identify one data manipulation button and explain its function. [2 marks]KenaI pasti satu butang manipulasi data dan terangkan jungsinya.

b) Which field is the primary key? Medan manakah yang merupakan kekunci primer?

Justify your answer.48

Figure 14(a) / Rajah 14(a)

Figure 14(b) / Rajah 14(b)

Berikan justifikasi bagi jawapan anda.[4 marks]

Source Year Level

Bloom

SPM 2007

6.2.2.4 Differentiate between the primary key and foreign key.

Section A

1. Figure 14(a) and Figure 14(b) show two tables created in the TechCom Information System at TechCom Sdn Bhd.Rajah 14(a) dan Rajah 14(b) menunjukkan dua jadual yang dibina di dalam sistem maklumat TechCom di TechCom Sdn Bhd.

Based on Figure 14(a) and Figure 14(b),Berdasarkan Rajah 14(a) dan Rajah 14(b),(a) State the primary key and foreign key fields in the Figure 14(b).

Nyatakan medan kekunci primer dan kekunci asing pada Rajah B.

primary key = Service ID

foreign key = Customer ID

Source Year

Level

Bloom

PAHANG 2010

2. Figure 15 shows table of students’ address and students’ order used in SMK Putrajaya BookShop System. Rajah 15 menunjukkan jadual alamat murid dan pesanan murid yang digunakan dalam Sistem Kedai Buku SMK Putrajaya.

49



Table: Student AddressJadual: Alamat Murid

Table: OrderJadual: Pesanan

Figure 15Rajah 15

(i) Name the primary key field for Student Address table. Namakan medan kunci primer bagi jadual Alamat Murid. StudentID(ii) Name the foreign key field for Order table. Namakan medan kekunci asing bagi jadual Pesanan.

StudentID

Source Year

Level

Bloom

PUTRAJAYA 2010

3. Figure 12 shows the relationship between two tables of an information system.Rajah 12 menunjukkan hubungan antara dua jadual untuk suatu sisiem maklumat.

Figure 12 / Rajah 12Based on Figure 12,from STUDENT table, state the function of:Berdasarkan Rajah 12, daripada jadual STUDENT, nyatakan fungsi bagi:(i) primary key / kunci primer student id(ii) foreign key /kunci asing class id

50

Source Year

Level

Bloom

SPM 2010

24. Which of the following statement about primary and foreign key values is true?Manakah penyataan yang benar berkait dengan kunci utama dan kunci asing?

A. Only primary key values must be uniqueHanya kunci utama mesti mempunyai nilai unik

B. Only foreign key values must be uniqueHanya kunci asing mesti mempunyai nilai unik

C. Both primary and foreign key values must be uniqueKedua-dua kunci iaitu utama dan asing mesti mempunyai nilai unik

D. Neither primary nor foreign key values must be uniqueSalah satu samada kunci utama atau kunci asing mesti mempunyai nilai unik

Source Year Level

Bloom

WPKL 2009

24. Which of the following statement about primary and foreign key values is true?

Pernyataan yang manakah benar tentang kekunci primer dan kekunci asing?

A. Only primary key values must be unique

Nilai kekunci primer mestilah unik

B. Only foreign key values must be unique

Nilai kekunci asing mesitlah unik

C. Both primary and foreign key values must be unique

Kedua-dua nilai kekunci primer dan kekunci asing mestilah unik

D. Either primary or foreign key values must be unique

Sama ada kekunci primer atau kekunci asing mestilah unik

Source Year Level

Bloom

PERLIS 2009

Section B

51

Source Year Level

Bloom

TERENGGANU 2009

52

30. Figure 14 (a) and 14 (b) shows two different types of hierarchy of data.Rajah 14 (a) dan 14 (b) menunjukkan dua jenis hirarki data.

FIGURE 14 (a) RAJAH 14(a)

FIGURE 14 (b) RAJAH 14(b)

(a) State the TWO types of hierarchy of data above. [2 marks]Nyatakan DUA jenis hiraki bagi data di atas. [2 markah]

(b) Differentiate between the primary key and foreign key. [2 marks]Bezakan antara kekunci primer dan kekunci asing [2 markah]

Section C

1. Table 7 explains the computerised plan of a flower shop.Jadual 7 menerangkan pelan berkomputer bagi sebuah kedai bunga.

Bouquet Flora is a shop that sells many types of flowers and gardening accessories. Alice is hired to build a computerised database to manage its sales.Bouquet Flora adalah sebuah kedai yang menjual berbagai jenis bunga dan peralatanperkebunan. Alice diupah untuk membina pangkalan data berkomputer untuk mengurus jualan.Some of the data need to be stored in the database include:Berikut merupakan antara data yang perlu dimasukkan ke dalam pangkalan data:

- Product code ( Kod Barangan)- Product name ( Nama Barangan)- Supplier ID (ID Pembekal)- Supplier Name ( Nama Pembekal )- Supplier Address (Alamat Pembekal)- Product Price (Harga Barang)

Table 7 / Jadual 7Based on Table 7 / Berdasarkan Jadual 7,(i) Give ONE different between primay key and foreign key.

Berikan SATU perbezaan antara kunci primer dan kunci asing.- Primary key can contain only unique value but foreign key may contain duplicate value.- Primary key cannot accept null value but foreign key can be null value.- Any relevant answer.

53

Source Year

Level

Bloom

KEDAH 2010

31.

(a) Define the meaning of database. Nyatakan maksud pangkalan data [2 marks]

[2 markah](b) Name software P. Namakan perisian P [2 marks]

(c ) Give two differencess between the primary key and foreign key. Berikan dua perbezaan antara kekunci utama dengan kekunci asing.

Source Year

Level

Bloom

PAHANG 2008

33. Table 10 (a), 10 (b) and Figure 13 show the tables and their respective field in an information system.Jadual 10 (a), 10 (b) dan Rajah 13 menunjukkan jadual dan medan dalam sistem maklumat.

Customer_Table

Table 10 (a) Jadual 10 (a)

Order_Table

54

Software PCUSTOMER: Table

Customer _IDNamePhone _NoA001Ali095662193A002Suraya09563

4652A003Leong095687678

SERVICE: TableService

_IDDateCustomer_ID15/1/08A001211/2/08A002312/2/08A002

Foreign KeyKekunci Asing

Primary KeyKekunci Utama

Table 10 (b) Jadual 10 (b)

Based on Table 10 (a) and Table 10 (b) :Berdasarkan jadual 10 (a) dan jadual 10 (b) :

a. i) State the suitable primary key for Customer_Table.Nyatakan kunci primer yang sesuai untuk “Customer_Table”

[ 1 mark ]ii) Justify the answer in a (i).

Beri justfikasi bagi jawapan dalam a(i)[ 2 mark ]

b. State the Data Type for the field :Nyatakan jenis data untuk medan :

i) Productii) Date of Birth

[ 2 marks ]

Figure 13 Rajah 13

Based on Figure 13 : Berdasarkan Rajah 13 :

c. Explain the difference between CustID in Customer_Table and CustID in Order_Table.Jelaskan perbezaan di antara “CustID” dalam “Customer Table” dan “CustID” di dalam “Order_ Table.

[ 2 marks ]Source Year Lev

elBloom

JOHOR 2009

6.2.2.5 State the importance of relationship between the primary key and foreign key.

55

Section A

14. Which of the followings are the importance of the relationship between primary key and foreign key?Penyataan-penyataan yang manakah merupakan kepentingan perhubungan di antara kekunci primer dan kekunci asing?

I. The primary key of one table becomes a foreign key of the other tableKekunci primer pada satu jadual menjadi kekunci asing pada satu jadual yang lain.

II. By matching a foreign key with a primary key, the data does not need to be entered repeatedly.Dengan menyuaikan kekunci asing dengan kekunci primer, data tidak perlu dimasukkan berulang kali.

III. A primary key makes creating Queries, Forms and Reports easier.Kekunci primer memudahkan pembinaan Kueri, Forms dan Laporan.

IV. A primary key improves data performance by relating smaller tables into meaningful databases.Kekunci primer meningkatkan prestasi data dengan menghubungkait jadual-jadual yang kecil menjadi pangkalan data yang bermakna.

A. I, II and III I, II dan IIIB. I, III and IV I, III dan IVC. II, III and IV II, III dan IVD. I, II, III and IV I, II, III dan IV

22. Connections between fields of related tables having common values are called ___________.Perkaitan antara medan dalam jadual yang berhubung yang mengandungi nilai yang sama dikenali sebagai _________.

Source Year Level

Bloom

PAHANG

2009

Section B

Section C

6.2.3.1 Define the following database objects/ tools: Table, form, query, report.

Section A

25 Figure 8 shows two types of database object.

56


(A)2008

Section B

Section C

6.2.3.2 Identify table, query, form and report as database objects/ tools.

Section A

1. Figure 13 shows a database screen. Rajah 13 menunjukkan skrin pangkalan data.

Figure 13 / Rajah 13

Based on Figure 13, which of the following describes the screen?Berdasarkan Raiah 13, antara yang beriku.t yang manakah menerangkan skrin itu?

8(a) 8(b)

FIGURE 8

Identify object S and object T

(a) S

(b) T

57

A Form / Borang B Switchboard / Papan suisC Report / Laporan D Design view / Pandangan rekabentukA

Source Year

Level

Bloom

SPM 2010

Source Year

Level

Bloom

PAHANG 2008

Source Year Level

Bloom

TERENGGANU 2009

23. A request for information from a database is called __________.Permintaan terhadap maklumat dalam pangkalan data dikenali sebagai___________.

Source Year Level

Bloom

PAHANG

2009

Section B

Section C

6.2.4.1 List the basic operations of data manipulation: i. Update, ii. Insert, iii. Delete, iv. Retrieve, v. Sort, vi. Filter and vii. Search

Section A

3. State whether the following statement is True or FalseNyatakan sama ada pernyataan berikut Benar atau Palsu.Delete, Filter, Insert, Update and Search are basic operations of data manipulation.

Objects Bar Function

14. Query

A A collection of records that identify a category of data, such as Customers, Orders, or Inventory.

15. Report B Use to enter new information, to edit or remove existing information or to locate information.

16. Form C Used to locate information, to view, change or analyze it in various ways.

17. Table DTypically used to summarize, organize and analyze information in order to express a particular point of view to specific audience.

58

Hapus, Saring, Sisip, Kemaskini dan Penggelintaran adalah operasi asas dalammanipulasi data.TRUE

Source Year

Level

Bloom

N. SEMBILAN 2010

23. Basic operations of data manipulation is Update, Insert, Delete, Retrieve, Sort, Filter and ________________

Operasi asas dalam manipulasi data ialah kemaskini, menyelit, menghapus, mencapai, mengisih, menapis dan_____________.

Source Year

Level

Bloom

PAHANG 2008

24. The following are the basic operations of data manipulation.Yang berikut adalah 4 operasi utama dalam manipulasi data.

UpdateKemaskini

InsertMasuk/Tambah

SortSusun

Search Cari

FilterTapis/Saring

Table 2 and Table 3 shows the results manipulated from Table 1. Jadual 2 dan Jadual 3 menunjukkan keputusan yang dimanipulasi daripada Jadual 1.

Index Number Name GenderA0063001 Mohd Zukri MaleA0063002 Azmin Ahmad MaleA0063003 Hamidah Ali FemaleA0063004 Azimah Kasim Female

Table 1 Jadual 1

Index Number Name GenderA0063004 Azimah Kasim FemaleA0063002 Azmin Ahmad MaleA0063003 Hamidah Ali FemaleA0063001 Mohd Zukri Male

Table 2 Jadual 2

Index Number Name GenderA0063001 Mohd Zukri MaleA0063002 Azmin Ahmad Male

Table 3 Jadual 3

Choose the operations used to Table 1 to obtain the results as shown in Table 2 and Table 3.Pilih operasi yang digunakan pada Jadual 1 untuk mendapatkan keputusan seperti di dalam Jadual 2 dam Jadual 3.

TableJadual

OperationOperasi

(a) Table 259

Jadual 2(b) Table 3

Jadual 3

Source Year

Level

Bloom

PENANG 2008

12. Give two basic operations of data manipulation in database.

i. ……………………………………

ii. ……………………………………

Source Year

Level

Bloom


13. Data manipulation in database refers to the operations of accessing, locating, organizing, modifying and managing data contained in the database. [TRUE/FALSE]

Source Year

Level

Bloom


24. Data manipulation operations include the ability to insert, delete, update, sort and filter data in a database. TABLE 5 shows a list of Form 2 students in year 2008.

TABLE 5

As an ICT student, you are asked to change the classes in year 2008 to Form 3 classes this year.

What operation would you use to perform the task?

Source Year Level

Bloom

60

PCGHS 2009

24. The_________ operation is used for removing records from a database table._____________operasi yang digunakan untuk mengeluarkan rekod dalam jadual pangkalan data.

Source Year Level

Bloom

PAHANG

2009

24 State whether the following statement is True or False.Nyatakan sama ada pernyataan berikut Benar atau Palsu.

Delete, Filter, Insert, Upgrade and Search are basic operations of data manipulation. Hapus, Saring, Sisip, Naik gred dan Penggelintaran adalah operasi asas dalam manipulasi data.

Source Year Level

Bloom

SPM 2009

Section B

Section C

31. Figure 1 shows an interface of an automated system of Care Medical Centre.Rajah 1 menunjukkan antara muka sistem berautomasi bagi Pusat Perubatan Care.

Rajah 1

Based on Figure 1, answer the following question:Berdasarkan Rajah 1, jawab soalan-soalan berikut:

a) Explain two benefits of having an automated system for CARE Medical Centre.Jelaskan dua kebaikan mempunyai sistem berautomasi bagi Pusat Perubatan Care.

[2 marks]

b) Which field is the primary key? Justify your answer.Medan manakah yang merupakan kekunci primer? Berikan justifikasi bagi jawapan anda.

61

[3 marks]

c) Explain the function of ‘Update’ and ‘Delete’ button.Terangkan fungsi butang manipulasi ‘Update’ dan ’Delete’.

[2 marks]

Source Year Level

Bloom

JOHOR 2008

6.2.4.2 State the usage of basic operations in data manipulation.

Section A

List one or more records using certain conditionMenyenaraikan satu atau lebih rekod menggunakan

keadaan tertentu

Statement 5

1. Statement 5 represents the usage of ________________ in data manipulationKenyataan 5 merupakan penggunaan ________________ dalam data manipulasiA. ModifyB. FilterC. UpdateD. Sort

Source Year

Level

Bloom

SABAH 2010

4. Table 5 shows some basic operations of data manipulation.Jadual 5 menunjukkan beberapa operasi asas dalam manipulasi data.

Table 5 /Jadual 5Based on Table 5, state the operation for:Berdasarkan Jadual 5, nyatakan operasi bagi:(i) X (ii) Y(i) Filter (ii) Insert

Source Year

Level

Bloom

PAHANG 2010

1. Figure 8(a) shows a table in a database and Figure 8(b) shows the output of data 62

manipulation in the table Query. Rajah 8(a) menunjukkan satu jadual dalam pangkalan data dan Rajah 8(b) menunjukkan hasil manipulasi data tersebut dalam jadual Query.



Identify the basic operation of data manipulation that has been done.Kenalpasti satu operasi asas dalam manipulasi data yang telah dilakukanSORTING

Source Year

Level

Bloom

KELANTAN 2010

25 The basic operation used to select a few records from a database isOperasi asas yang digunakan untuk memilih beberapa rekod daripada pangkalan data adalahA index indeks

B delete hapus

C filter saring

D update kemas kini

Source Year Level

Bloom

SPM 2009

Section B

Section C

33. Figure 13 shows an interface of an automated library system of SMK Indah. Rajah 13 menunjukkan antara muka sistem perpustakaan berautomasi bagi SMK lndah.

SMK IndahLibrary Management System

Book Information

Book ID Quantity63

Title AuthorEdition YearPublisherSynopsis

Update Menu Insert Delete

Figure 13 Rajah 13

Based on Figure 13:Berdasarkan Rajah 13:

a) Identify one data manipulation button and explain its function. [2 marks]KenaI pasti satu butang manipulasi data dan terangkan jungsinya.

b) Which field is the primary key? Medan manakah yang merupakan kekunci primer?

Justify your answer.Berikan justifikasi bagi jawapan anda.

[4 marks]Source Year Lev

elBloom

SPM 2007

6.3.1.1 Describe the phases of systems development: i. Analysis, ii. Design, iii. Implementation, iv. Testing, v. Documentation and vi. Maintenance

Section A

1. Table 3 below shows phases of system development.Jadual 3 di bawah menunjukkan fasa dalam pembangunan sistem.A AnalysisB ImplementationC MaintenanceTable 4 / Jadual 4Based on Table 3 , write A, B or C for the following activities.Berdasarkan Jadual 3, tulis A,B atau C untuk aktiviti berikut.i) The phases where a system is created.

Sistem dibina pada fasa ini.ii) Involves checking, changing and enhancing to improve its performance.

Melibatkan pemeriksaan, perubahan dan penambahbaikan untuk meningkatkan lagi mutupersembahan.

iii) Determine the user’s wants, needs, and requirements.Mengenalpasti kemahuan, kehendak dan pengguna.B / C / A

Source Year

Level

Bloom

PERLIS 2010

2. State the name of the phase in the system developmentFigure 10 shows program development phases.

Rajah 10 menunjukkan fasa pembangunan program .

64

Figure 10Rajah 10

Based on Figure 10 : Name the phaseBerdasarkan Figure 10 : Namakan fasa

(i) M (ii) N

Problem AnalysisCoding

Source Year

Level

Bloom

SELANGOR 2010

3. The following is a text on system development for a company. Berikut adalah teks tentang pembinaan sistem untuk sebuah syarikat.

Ahmad is a system analyst for Atira Company. His company has decided to rebuild the company’s Information System. He has been asked to handle the work. For a start he has planned to study how the current system works by reviewing old documents. In order to determine what users want he has decided to do some interviews with the users…Ahmad ialah seorang juruanalisa sistem bagi Syarikat Atira. Syarikatnya telah bercadang untuk membina semula sistem maklumat syarikat. Beliau telah ditugaskan untuk menguruskan kerja tersebut. Sebagai permulaan beliau bercadang untuk melihat keadaan sistem sediaada dengan meneliti dokumen-dokumen lama. Untuk menentukan kehendak pengguna beliau bercadang menjalankan temuramah dengan pengguna-pengguna…

.Based on the statement above /Berdasarkan pernyataan di atas,State the Phase of System development that takes place in the scenario.Nyatakan fasa pembinaan sistem yang berlaku di dalam situasi di atas.ANALYSIS PHASE

Source Year

Level

Bloom

KELANTAN 2010

4. State whether the following statement is True or False.

Documentation Phase

Program Design Phase

Phase N

Testing and debugging Phase

Phase M

65

Nyatakan sama ada pernyataan berikut Benar atau Palsu.

The Implementation Phase in the system development refers to the written material generated throughout all the phases of the system development.Fasa Pelaksanaan dalam pembinaan sistem merujuk kepada bahan bertulis yang dihasil sepanjang fasa pembinaan sistem.FALSE

Source Year

Level

Bloom

KELANTAN 2010

07 Rearrange the phases of system development below with the correct hierarchy.

Susun semula fasa-fasa pembangunan sistem di bawah mengikut susunan yang betul

I. Design Rekabentuk

II. Implementation Implementasi

III. Maintenance Penyelenggaraan

IV. Documentation Dokumentasi

V. Analysis Analisis

VI. Testing Percubaan

A. I, V, II, VI, IV, III

B. V, I, II, VI, IV, III

C. V, I, II, VI, III, IV

D. II, V, I, VI, IV, III

Source Year Level BloomKL 2008

21(a) Problem analysis phase identifies the data input, processing and output for the program. [ T / F ]

21(b) In data manipulation, the use of update operation is to display the records that match our specifications or needs. [ T / F ]


(A)2008

25. Table 6 shows some term used in System Development Phases.Jadual 6 menunjukkan sebahagian terma yang digunakan dalam Fasa Pembangunan Sistem.

AnalysisAnalisis

DesignRekabentuk

ImplementationImplementasi

DocumentationDokumentasi

MaintanencePenyelenggaraan

Table 6 Jadual 6

Choose the terms shown in Table 6 which match the following statements.Pilih terma yang ditunjukkan dalam Jadual 6 yang sepadan dengan pernyataan berikut.

(i) During this phase, system developers will create database using database software.

66

Semasa fasa ini, pembangun sistem akan membina pangkalan data menggunakan perisian pengkalan data.

(ii) The system developers continue to monitor the system performance and make changes when needed.

Pembangun sistem akan meneruskan untuk memerhatikan prestasi sistem yang dibangunkan dan akan membuat perubahan apabila diperlukan.

Source Year Level

Bloom

KELANG 2009

25 During phase P in the development of SMS Information System, the following activities are carried out.

- receive request for modification due to system failure and to enhance part of the system

- fix failure and enhance system- deliver new version

What is phase P?


25. The phases of system development are analysis, ____________________, implementation, ______________________, documentation and _____________________.Fasa sistem pembangunan terdiri dari analisis,__________________, implimentasi, ________________, dokumentasi dan _________________

Source Year Level

Bloom

WPKL 2009

25. The following shows six main phases in information system development.

Berikut merupakan enam fasa utama dalam pembangunan sistem maklumat.

Problem Analysis à Program Design à Phase X à Testing à Documentation à Phase Y

State Nyatakan

(a) Phase X Fasa X

(b) Phase Y Fasa Y

Source Year Level

Bloom

N.SEMBILAN

2009

24. Rearrange the phases of system development below with the correct hierarchy. Susun semula fasa-fasa pembangunan sistem di bawah mengikut susunan yang betul.

I II III IV V VIDesign Implementatio Maintenance Documentatio Analysi Testing

67

Rekabentuk

nPelaksanaan

Penyelenggaraan

nDokumentasi

sAnalisis

Percubaan

A. I, V, II, VI, IV, and III I, V, II, VI, IV, dan IIIB. V, I, II, VI, IV, and III V, I, II, VI, IV, dan IIIC. V, I, II, VI, III, and IV V, I, II, VI, III, dan IVD. II, V, I, VI, IV, and III II, V, I, VI, IV, dan III

Source Year Level

Bloom

PERAK 2009

25. The following list are activities carried out by Mary and her team when developing the school’s library information system.Aktiviti berikut dilaksanakan oleh Mary dan pasukannya dalam membangunkan sistem maklumat perpustakaan sekolah.

State the name of the phase in the system developmentNyatakan nama fasa itu dalam pembangunan sistem.

Source Year Level

Bloom

SPM 2008

Section B

Section C

31. Ahmad works as a system analyst in the XYZ Company. He has been instructed to upgrade the

company’s Information System in order to solve various problems faced by users as well as to

strengthen the company in line with the present situation. One thing that has been done by Ahmad is

to construct interviews among users of XYZ Company. He completes his task by finishing all

phases in System Development and his boss is very satisfied with his work.

(a) Based on the underline statement, state the phase involved in System Development and describe another step that can be done by Ahmad in that phase.

68

Interview the librarians, teacher-in-charge of the library and the principalMenemuramah pustakawan, guru pusat sumber dan pengetua sekolah

Distribute questionnaires to 50 students chosen at randomMengedar soal selidik kepada 50 pelajar secara rawak

Prepare a report for the system requirementMenyediakan laporan untuk keperluan sistem

[Lihat sebelah(b) In order to make sure that the new Information system in the XYZ Company is always in a

good condition, the system need to be maintained. Three types of Maintenance are Corrective

Maintenance, Perfective Maintenance and Preventive Maintenance.

Explain the Corrective Maintenance and Preventive Maintenance.

Source Year

Level

Bloom

KELANTAN 2008

33. Figure 10 shows the phases used to develop Student Information System of SMK Ambangan.Rajah 10 menunjukkan fasa-fasa yang digunakan untuk membangun Sistem Maklumat Pelajar SMK Ambangan.

Figure 10 Rajah 10

Based on Figure 10,Berdasarkan Rajah 10,

a) Explain briefly Phase P in system development. [ 3 marks ]

69

Terangkan secara ringkas Fasa P dalam pembangunan sistem.

b) Describe two activities during Phase Q. [ 4 marks]Huraikan dua aktiviti semasa Fasa Q.

6.3.2.1 Identify a project.

Section A

Section B

Section C

6.3.2.2 Identify the project requirements.

Section A

Section B

Section C

6.3.2.3 Classify project requirements into two tables.

Section A

Section B

2. Figure 15 shows the field of the Students database system Rajah 15 menunjukkan medan satu sistem pangkalan data pelajar.

Figure 15Rajah 15

Based on Figure 15:Berdasarkan rajah 15:(i) Identify the primary key and state the function.

Kenalpasti kunci utama dan nyatakan fungsinya.(ii) Name another two Fields that can be included in Table 2.

Namakan dua medan lain yang boleh dimasukkan dalam table 2.(i) Primary key : studentID (1M)

Function : to ensure that no two records in database contain the samevalue for that field. (ii) Second telephone number , email address

or others that related

Source Yea Lev Bloom70

r elSELANGOR 201

0

Section C

33. Read carefully the problem statement in the table given below. You have to understand

the problem in order to develop a database based on the task given.

Baca kenyataan masalah dalam jadual di bawah dengan teliti. Fahami masalah

tersebut bagi tujuan pembinaan pengkalan data berdasarkan tugasan yang diberi.

a). Identify the problem and project requirements on the situation above. [3 marks]

Kenalpasti masalah dan keperluan bagi projek bagi situasi yang dinyatakan di

atas. [3 markah]

b). Based on problem statement above, draw two table that include the primary key in

each table. [4 marks]

Berdasarkan kenyataan masalah di atas, lukiskan 2 jadual yang

mengandungi kunci utama bagi setiap jadual. [4 markah]Source Year Level Bloom

HULU LANGAT 2009

6.3.2.4 Design database tables.

Section A

Section B

Section C

6.3.2.5 Create a database.

Section A

71

You are given a task to develop a database of your friends’

telephone numbers. The data will store in your database are

FriendID, Name, Address, Phone Numbers and Date of Birth.

Anda diberi tugasan untuk membangunkan satu pangkalan data bagi

senarai nombor telefon sahabat anda. Data yang perlu dimasukkan ke

dalam pangkalan data tersebut adalah FriendID, Name, Address,

Phone Numbers and Date of Birth.

Section B

Section C

6.3.2.6 Create two tables that include the primary key in each table.

Section A

Section B




jadual itu.

(c) State the type of relationship. Nyatakan jenis hubungan itu.

Source Year Level

Bloom

SPM 2009

Section C

6.3.2.7 Build a relationship between two tables.

Section A

1. The following are attributes for a library database.Berikut adalah atribut untuk pangkalan data perpustakaan.

(a) (i) Group the attributes into two related tables. [2 marks]Kumpul atribut itu ke dalam dua jadual yang berhubungan. [2 markah]

(ii) Draw a line to show the relationship between the two tables. [1 mark]Lukis satu garisan untuk menunjukkan hubungan di antara kedua-dua jadual itu.

(b) State the type of relationship. [1 mark]Nyatakan jenis hubungan itu.

72




book IDID buku



a(i)

(ii) Many to many relationship.

Source Year

Level

Bloom

PAHANG 2010

2. The following are the attributes for a newspaper databaseBerikut ini adalah atribut untuk pangkalan data akhbar

a. (i) Group the attributes into two related tables Kumpulan atribut menjadi dua jadual yang berkaitan

(iii) Draw a line to show the relationship between the two tablesTarik garis untuk menunjukkan hubungan antara dua jadualState the types of relationship / Nyatakan jenis hubungan

(a) (i) and (ii) NEWSPAPER SUPPLIERnewspaper ID supplier ID

Newspaper name supplier nameNewspaper Company supplier address// supplier ID // newspaper ID

b) 1 to many

Source Year

Level

Bloom

SABAH 2010

4. Figure 10 shows two tables in a database.

Rajah 10 menunjukkan dua jadual dalam pangkalan data.

73

newspaper ID supplier ID supplier address

Newspaper name supplier name Newspaper

Company

a) Identify a field name from both tables to make a relationship. Kenalpasti satu medan daripada kedua-dua jadual bagi mewujudkan hubungan.b) State the total number of fields in Table2

Nyatakan bilangan medan dalam Jadual2NO.PELAJAR / 4Source Yea

rLevel

Bloom

KELANTAN 2010

Section B




jadual itu.

(d) State the type of relationship. Nyatakan jenis hubungan itu.

Source Year Level

Bloom

SPM 2009

Section C

1. Table 7 explains the computerised plan of a flower shop.Jadual 7 menerangkan pelan berkomputer bagi sebuah kedai bunga.

Bouquet Flora is a shop that sells many types of flowers and gardening accessories. Alice is hired to build a computerised database to manage its sales.Bouquet Flora adalah sebuah kedai yang menjual berbagai jenis bunga dan peralatanperkebunan. Alice diupah untuk membina pangkalan data berkomputer untuk mengurus jualan.Some of the data need to be stored in the database include:

74




book IDID buku



Figure 10Rajah 10

Based on Figure 10,Berdasarkan Rajah 10,

Berikut merupakan antara data yang perlu dimasukkan ke dalam pangkalan data:

- Product code ( Kod Barangan)- Product name ( Nama Barangan)- Supplier ID (ID Pembekal)- Supplier Name ( Nama Pembekal )- Supplier Address (Alamat Pembekal)- Product Price (Harga Barang)

Table 7 / Jadual 7Based on Table 7 / Berdasarkan Jadual 7,(i) Create TWO tables for Supplier and Product based on the fields given and show the relationship.

Bina DUA jadual untuk Pembekal dan Barangan berasaskan medan serta tunjukkan perhubungannya.

(ii) Name the database tool Alice uses to get a summary report on a specific Supplier Name.Nyatakan alat pangkalan data yang digunakan oleh Alice untuk menghasilkan ringkasanlaporan Nama Pembekal yang spesifik.Query / Kuiri

1. Tables 4 shows the data for each patient stored in a patient’s file in Mahawangi Specialist CentreSystem (MSCS).Jadual 4 menunjukkan data bagi setiap pesakit yang disimpan dalam fail pesakit di Sistem PusatPakar Mahawangi ( SPPM).

Source Year

Level

Bloom

KEDAH 2010

Table 4 / Jadual 4

75

Based on Table 4, answer the following questions. / Berdasarkan Jadual 4, jawab soalan-soalan berikut.(a) (i) Identify the most suitable field for Primary Key.

Give a reason for your answer.Kenalpasti medan yang paling sesuai sebagai Kunci Utama.Berikan alasan bagi jawapan anda.

(ii) Differentiate between primary key and foreign key.Bezakan antara kunci utama dan kunci sekunder.

b) Draw two tables and use a line to show the relationship between the tables.Lukis dua jadual dan gunakan satu garisan untuk menunjukkanhubungan di antara kedua-dua jadual itu.

(a) (i) IC NoReason / AlasanBecause IC No is unique/not the sameSebab IC No ialah unik/tidak sama

(b)

- Two boxes labeled ‘PATIENT’ and ‘BILLING’ drawn to show two tables. – 1 mark.- Dua kotak berlabel ‘PATIENT’ dan ‘BILLING’ dilukis untuk menunjukkan dua jadual – 1 markah- Dua fields in each box labeled ‘IC NO’ - 1 mark- Dalam setiap kotak ada medan berlabel ‘IC No’ - 1 markah- A line drawn to the fields ‘IC NO’ in each box to show relationship - 1 markh- Ada garisan yang menghubungkan medan IC No di setiap kotak untuk menunjukkan perhubungan - 1 markah

Source Year

Level

Bloom

JOHOR 2010

6.3.2.9 Create a form that relates to the table content.

Section A

76

Section B30 Figure 16 shows part of the Inventory Information System of SMK Batu Karang.

Figure 16

Based on Figure 16,

(a) State the relationship between STAFF_INFO table and STAFF_REQUEST_STATIONERY table. Justify your answer.

[2 marks](b) Design the form for STAFF_RECORD_STATIONERY table.

[2 marks]Section C

1. Encik Ahmad Hakim has launched a garage sale for second hand cars for one month. He isan experience person in car business and offers special discount for his customer for anynational cars they buy. In order to make his work easier he keeps all his business transactionsdata in a database.Encik Ahmad Hakim telah melancarkan jualan garaj untuk kereta terpakai selama satubulan. Beliau berpengalaman dalam perniagaan kereta dan menawarkan diskaun istimewauntuk pelanggan-pelanggannya yang membeli kereta nasional. Untuk memudahkanurusannya, beliau menyimpan data-data urus niaga perniagaannya di dalam pangkalan data..Figure 19 shows a part of his database file.Rajah 19 menunjukkan sebahagian fail pangkalan datanya.

77

Figure 19 / Rajah 19

Based on Figure 19: /Berdasarkan Rajah 19:(a) Which field is primary key?

Medan manakah merupakan kekunci primer?Justify your answer.Berikan justifikasi kepada jawapan anda.

(b) Design data entry form that relates to the contents of the table.Reka bentuk borang kemasukan data yang berkaitan dengan kandungan jadual tersebut.

(a) Primary key : Registration numberRegistration number assign as primary key because :i. It is unique identifies each car’s record in database.ii. It ensures no duplicate registration number exist in database.

(b) Data entry form design

Suggestion answer Any relevant design drawn by students.

6.3.2.10 Create a query to retrieve required information with one or more conditions.

Section A

Section B

FIGURE 7 shows three database tables of an information system.

78

FIGURE 7

(a) Redraw and complete the following query design to show all the instructors and courses offered by School of Engineering. [4 marks]

Source Year

Level

Bloom

PENANG 2008

30. Figure 10(a) shows two tables created in the school co-curriculum system at Sekolah Menengah Batu Tiga.Rajah 10(a) menunjukkan dua jadual yang dibina dalam system kokurikulum di Sekolah Menengah Batu Tiga.

79

Figure 10(a) Rajah 10(a)Figure 10 (b) shows a Simple Query Wizard.Rajah 10 (b) menunjukkan Simple Query Wizard

Figure 10(b) Rajah 10(b)

a) Based on Figure 10(a) and Figure 10(b), state one more field that should be moved to the list X in Figure 10 (b), to view the grades of co-curricular activities for each student.Berdasarkan Rajah 10(a) dan Rajah 10(b), nyatakan satu medan tambahan yang perlu dipindahkan ke senarai X dalam Rajah 10(b), untuk memaparkan gred aktiviti kokurikulum untuk setiap pelajar.

Figure 10(c) shows a query design to retrieve information based on a certain criterion.Rajah 10(c) menunjukkan satu query design untuk mencapai semula maklumat berdasarkan criteria tertentu.

80

Figure 10(c) Rajah 10(c)

b) Based on the query design in Figure 10(c), complete the query results below to show the information obtained.Berdasarkan kepada query design dalam Rajah 10(c), lengkapkan keputusan query di bawah untuk menunjukkan maklumat yang diperoleh.

Class Stu_ID Name Postion CoCu

Source Year Level

Bloom

SPM 2008

Section C

31. Your school implements a Student Registration System. The design of the database table for the system is

shown in Figure 11.

Sekolah anda melaksanakan Sistem Pendaftaran Pelajar. Reka bentuk bagi jadual pangkalan data bagi sistem

tersebut ditunjukkan dalam Rajah 11.

FIGURE 11 RAJAH 11

81

a. Draw a query design to show the names and telephone numbers of students who live in Taman Setia Jaya. [3

marks]

Lukis reka bentuk kuiri yang memaparkan nama dan nombor telefon pelajar yang tinggal di Taman Setia

Jaya. [3 markah]

b. Draw a report design to show the registration no’s, names and telephone no’s grouped by postal code. [4

marks]

Lukis reka bentuk laporan yang memaparkan no pendaftaran, nama dan no telefon yang dikumpulkan

mengikut poskod. [4 markah]

Source Year Level BloomTERANGGAN

U2008

33 Figure 18 (a) and Figure 18 (b) shows the online reservation form for Hotel Selesa.

(a)

82

Hotel SelesaGuest Particulars

Guest Name:

Gender:

Passport No:

Address:

Contact No:

Email Add:

Reservation Info

Reservation ID

Date Check-in:

Date Check-out:

Arrival Time:

Departure Time:

Room Type:

Method of Payment:

(b)

Figure 18

Based on Figure 18,

(a) Design two tables to store the data in (a) and (b). State the fields and the primary key for each table. Show the relationship between the two tables.

[4 marks]

(b) Describe a query to list the guest checking in on the 10 October 2009. The query should include the following:

Guest Name

Date of Check-in

Room Type

Method of Payment

[3 marks]


6.3.2.11 Generate a report.

Section A

Section B

83

Section C

2. Figure 14(a) and Figure 14(b) show the online reservation form for Hotel Selesa.Rajah 14(a) dan Rajah 14(b) menunjukkan borang tempahan atas talian bagi Hotel Selesa.

Figure 14(a) Figure 14(b) / Rajah 14(a) Rajah 14(b)

Based on Figure 14(a) and Figure 14(b),Berdasarkan Rajah 14(a) dan Rajah 14(b), (a) Design two tables to store the data in Figure 14(a) and Figure 14(b). State the fields and the primary

key for each table. Show the relationship between the two tables.Reka bentuk dua jadual untuk menyimpan data dalam Rajah 14(a) dan Rajah 14(b). Nyatakan medan dan kunci utama bagi setiap jadual. Tunjukkan perhubungan antara kedua-dua jadual.

(b) Prepare a report based on guest particulars table. The report must contain at least three guest records. Sediakan satu laporan berdasarkan jadual Maklumat Pelanggan. Laporan mesti mengandungi sekurangkurangnya tiga rekod pelanggan.

84

Source Year

Level

Bloom

PAHANG 2010

33. Your school implements a Student Registration System (SRS). The records of the table for the system is shown in Figure 17.

Sekolah anda mengimplementasikan Sistem Pendaftaran Pelajar (SRS). Rekod untuk jadual sistem berkenaan ditunjukkan seperti Rajah 17.

Figure 17 Rajah 17

(i) Draw a query design to show the names and telephone numbers of students who live in Taman Setia Jaya.Lukiskan satu rekabentuk “query” untuk menunjukkan nama dan nombor telefon pelajar yang tinggal di Taman Setia Jaya.

(ii) Draw a report design to show the registration no’s, names and telephone no’s grouped by postcode : 78654.

85

Lukiskan satu rekabentuk laporan untuk menunjukkan nombor pendaftaran, nama dan no telefon yang disatukan di bawah poksod : 78654.

Source Year Level

Bloom

KELANG 2009

31. Wendy has just started a fitness club business in Kuala Lumpur. The fitness club offers a wide range of programs and services for its members. Wendy has asked her friend to develop a simple database system for the club. FIGURE 11 shows three tables and a query created for the system.

FIGURE 11

Based on the query shown in FIGURE 11,

(a) Explain the importance of the attributes Program_ID and ID in PARTICIPANT table . [ 2 marks ]

(b) Draw a report to display the programs joined by all club members. [ 5 marks ]

Source Year Level

Bloom

PCGHS 2009

86

33. Figure 12 shows a website of Zoo Negara. Through this website, user can register as a member of Zoo Negara Loyalty Card Programme.Rajah 12 menunjukkan laman web bagi Zoo Negara. Melalui laman web ini, pengguna boleh mendaftar diri sebagai ahli Zoo Negara Loyalty Card Programme.

87

12(a): Website 12(a): Laman

web

12(b): Table12(b): Jadual

12(c): Form12(c): Borang

Figure 12 Rajah 12

Based on Figure 12: Berdasarkan Rajah 12:(a) State one type of web editor used by Zoo Negara. Justify your answer.

Terangkan satu jenis web editor yang telah digunakan oleh Zoo Negara.Berikan justifikasi anda.

(b) Based on Figure 12(b) and Figure 12(c), design an interface of a report to show particulars of all members of Zoo Negara’s Loyalty Card Programme.Berdasarkan Rajah 12(b) dan Rajah12(c), reka antaramuka laporan yang menunjukkan semua ahli Zoo Negara Loyalty Card Programme secara terperinci.

Source Year Level

Bloom

PERAK 2009

33 The following are dialogue between a computer sales manager and a programmer. Berikut adalah perbualan di antara seorang pengurus jualan komputer dan seorang pengaturcara.

88

Based on the dialogue, prepare the report design to be generated by the Database Management Systems.

Berdasarkan dialog di atas, sediakan reka bentuk laporan yang akan dijana oleh Database Management Systems.

Source Year Level

Bloom

SPM 2009

89

1 · Web viewPerisian aplikasi yang membenarkan pengguna melakukan tugas-tugas khas. ... Oracle /...

Documents

Transcript of 1 · Web viewPerisian aplikasi yang membenarkan pengguna melakukan tugas-tugas khas. ... Oracle /...