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
6.1.2.1 State the usage of Information Systems in education, business and management.
6.1.3 Information System Components
6.1.3.1 List the Information System components:
• data • hardware • software • people • procedure
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.
6.1.4 Types of Information Systems
6.1.4.1 List five types of Information Systems:
• Management Information System (MIS) • Transaction Processing System (TPS)
• Decision Support System (DSS) • Executive Information System (EIS)
• Expert System (ES)/Artificial Intelligence (AI)
6.1.4.2 State the usage of each type of information system.
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:
• Bit → Byte (Character) → Field → Record → File → Database
6.2 Software
6.2.1 Definition
6.2.1.1 Define database and Database Management Systems (DBMS).
6.2.1.2 List the benefits of using database.
6.2.2 Features
6.2.2.2 Define the primary key and foreign key.
6.2.2.3 State the importance of the primary key.
6.2.2.4 Differentiate between the primary key and foreign key.
6.2.2.5 State the importance of relationship between the primary key and foreign key.
6.2.3 Database Objects
6.2.3.1 Define the following database objects/ tools: Table, form, query, report.
6.2.3.2 Identify table, query, form and report as database objects/ tools.
6.2.4 Data Manipulation
6.2.4.1 List the basic operations of data manipulation:
• Update • Insert • Delete • Retrieve • Sort • Filter • Search
6.2.4.2 State the usage of basic operations in data manipulation.
6.3 Database Development
6.3.1 Phases of Systems Development
6.3.1.1 Describe the phases of systems development:
• Analysis • Design • Implementation • Testing • Documentation • Maintenance
6.3.2 Develop A Database Project
6.3.2.1 Identify a project.
6.3.2.2 Identify the project requirements.
6.3.2.3 Classify project requirements into two tables.
6.3.2.4 Design database tables.
6.3.2.5 Create a database.
6.3.2.6 Create two tables that include the primary key in each table.
6.3.2.7 Build a relationship between two tables.
6.3.2.8 Enter data into the table.
6.3.2.9 Create a form that relates to the table content.
6.3.2.10 Create a query to retrieve required information with one or more conditions.
6.3.2.11 Generate a report.
6.3.2.12 Gather all the documents from the above phases into a folio.
6.4 Current and Future Developments
6.4.1 Web-based Application
6.4.1.1 Find out current developments in computer information systems.