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