Session 71

LO must be send by 2nd of May.
Exam will be on all the learning area and it will be like SPM format.
Had a hands-on test on Ms Access

Session 70

Continue doing database assignment

Session 69

Did database assignment with my partner, Melissa

Session 68

Primary key
-  the field that uniquely represents each record in a table
- also known as the unique identifier

Foreign key
- a field that matches the primary key in the other key
- may have duplicate values

Importance of primary key:
1. helps avoid duplicating records
2. prevents null values

Session 67

Features of Microsoft Access

Query - type of database objects

          - request for a specific data

Form - enter information

Report - summaries information

Session 66

Hierarchy of Data

Bit - represented by 0 for OFF and 1 for ON

Byte - a collection of data

Field - unit of data consisting of one or more characters

Record - a collection of related field

File- a collection of related record

Database - a structured collection of information on a specific subject

                - easily accessed, updated and retrieve information

DBMS: - a program that accesses information from a database

             - enables to extract, modify, and store information

Benefits:

(i) minimize data redundancy

(ii) data integrity is assured

(iii) ease of sharing data

(iv) information can be accessed easily

Session 65

INFORMATION SYSTEM 

- a set of related components that collects and processes data and processes data and provides information

Usage in Various Fields

1. Education

~ keep track of students' statistics and grades

~ help students and teachers in online learning and discussion

~ store subject content

2. Business

~ carry out online buying and selling

~ help plan delivery of goods and services

~ make room bookings and for checking the best rates

3. Management

~ see employee record

~ analyse products, services and product prices

~ process customers order, organize production times and keep track of product inventory

Types: 

(i) Management Information System (MIS)

(ii) Transaction Processing System (TPS)

(iii) Decision Support System (DSS)

(iv) Executive Information System (EIS)

(v) Expert System (ES)