CHAPTER 7: STORING ORGANIZATIONAL INFORMATION DATABASE

What is databases ?

maintain info about various types of objects (inventory), event (transaction),

people (employees) and places (warehouses).

for example UiTM student portal and facebook 

Databases models include :

① Hierarchical database model - organized into tree-like structure
② Network database model - representing objects and relationship
③ Relational database model - stores information in form of logically related two dimensional tables

Entity  : person, place, thing, transaction or event about which info is stored

Attribute : field or columns, characteristics or properties of an entity class.

Primary class and foreign keys identify various entity classes in database.

Primary key - a field that uniquely identifies a given entity in a table.

Foreign key - primary key of 1 table an attribute in another table and acts to provide a logical   relationship among two tables

As we know, databases advantage from a business perspective include :

1. increased flexibility

2. increased scalability and performance

3. reduce info redundancy

4. increase info integrity

4. increase information integrity

Database management systems also known as DBMS is software through  which users and application programs interact with database.

Data driven Management is an interactive website kept constantly updated and relevant to the needs of its customers through the use of database.

Information must integrate among multiple database and divide into two that is Forward Integration and Backward Integration.

Forward Integration takes information entered into given system and sends it automatically to all downstreams system and processes.

Backward Integration takes information entered into given system and sends it automatically to all upstream systems and processes.