LEARNING AREA 1 – ICT & SOCIETY
LEARNING AREA 6 – INFORMATION SYSTEM
Topic 6.1 - Concepts of Information Systems
6.1.1 Definition
6.1.1.1 Give the meaning of data, information and information systems
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
6.1.2 Usage of Information Systems in Various Fields
|FIELDS |
|GENERAL USAGE |
| |
|EDUCATION |
| |
| |
| |
| |
| |
| |
|BUSINESS |
| |
| |
| |
| |
| |
| |
|MANAGEMENT |
| |
| |
| |
| |
| |
| |
|LAPANGAN |
|KEGUNAAN |
| |
|PELAJARAN |
| |
| |
| |
| |
| |
|PERNIAGAAN |
| |
| |
| |
| |
| |
| |
|PENGURUSAN |
| |
| |
| |
| |
| |
| |
6.1.3 Information System Components
6.1.3.1 List the Information Systems Components
| |
6.1.3.2 Define each of the Information System components.
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
6.1.3.3 Describe the interrelation between information system components using a diagram.
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|Relationship between elements of Information Systems |
| |
6.1.4 Types of Information Systems
6.1.4.1 List five types of Information Systems:
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
.
6.1.4.2 State the usage of each type of Information System
| |
|INFORMATION SYSTEM |
|USAGE |
| |
|EXECUTIVE INFORMATION SYSTEM |
|(EIS) / |
|EXECUTIVE SUPPORT SYSTEM |
|(ESS)\ |
| |
|SISTEM INFORMASI EKSEKUTIF |
|SISTEM SOKONGAN EKSEKUTIF |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|MANAGEMENT INFORMATION SYSTEM |
|(MIS) |
| |
|SISTEM INFORMASI PENGURUSAN |
| |
| |
| |
| |
| |
| |
| |
| |
|TRANSACTION PROCESSING SYSTEM |
|(TPS) |
| |
|SISTEM PEMPROSESN TRASAKSI |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|DECISION SUPPORT SYSTEM (DSS) |
| |
|SISTEM SOKONGAN KEPUTUSAN |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|EXPERT SYSTEM (ES) / |
|ARTIFICIAL INTELLIGENT (AI) |
| |
|SISTEM PAKAR / |
|KEPINTARAN BUATAN |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
6.1.5 Hierarchy of Data
6.1.5.1 Define bit, byte, field, record, and file
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
6.1.5.2 State the hierarchy of data:
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
Topic 6.2 - Software
6.2.1 Definition
6.2.1.1 Define Database management Systems (DBMS)
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
6.2.1.2 List the benefits of using database.
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
6.2.2 Features
6.2.2.1 State the relationship between attribute (field), row (record) & relation (file)
| |
| |
|DATA IS ORGANIZED INTO RELATED TABLES. |
|DATA DIURUSKAN KEPAD BEBERAPA TABLE |
|EACH TABLE IS MADE UP OF ROWS WHICH ARE CALLED RECORDS AND COLUMNS WHICH ARE CALLED FIELDS. |
|SETIAP TABLE ADA ROW UNTUK REKOD DAN COLUMN UNTUK FIELDS |
|EACH RECORD CONTAINS FIELDS OF INFORMATION ABOUT SOME SPECIFIC ITEM. |
|SETIAP REKOD MENGANDUNGI FIELDS MENGENAI MAKLUMAT SESUATU ITEM. |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
6.2.2.2 Define the primary key and foreign key
|PRIMARY KEY |
| |
| |
| |
| |
| |
| |
|FOREIGN KEY |
| |
| |
| |
| |
| |
| |
| |
| |
6.2.2.3 State the importance of primary key
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
6.2.2.4 Differentiate between the primary key and foreign key
| |
|PRIMARY KEY |
|FOREIGN KEY |
| |
|MUST CONTAIN UNIQUE VALUES |
|MAY HAVE DUPLICATE VALUES |
| |
|USED TO UNIQUELY IDENTITY EACH RECORD IN A TABLE |
|USED TO LINK TO A PRIMARY KEY IN ANOTHER TABLE |
| |
|PRIMARY KEY |
|FOREIGN KEY |
| |
|MESTI ADA NILAI UNIK |
|BOLEH ADA NILAI YANG SAMA |
| |
|MEMBEZAKAN SETIAP REKOD DALAM TABLE |
|DIGUNAKAN UNTUK MENGHUBUNGKAN SATU TABLE DENGAN TABLE YANG LAIN |
| |
6.2.3 Database Objects
6.2.3.1 Define the following database objects/ tools: Tables, form, query, report.
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
6.2.3.2 Identify table, query, form and report as database objects/ tools.
| |
| |
|TABLE |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|FORM |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|QUERY |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|REPORT |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|RELATIONSHIP |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
6.2.4 Data manipulation
6.2.4.1 List the basic operations of data manipulation:
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
6.2.4.2 State the usage of basic operations in data manipulation.
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
6.3.1 Phases of Systems Development
6.3.1.1 Describe the phases of systems development:
| |
|1. |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
Topic 6.3 – Database Development
6.3.2 Develop a Database Project
1. Identify a project.
| |
|(BASED ON EXAMPLE :PERSONAL MUSIC COLLECTION SYSTEM) |
|(CONTOH PROJEK” SISTEM KOLEKSI MUZIK PERIBADI) |
| |
|THE PROBLEM IS : THE NUMBER OF CDS ARE INCREASING. |
|THE SOLUTION IS : TO DO A CATALOGUE |
| |
|MASALAH “ JUMLAH CD SEMAKIN BERTAMBAH |
|PENYELESAINA MASALAH” MEMBUAT KATALOG |
2. Identify the project requirements.
|KEPERLUAN PROJEK |
|CAN STORE INFORMATION OF ALL THE CDS |
|EASY TO USE |
|FAST PERFORMANCE |
|BOLEH MENYIMPAN SEMUA MAKLUMAT CD |
|SENANG DIGUNAKAN |
|PRESTASI BAIK, CEPAT DAN LANCAR |
3. Classify project requirements into two tables.
| |
|- TABLES: SINGER, SONG AND ALBUM |
| |
|- TABLES: PENYANYI, LAGU DAN ALBUM |
4. Design databases tables.
| |
|[pic] |
5. Create a database.
| |
|CREATE A DATABESE USING DATABASES SOTTWARE FOR EXAMPLE MICROSOFT ACCESS. |
| |
|MEMBUAT PANGKALAN DATA MENGGUNAKAN PERISIAN MICROSOFT ACCESS |
6. Create two tables that include the primary key for each table.
| |
| |
| |
| |
| |
7. Build a relationship between two tables.
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
8. Enter data into the table.
| |
|ISI SEMUA MAKLUMAT MENGIKUT JENIS TABLE |
9. Create a form that relates to the table content.
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
10. Create a query to retrieve required information with one or more conditions.
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
11. Generate a report.
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
6.3.2.12 Gather all the documents from the above phases into a folio
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
(ASSESSMENT S12.1)
MICROSOFT ACCESS PORJECT
3. current and future development
6.4.1 web based application
6.4.1.1. find out current and future development in computer information system
| |
|(ASSESSMENT S13.1) |
[pic]
-----------------------
Data
DATA
People
MANUSIA
Hardware
PERKAKASANN
Procedure
PROSEDUR
Software
PERISIAN
Field
Database
Record
File
Byte
Bit
Field
Field
Field
Field
Field
Field
Record
Record
Record
Database
File
File
Record
Field
Record
Field
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.