CHAPTER 7 : STORING ORGANIZATIONAL INFORMATION (DATABASE)

CHAPTER 7 : STORING ORGANIZATIONAL INFORMATION (DATABASE)

Assalamualaikum. Previous week, i learned a new chapter about Storing Organizational Information (Database).

RELATIONAL DATABASE FUNDAMENTAL.

- Information is everywhere in an organization.

- Information is stored in database.

Database : Maintains information about various types of objects (inventory), events (transactions), people (employees) & places (warehouse)

Database models include :

1) Hierarchial database model.

- Information is organized into a tree-like structure that it cannot have too many relationships.

2) Nerwork database model.

 - A flexible way of representing object and their 

relationship. 

ENTITIES AND ATTRIBUTES

-          Entity – a person, place, thing, transaction, or event about which information is stored.

Ø  The rows in each table contains the entities.

-     Attributes (fields, columns) – characteristics or properties of an entity class.

Ø  The columns in each table contain the attributes.

KEYS AND RELATIONSHIPS

-          Primary keys and foreign keys identity the various entity classes (tables) in the database.

Ø  Primary key – a fields (or group of fields) that uniquely identities a given entity in a table.

Ø  Foreign key – a primary key of one table that appears an attribute in another table and acts to provide a logical relationships among the two tables.

RELATIONAL DATABASE ADVANTAGES

-          Database advantages from a business perspective include;

Ø  Increased flexibility.

Ø  Increased scalability and performance.

Ø  Reduced information redundancy.

Ø  Increased information integrity (quality)

Ø  Increased information security.

INCREASED FLEXIBILITY

-          A well-designed database should;

Ø  Handle changes quickly and easily.

Ø  Provide users with different views.

Ø  Have only one physical views.