Storing Chapter Seven

Hello everybody. I haven't update my blog for a while now cause it has been hectic lately. This post will be about the seventh chapter which is Storing Organizational Information. This chapter is about relational database model, integrity constraints, business critical integrity constraints, data driven web site and methods for integrating information across multiple databases.

Information is everywhere in an organization. These information needs to be stored somewhere, and the right place is in a database. A database maintains information about various types of objects (inventory), events (transactions), people (employees) and places (warehouses). Database includes a few models such as hierarchical database model, information is organized into tree-like structure in such a way that it cannot have too many relationships. The second model is network database model, a flexible way of representing objects and their relationships. The last model is relational database model, stores information in the form of logically related two-dimensional tables.

Hierarchical Structure.

Network Structure

Relation Structure.

Entity is a person, place, thing, transaction or event about which information is stored. The rows in each table contain the entities. Meanwhile, attributes (fields, columns) is the characteristics or properties of an entity class. The columns in each table contain the attributes.

Primary keys and foreign keys identify the various entity classes (tables) in the database. Primary key is a field (or a group of fields) that uniquely identifies a given entity in a table. On the other hand, foreign key is a primary key of one table that appears an attribute in another table and acts to provide a logical relationship among the two tables

Potential Relation Database for Coca-Cola.

The advantages from a business perspective include increased flexibility, increased scalability and performance, reduced information redundancy, increased integrity and increased information security.

Database Management Systems (DBMS).

Software which user and application programs interacts with database.

Data Driven Web-Site.

An interactive Web site kept constantly updated and relevant to the needs of its customers through the use of a database.

Advantages of data driven website business are as below: 

• Development
• Content management
• Future expandibility
• Minimizing human error
• Cutting production and updating cost
• More efficient
• Improved stability

Data Driven Intelligence.

Integration allows separate systems to communicate directly with each other.

Forward integration takes information entered into a given system and sends it automatically to all downstream systems and processes.

While backward integration takes information entered into a given system and sends it automatically to all upstream systems and processes.

Integrating information among multiple databases is the concept of building a central repository specifically for integrated information. Without integration, an organization will spend considerable time entering the same info in multiple system and suffer from the low quality and inconsistency typically embedded in redundant info.

Thank you so much for reading! Have an amazing day!!