f5 chapter 6 information system question

7/23/2019 f5 Chapter 6 Information System Question

1/36

6.1 Concepts of Information Systems

6.1.1 Definition6.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.

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

(EDA! "#1#$

". #able $ sho!s some terms used in information and communication technology.Jadual 3 menunjukkan beberapa istilah yang digunakan dalam teknologi maklumat dan komunikasi.

ata

Information System

Information

Choose the terms sho!n in #able $ !hich match the follo!ing statements %

Pilih istilah yang ditunjukkan dalam Jadual 3 yang berpadanan dengan kenyataan berikut:

%%%%%%%%%%%%%%%%%%%%%%(S&' "##$

$. &igure ' sho!s the concept of Information System ( ajah ! menunjukkan konsep Sistem Maklumat.

1

"olle#tion of hard$are, soft$are, data, people

and pro#edures.%oleksi perkakasan, perisian, data, manusia dan

prosedur.

"olle#tion of unpro#essed items, $hi#h #an

in#lude te&t, numbers, images, audio and video.

%oleksi item yang belum diproses, yang boleh

merangkumi teks, angka, gambar, audio dan

video.

(i)

(ii)


2/36

&igure ' ( ajah !&or the statement given state ), * or +.

'erdasarkan pernyataan yang diberi nyatakanX, Y atauZ.i) *a! material, not organi+ed and has little value.

'ahan mentah, tidak tersusun dan mempunyai nilai yang ke#il.%%%%%

ii) rgani+ed data that is valuable and meaningful to user.(ata 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

%%%%%(TEENGGAN- "#1#$

6.1." -sage of Information Systems In ario/s 0ieds6.1.".1 State the /sage of Information Systems in ed/2ation, 3/siness and management.

2


3/36

SECTION A

1. Both activities above are the usage of Information System in ------.%edua)dua aktiviti di atas merupakan #ontoh kegunaan Sistem Maklumat dalam bidang ******.A. ducation ( Pendidikan B. /edicine ( PerubatanC. /anagement ( Pengurusan . Art ( %esenian

(&E4IS "#1#$SECTION 5

". 0ou eep a data base of your friends2 names, addresses and datesof birth. #he data base is ept in the

school server and can be retrieve by other user.

+nda menyimpan pangkalan data rakan)rakan anda, lamat nama dan tarikh lahir. Pangkalan data disimpan

di pelayan sekolah dan boleh diambil oleh pengguna lain.

a. Statetouses of the information from the data base to be utili+ed.

3yata dua egunaan malumat daripada pangalan data yang boleh digunaan.

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

b) Statetoproblems that may arised by having shared data base.

3yataan dua masalah yang mungin timbul dengan memilii pangalan berongsi data.%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

(S&' "##7$

6.1.8 Information System Com9onents6.1.8.1 4ist the Information System 2om9onents: ; data ; hardare ; softare ; 9eo9e ; 9ro2ed/re

SECTION A

3


4/36

1. #he components of an information system are human, hard!are, soft!are, procedures and %%%%%.

%omponen sistem maklumat adalah manusia, perkakasan, perisian, prosedur dan %%%%%.(S&' "##7$

". &igure 11 sho!s interrelation bet!een information system components.

ajah -- menunjukkan jalinan antara komponen sistem maklumat.

&igure 11

ajah --

Based on &igure 11, name% ( Berdasaran *a4ah 11, namaan%

(i) 5 < %%%%%%%%%%%%%%%%%%%.

(ii) 0 < %%%%%%%%%%%%%%%%%%%.(SE4ANGO, "#1#$

6.1.8." Define ea2h of the Information System 2om9onents.

SECTION A

4

Hardware

Data

XProcedures

Y


5/36

1. Choose the correct components of Information System. ( Pilih komponen Sistem Maklumat yang betul.I ata ( (ata II eople ( ManusiaIII Computer ( %omputer I7 rocedure ( ProsedurA I, II and III ( , dan B I, II and I7 ( , dan /C I, III and I7 ( , dan / II, III and I7 ( , dan /

(=O!O "#1#$

". &igure 1" sho!s one of Information Systems components.ajah -0 menunjukkan salah satu daripada komponen Sistem Maklumat.

&igure 1" ( ajah -0

Component )is operating instructions for the user of an information system.

%omponenXadalah arahan operasi untuk pengguna bagi sistem maklumat.

Based on &igure 1", state 5. ( 'erdasarkan ajah -0, nyatakanX.

< %%%%%%%%%%%%%%%%%%%.

(&-TA=A*A "#1#$

6.1.8.8 Des2ri3e the interreation 3eteen information system 2om9onents /sing a diagram.

SECTION 5

1. &igure 18 sho!s the interrelation of five main components of an online ticeting system for a cinema.ajah -1 menunjukkan hubungan antara lima komponen utama dalam satu sistem jualan tiket atas talianbagi sebuah pa$agam.

5

Component X

KomponenX


6/36

Based on &igure 18% ( 'erdasarkan ajah -1 :9a) state one example of component% ( 2yatakan satu #ontoh komponen:

9i) B < %%%%%%%%%%%%%%%%%%%.9ii) C < %%%%%%%%%%%%%%%%%%%..

9b) escribe the interrelation bet!een component A and component .uraikan hubungan antara %omponen + dan %omponen 4.%%%%%%%%%%%%%%%%%%%.%%%%%%%%%%%%%%%%%%%.%%%%%%%%%%%%%%%%%%%.%%%%%%%%%%%%%%%%%%%.%%%%%%%%%%%%%%%%%%%.%%%%%%%%%%%%%%%%%%%.

(S&' "#1#$

". &igure 6 sho!s the components in an information system.ajah 5 menunjukkan komponen)komponen di dalam sistem maklumat.

6


7/36

&igure 6 ( ajah 5Based on &igure 6, ( 'erdasarkan ajah 5 69i) 3ame 5. ( 2amakan 7

%%%%%%%%%%%%%%%%%%%.

9ii) :hich component of the information system is responsible to provide interface for a user toenter data into the system !ith the help of input devices;%omponen yang manakah dalam sistem maklumat bertanggungja$ab untuk menyediakanantara muka untuk pengguna memasukkan data ke dalam sistem dengan bantuan perantiinput8%%%%%%%%%%%%%%%%%%%.

(EDA! "#1#$

7


8/36

6.1.> Ty9es of Information Systems6.1.>.1 4ist five ty9es of Information Systems: ; 'IS ; T&S ; DSS ; EIS ; ES ? AI

SECTION A

1. &ive types of Information System are ecision Support System 9SS), /anagement Information System

9/IS), and xpert System 9S), xecutive Information System 9IS) and ---------------------9ima jenis Sistem Maklumat ialah Sistem Sokongan %eputusan (SS;, Sistem Pengurusan Maklumat

MS;, Sistem Pakar 4S;, Sistem Maklumat 4ksekutif 4S; and ************************

A. #ransaction rocessing System 9#S) ( Sistem Pemprosesan Transaksi TPS;

B. xecutive Assistant System 9AS) ( Sistem 'antuan 4ksekutif 4+S;

C. ecision Information System 9IS) ( Sistem Maklumat %eputusan

. xpert Information System 9IS) ( Sistem Maklumat Pakar

('E4AA "#1#$

". :hich of the follo!ing are types of Information Systems;


9/36

6.1.>." State the /sage of ea2h ty9e of information system .

SECTION A

1. /atch the information system in column 5 !ith statements in column 0Padankan sistem maklumat di medan 7 dengan kenyataan dalam medan


10/36

#able 6 (Jadual 5

&igure 1> sho!s some diagrams used in information system, A and B.

ajah -= menunjukkan sebahagian diagram yang digunakan dalam sistem maklumat, + dan '.

&igure 1> ( ajah -=

Choose the terms sho!n in #able 6 !hich match the diagrams Aand 5.

Pilih terma yang ditunjukkan dalam Jadual 5 yang sepadan dengan diagramAdan B.

I. A %%%%%%%%%%%%%%%%%%%.II. 5 %%%%%%%%%%%%%%%%%%%.

(&-TA=A*A "#1#$

10

A

B


11/36

6.1.@ !ierar2hy of Data6.1.'.1 efine bit, byte, field, record, and file.

1. &igure 1? sho!s a school data base ( ajah -> menunjukkan pangkalan data sekolah

3ame

i) A% %%%%%%%%%%%%%%%. ii) 5% %%%%%%%%%%%%%%%.

ii) (S&' "##7$

11

Studen

IDNameClass2396Azahrina5A13975Saras

wathy5A13981Tommy5A24782Wahid5A2A

B


12/36

6.1.'." State the hierarchy of data%@ Bit Byte 9Character) &ield *ecord &ile atabase

SECTION A

1. &igure ' sho!s the hierachy of data. ( ajah ! menunjukkan hieraki data

3ame %( namakan

9i) % %%%%%%%%%%%%% 9ii) 4% %%%%%%%%%%%%%

9S&' "##7)

". &igure 11 sho!s the data hierarchy in an information system.ajah -- menunjukkan hierarki data dalam suatu sistem maklumat

&igure 11 ( ajah --Based on &igure 11, state the name of%'erdasarkan ajah --, nyatakan nama:9i) %%%%%%%%%%%%% 9ii) * %%%%%%%%%%%%%

(S&' "#1#$

$. &igure sho!s the hierarchy of data. ( ajah ? menunjukkan hirarki data.

12

Bit K Field L Dataas

e


13/36

&igure ( ajah ?Choose the correct ans!er. (Pilih ja$apan yang betul.A. DE&ield ( Medan *E*ecord(ekodB. DE*ecord( ekod *E&ield(MedanC DE*ecord(ekod *E&ile(@ail DE#able(Jadual *E &ile(@ail

(EDA! "#1#$

>. &igure 1? sho!s t!o tables in a database.( ajah -> menunjukkan dua jadual dalam pangkalan data.

a) Identify a field name from both tables to mae a relationship.

%enalpasti satu medan daripada kedua)dua jadual bagi me$ujudkan hubungan.

%%%%%%%%%%%%%

b; State the total number of fields in #able" ( 2yatakan bilangan medan dalam Jadual0%%%%%%%%%%%%%

(E4ANTAN "#1#$

'. A %%%%%%%%%%%%%is a collection of many records.%%%%%%%%%%%%% ialah koleksi rekod yang banyak

(TEENGGAN- "#1#$

13

re 10

ah 10

ased o! Figure 10"

erdasar#a! $a%a& 10"


14/36

6." Soft!are

6.".1 Definition6.".1.1 Define data3ase and Data3ase 'anagement Systems (D5'S$.

SECTION A

1. atabase /anagement System 9D5'S) is a soft!are used in adding, updating, managing, accessing, andanalysing data in a database. 9#(&)(atabase Management System ('MS; adalah soft$are yang digunakan dalam menambah,mengemaskini, mengurus, mengakses, dan menganalisis data dalam database.Tr/e ? 0ase

(S&' "##7$

". #able > sho!s some terms used in information and communication technology.

Jadual = menunjukkan beberapa istilah yang digunakan dalam teknologi maklumat dan komunikasi

Secondary ey /BS &oreign ey database

Choose the terms sho!n in #able > !hich match the follo!ing statements %

A collection of data organised in a systematic !ay

%%%%%%%%%%%%%

(S&' "##$

$. /anager uses an information system to mae the business processes and activities more efficientcompared to doing them manually. #he information system provides regular information about the daily

activities of a business to the manager. #he information system developed using atabase /anagementSystem 9B/S) soft!are.Pengurus menggunakan suatu sistem maklumat untuk meningkatkan ke#ekapan dalam proses dan aktiviti

perniagaan berbanding dengan #ara manual. Sistem maklumat ini memberikan maklumat laAim berkaitanaktiviti harian perniagaan kepada pengurus. Sistem maklumat tersebut dibangunkan menggunakan

perisisanSistem Pengurusan Pangkalan (ata SPP(;.

Based on the statements above, ( 'erdasarkan pernyataan di atas,9i) State the type of the information system. ( 2yatakan jenis sistem maklumat.

%%%%%%%%%%%%%%%%%%%%%%%%%%

9ii) State one example of the B/S. ( 2yatakan satu #ontoh SPP(.

%%%%%%%%%%%%%%%%%%%%%%%%%%(&A!ANG "#1#$

>. A %%%%%%%%%%%%%is a program that accesses information from a database and provideinterface bet!een user and database.%%%%%%%%%%%%%ialah program yang men#apai maklumat dari pangkalan data dan menyediakan antaramuka antara pengguna dan pangkalan data.

(TEENGGAN- "#1#$

14


15/36

'. :hich of the follo!ing is the benefit of using database;Manakah antara berikut merupakan faedah menggunakan pangkalan data8

A. Fo! maintenance cost ( %os penyelenggaraan yang rendahB. ata can be haced by others ( (ata boleh di#erobohi oleh orang lainC. /inimises data redundancy ( Meminimakan pertindihan data. #he data is valid ( (ata tersebut adalah sah

(TEENGGAN- "#1#$

6. &igure 1$ sho!s a program that access information from a database. * system enables you to extract,

modify and store information from the database.

ajah -3 menunjukkan sebuah program untuk men#apai maklumat dari pangkalan data. Sistem 9a) and &igure 1>9b) sho! t!o tables created in the #echCom Information System at #echCom

Sdn Bhd.

ajah -=a; dan ajah -=b; menunjukkan dua jadual yang dibina di dalam sistem maklumat Te#h"om di

Te#h"om Sdn 'hd.

Based on &igure 1>9a) and &igure 1>9b), ( 'erdasarkan ajah -=a; dan ajah -=b;,

State t!o the importance of the function of primary ey.

2yatakan dua kepentingan fungsi kekun#i primer.

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

24

&igure 1>9a) ( ajah -=a;

&igure 1>9b) ( ajah -=b;


25/36

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

(E4ANTAN "#1#$

6.".".> Differentiate 3eteen the 9rimary ey and foreign ey.6.".".@ State the im9ortan2e of reationshi9 3eteen the 9rimary ey and foreign ey.

SECTION C

1. #ables > sho!s the data for each patient stored in a patient2s file in /aha!angi Specialist CentreSystem 9/SCS).

Jadual = menunjukkan data bagi setiap pesakit yang disimpan dalam fail pesakit di Sistem PusatPakar Maha$angi SPPM;.

#able > (Jadual =

Based on #able >, ans!er the follo!ing


26/36

b) ra! to tables and use a line to sho! the relationship bet!een the tables.9ukis duajadual dan gunakan satu garisan untuk menunjukkanhubungan di antara kedua)dua

jadual itu.

(=O!O "#1#$

". &igure 1>9a) and &igure 1>9b) sho! the online reservation form for otel Selesa.ajah -=a; dan ajah -=b; menunjukkan borang tempahan atas talian bagi otel Selesa.

26


27/36

&igure 1>9a) &igure 1>9b) ( ajah -=a; ajah -=b;

Based on &igure 1>9a) and &igure 1>9b),'erdasarkan ajah -=a; dan ajah -=b;,

9a) esign t!o tables to store the data in &igure 1>9a) and &igure 1>9b). State the fields and theprimary ey for each table. Sho! the relationship bet!een the t!o tables.eka bentuk dua jadual untuk menyimpan data dalam ajah -=a; dan ajah -=b;. 2yatakanmedan dan kun#i utama bagi setiap jadual. Tunjukkan perhubungan antara kedua)dua jadual.

9b) repare a report based on guest particulars table. #he report must contain at least three guestrecords. Sediakan satu laporan berdasarkan jadual Maklumat Pelanggan. 9aporan mestimengandungi sekurangkurangnya tiga rekod pelanggan.

27


28/36

(&A!ANG "#1#$

$. #able explains the computerised plan of a flo!er shop.

Jadual ? menerangkan pelan berkomputer bagi sebuah kedai bunga.

Bou


29/36

6.".8 Data3ase O3Be2ts6.".8.1 Define the fooing data3ase o3Be2ts?toos:Ta3e, form, /ery, re9ort.

6.".8." Identify ta3e, /ery, form and re9ort as data3ase o3Be2ts? toos.

SECTION A

1. &igure 1$ sho!s a database screen. ( ajah -3 menunjukkan skrin pangkalan data.

&igure 1$ ( *a4ah 1$

Based on &igure 1$, !hich of the follo!ing describes the screen;'erdasarkan aiah -3, antara yang beriku.t yang manakah menerangkan skrin itu8A &orm ( 'orang B S!itchboard ( Papan suisC *eport ( 9aporan esign vie! ( Pandangan rekabentuk

(S&' "#1#$SECTION C

". #able explains the computerised plan of a flo!er shop.Jadual ? menerangkan pelan berkomputer bagi sebuah kedai bunga.

Bou


30/36

laporan 2ama Pembekal yang spesifik.%%%%%%%%%%%%%%%%%%%%%%%%..

(EDA! "#1#$6.".> Data 'ani9/ation6.".>.1 4ist the 3asi2 o9erations of data mani9/ation:; -9date ; Insert ; Deete ; etrieve ; Sort ; 0iter ; Sear2h

SECTION A

1. State !hether the follo!ing statement is #rue or &alse.2yatakan sama ada pernyataan berikut 'enar atauPalsuelete, &ilter, Insert, Jpgrade and Search are basic operations of data manipulation.apus, Saring, Sisip, 2aik gred dan Penggelintaran adalah operasi asas dalam manipulasi data.%%%%%%

(S&' "##$

". &igure 89a) sho!s a table in a database and &igure 89b) sho!s the output of data manipulation in the table

Duery.

ajah 1a; menunjukkan satu jadual dalam pangkalan data dan ajah 1b; menunjukkan hasil manipulasi

data tersebut dalam jadual Fuery.

Identify the basic operation of data manipulation that has been done.

%enalpasti satu operasi asas dalam manipulasi data yang telah dilakukan%%%%%%%%%%%%%%%%.

(E4ANTAN "#1#$

$. State !hether the follo!ing statement is Tr/e or 0ase2yatakan sama ada pernyataan berikut Benar atau Palsu.

elete, &ilter, Insert, Jpdate and Search are basic operations of data manipulation.apus, Saring, Sisip, %emaskini dan Penggelintaran adalah operasi asas dalam manipulasi data.%%%%%%%%%%

(N.SE'5I4AN "#1#$>. #able ' sho!s some basic operations of data manipulation.

Jadual ! menunjukkan beberapa operasi asas dalam manipulasi data.

30

&igure 89a) ( ajah 1a;

&igure 89b) ( ajah 1b;


31/36

#able ' (Jadual !Based on #able ', state the operation for%'erdasarkan Jadual !, nyatakan operasi bagi:9i) ) ." State the /sage of 3asi2 o9erations in data mani9/ation.

SECTION A

1. #he basic operation usedNto select a fe! records from a database isGperasi afas yang digunakan untuk memilih beberapa rekod daripada pangkala2 data adalahA index ( indeks B delete ( hapusC filter ( saring update ( kemas kini

(S&' "##$

31List one or more records using certain condition

Menyenaraikan satu atau lebih rekod

menggunakan keadaan tertentu


32/36

Statement '

". Statement ' represents the usage of ---------------- in data manipulation%enyataan ! merupakan penggunaan **************** dalam data manipulasi

A. /odify B. &ilter C. Jpdate . Sort

(SET &EC-5AAN SA5A! "#1#$

6.$ atabase evelopment6.8.1 &hases of Systems Deveo9ment6.8.1.1 Des2ri3e the 9hases of systems deveo9ment:

; Anaysis ; Design ; Im9ementation ; Testing ; Do2/mentation ; 'aintenan2e

SECTION A

1. #he follo!ing list are activities carried out by /ary and her team !hen developing the school2s library

information system.

Senarai berikut adalah kegiatan yang dilakukan oleh Maria dan pasukannya saat membangunkan sistem

maklumat perpustakaan sekolah.

32


33/36

State the name of the phase in the system development

2yatakan fasa yang terlibat dalam pembangunan sistem

%%%%%%%%%%%%%%%%%%%%%%%%%..

(S&' "##$

". State !hether the follo!ing statement is Tr/eor 0ase.

2yatakan sama ada pernyataan berikut Benaratau Palsu.

#he Implementation hase in the system development refers to the !ritten material generated throughout

all the phases of the system development.

@asa Pelaksanaan dalam pembinaan sistem merujuk kepada bahan bertulis yang dihasil sepanjang fasa

pembinaan sistem.

%%%%%%%%%%..

. (E4ANTAN "#1#$

$. #he follo!ing is a text on system development for a company.

'erikut adalah teks tentang pembinaan sistem untuk sebuah syarikat.

.

Based on the statement above ('erdasarkan pernyataan di atas,

State the hase of System development that taes place in the scenario.

2yatakan fasa pembinaan sistem yang berlaku di dalam situasi di atas.

%%%%%%%%%%..

(E4ANTAN "#1#$

>. #able $ belo! sho!s phases of system development.Jadual 3 di ba$ah menunjukkan fasa dalam pembangunan sistem.A Analysis B Implementation C /aintenance#able > (Jadual =Based on #able $ , !rite A, B or C for the follo!ing activities.'erdasarkan Jadual 3, tulis +,' atau " untuk aktiviti berikut.i) #he phases !here a system is created. ( Sistem dibina pada fasa ini.

33

= Intervie! the librarians, teacher=in=charge of the library and the principal

= istibute


34/36

%%%%%%%%%%..ii) Involves checing, changing and enhancing to improve its performance.

Melibatkan pemeriksaan, perubahan dan penambahbaikan untuk meningkatkan lagi mutupersembahan.%%%%%%%%%%..

iii) etermine the user2s !ants, needs, and re


35/36

6.8." Deveo9 A Data3ase &roBe2t6.$.".11 Generate a report.

SECTION C

1. #he follo!ing are dialogue bet!een a computer sales manager and a programmer.

'erikut adalah perbualan di antara seorang pengurus jualan komputer dan seorang pengatur#ara.

/anager % Good morning, may I see the Cyber /a4u Sdn. Bhd. monthly sales for theprevious months; Can you please print it out for me;Selamat pagi, boleh saya lihat jualan bulanan "yber Maju Sdn. 'hd. untukbulan)bulan yang lepas8 'olehkah a$ak #etakkannya untuk saya8

rogrammer% :hat details !ould you lie to see in the report, sir;Perkara apa yang tuan hendak lihat dalam laporan itu8

35


36/36

/anager% lease sho! me the sales for each model, units sold and also the total sales ofthose months.Tolong tunjukkan saya jualan bagi setiap model, unit dijual dan juga jumlah

jualan bagi bulan)bulan tersebut.

rogrammer% All right sir, IN11 get it done as soon as possible.'aiklah tuan, saya akan siapkan se#epat mungkin

/anager% #han you.Terima kasih.

Based on the dialogue, prepare the report design to be genorated by the atabase /anagement Systems.'erdasarkan dialog di atas, sediakan reka bentuk laporan yang akan dijana oleh (atabase ManagementSystems

(S&' "##$

6.$.".1" Gather all the documents from the above phases into a folio.

6.> Current and &uture evelopments

6.>.1 e3F3ased A99i2ation6.>.1.1 &ind out current developments in computer information systems.

f5 chapter 6 information system question

Documents