Information System & Technology (IST)

SUMMARY CHAPTER 12 @ 14/12/2011

DATABASE

APA TU REKOD
APA TU FILE
APA TU DATABASE

ACCOUNTANT MUST KNOW TO VIEW THE REPORT?
EG. NAK SEMAK DATA MENGENAI STAF YANG DAH ADA PHD, BELUM ADA PHD, SEDANG BUAT PHD...

2 WAYS TO VIEW DATA
1) PHYSICAL VIEW - TECHNICAL PART
2) LOGICAL VIEW- TAK PEGI KE TECHNICAL PART EG DATABASE ADA NAMA ALAMAT

DATA ORG.
CHARACTER A,B,C...
FIELD = COLUMN
RECORD = ROW
FILE =
TABLE
DATABASE
KEY FIELD = IC IS UNIK=PRIMARY KEY

BACTH PROCESSING = EG. 2 BULAN SEKALI UPDATE
REAL TIME = ONLINE PROCESSING

INTEGRATED DATA
DATA INTEGRITY = DATA YANG SENTIASA DI UPDATE
DATA REDUNDANCY =

KEPERLUAN DATABASE
SHARING
SECURITY
LESS DATA REDUNDUCY
DATA INTERGRITY

DBMS
DATA MANIPULATION SUBSYSTEM
QUERY BY EXAMPLE-WIZARD NEXT
SQL- KENA HAFAL... SELECT APE?

DATA ADMIN SUBSYSTEM = BACKUP

5 MODEL

HIERARCHICAL DATABASE = SLOW

NETWORK DBMS= 1-1 SEORANG STUDENT ADA 1 ID
1-3 SEORANG IBU PUNYA 3 ANAK
MANY TO MANY = SATU COURSE

RELATIONAL DBMS
ROW = RECORD
COLUMN = FIELD
MESTI ADE 2 @ LEBIH TABLE = UNTUK LINK = PRIMARY KEY

MULTIDIMENSIONAL DBMS
DATA CUBE= LEBIH DIMENSI
EG= LAYER BY LAYER
        LOGTITUDE, MAGNITUTE
        KETINGGIAN, WEATHER, PHOTO
I.E= GOOGLE MAP

OBJECT-OREIANTED
ORGANIZES DATA GUNA OBJEK
CONTOHNYA;
CLASS = EMPLOYEE
OBJEK = NAMA ORANG
ATTRIBUTE = UMUR
METHOD = BAYAR GAJI

KEBAIKAN = X PAYAH TANYA BANYAK DA SEBAB MAKLUMAT DA ADA
KELEMAHAN = MAKLUMAT TERLALU BANYAK
                             CREATE LAGI SATU ATTRIBUTE = RE CYCLE

INDIVIDUAL DATABASES
EG.  I TUNES HANYA ORG YG ADE ID SAHAJA BO LOGIN

COMPANY OR SHARED DB
EG. DROPBOX.

DISTRIBUTED DB
BACKUP= DATA BASE
SECURITY

COMMERCIAL DB
MAYBANK TO YOU

DATABASE USES
STRATEGIC USED =DATA WAREHOUSE(GUDANG DATA)= MAYBANK TO YOU
SBB DATA X BOLEH DIKENDALIKAN OLEH MANUSIA

DATA MINING= NK KENAL PASTI

ADE BERAPA SYKT DGN THAILAND BORDER
YES OR NO
QUERY = KEDAH KELANTAN PERLIS
APPLY = YES