JOM KITA 'FAMILIARIZE' KEYWORDS & ABBREVIATIONS UNTUK BAB 12 & 13

dari ku utuk mu... =)

(perhaps kalau masuk quiz...nnt boleh la tahu, xla ternganga-ngaga..skodeng mmber sebelah) HEHEHE...=)

 salah satu cara nak mulakan study smart。。。。

CHAPTER 12 : DATABASES

Data consists of facts or observations about people, places, things, and events.

TWO WAYS @ PERSPECTIVES TO VIEW DATA :

A) Physical view------> actual formats and location of data; very specialized computer professionals are concerned with this view.

B) Logical view------>focuses on meaning and content of data;end users and most computer professionals are concerned with this view.

DATA IS ORGANIZED BY THE FOLLOWING GROUPS :

• CHARACTER
• FIELD              
• RECORD                           [ cha fie rec tab datab ]
• TABLE                       ====>  [capik fikir rencong tebu dibuat]   
• DATABASE

• KEY FIELD = PRIMARY KEY

• BATCH ( LATER ）vs REAL TIME  ( NOW )

PROCESSING 

DBMS = Database management system

- DBMS engine

-data definition subsystem (using a data dictionary or schema)

-data manipulation subsystem, provides tools for data maintenance & data analysis; tools include query-by-example and structured query language (SQL).

 

 

-APPLICATION GENERATION SUBSYSTEM (creating data entry forms with specialized programming languages)

-DATA ADMINISTRATION SUBSYSTEM

-DATABASE ADMINISTRATORS (DBAs) are computer professionals who help define processing rights.

-multidimensional database, sometimes called a data cube.

CHAPTER 13 

system analysis and design

SAD is a 6-phase problem-solving:

P/S; DO THE BEST!! SELAMAT MENJAWAB QUIZ & SELAMAT MENJAWAB 'FINAL'