BUSINESS DRIVEN TECHNOLOGY
CHAPTER 7 : STORING ORGANIZATIONAL
INFORMATION-DATABASE.
TABLE OF CONTENT
1.0 Storing organizational information
2.0 Relational Database Fundamentals
2.1 Entities and Attributes
2.2 Keys and Relationships
3.0 Relational Database Advantages
3.1 Increased Flexibility
3.2 Increased Scalability and Performance
3.3 Reduced information Redundancy
3.4 Increased Information Integrity ( Quality )
3.5 Increased Information Security
4.0 Database Management Systems
4.1 Data Driven Web Site
5.0 Integrating Information among Multiple Database
5.1 Data-Driven Web Site Advantages
6.0 References
1.0 STORING ORGANIZATIONAL INFORMATION
Information is everywhere in an organization. Organizational information is stored
in a database. The computer program used to manage and query a database
is known as a database management system (DBMS).
The concept of a database is that :
· A collection of record.
· Pieces of information.
Typically database has a structural descriptive as known as scheme of the types
of fact in that database were describes the object and relationship among them.
2.0 RELATIONAL DATABASE FUNDAMENTALS
Database maintains information about various types of objects(inventory),
events (transactions), people (employees), and places (warehouse).
2.1 Entities and Attributor.
Entity - A person, place, thing, transaction, or event about which information is
stored.
- The rows in each table contain the entities.
Entity class (table) - a collection of similar entities.
- CUSTOMER, ORDER, ORDER LINE, PRODUCT and
DISTRIBUTOR.
Attributes (fields, columns) - characteristics or properties of an entity class.
- CUSTOMER contain CUSTOMER ID,
CUSTOMER NAME, CUSTOMER PHONE
NUMBERS.
- PRODUCT contain PRODUCT ID,
PRODUCT DISCRIBTION and PRICES.
2.2 Keys and relationship.
Primary keys and foreign keys identify the various entity classes (tables)
in the database
· Primary keys – a field (or group of field) that uniquely identifies a given entity
in a table.
· Foreign keys – a primary key of one table that appears an attribute in another
table and acts to provide a logical relationship among the two tables.
3.0 RELATIONAL DATABASE ADVANTAGES
3.1 Increased flexibility
- Can handle changes quickly and easily.
- It mirrors business structure.
- Provided user with difference views.
-A database has only one physical views.
3.2 Increased scalability and performance
- A database must scale to meet increased demand and maintaining acceptable performance levels
· Scalability-refers to how well a system can adapt to increased demands in organization.
· Performance- measures how quickly a system performs a certain process or transaction.
- can handle a hundred or thousand user online included internal or external user
who want to access or share information.
3.3 Reduced information redundancy
- Redundancy- The duplication of information or storing the same information at many places.
- Inconsistency is one of the primary problems with redundant information.
3.4 Increased information integrity (quality)
3.5 Increased information security
-Information is like an asset to us we must to protect.
· Database offer several security features including :
- Passwords : provide authentication of the user.
- Access levels : determine who has access to the different types of information.
- access controls – Determine types of user access.
4.0 DATABASE MANAGEMENT SYSTEMS
- Database Management Systems (DBMS) – software through which user
and application programs interact with a database.
4.1 Data-Driven Web Sites
- Data-Driven web sites – is an interactive web site keep constantly update
and relevant to the need of customers used the database.
· Four component database management system
5.0 INTEGRATING INFORMATION AMONG MULTIPLE DATABASE
· Organizations typically maintain multiple systems, each with its own database.
· Integration – allows separate systems to communicate directly with each other.
· Forward integration – takes information entered into a given systems and sends it automatically to all downstream systems and processes.
· Backward integration – takes information entered into a given system and sends it automatically to all upstream and processes.
5.1 Data-Driven Web Site Advantages
 |
A forward and backward customer information integration example
Integrating customer information among Database
6.0 REFERENCES
· BUSINESS DRIVEN TECHNOLOGY TEXT BOOK, INTERNATIONAL EDITION 2009.
