Please enable JavaScript.
Coggle requires JavaScript to display documents.
STORING ORGANIZATIONAL INFORMATION-DATABASES - Coggle Diagram
STORING ORGANIZATIONAL INFORMATION-DATABASES
Relational database Fundamental
Information is everywhere in an organisation
Database - maintain information about various types of objects, events, people, and places
Hierarchical database model - information is organised into into a tree-like structure.
Network database model - a flexible way of representing objects and their relationship
Rational database model - stores information in the form of logically related two-dimensional table
Entity - a person, place, thing, transaction or event about which information is stored
Attributes - characteristics or properties of an entity class
Keys and relationship
Identify the various entity classes in the database
Primary key - a group of fields that uniquely identifies 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 relationship among the two table
Rational database information
Increased flexibility
Handle changes quickly and easily
Provide users with different view
Only one physical view
Multiple logical view
Increased scalability and performance
Must scale to meet increased demand, while maintaining acceptable performance level
scalability - refers to how well a system can adapt to increase demands
performance - measures how quickly a system performs a certain process or transaction
Reduces information redundancy
Redundancy - the duplication of information or storing the same information in multiple places
inconsistency is one of the primary problems with redundant information
Increase information integrity
Measures the quality of information
Relational integrity constraint
Business critical integrity constraint
Database management system
Software thru which users and application programs interact with databases
Direct interection
Indirect interaction
Data driven web sites
an interactive web site kept constantly updated and relevant to the needs of customers through the use of database
Advantages
Development - Allow website owner to make changes
Content management - a static website requires a programmer to make update
Future expendability - enables for site to grow faster
Minimizing human error - maintaining many pages
Cutting production and update cost - can be updated and "published" by any competent data entry
More efficient - computers are excellent at keeping volumes of information
Improved stability - to keep track of all the sources of files
Integrating information among multiple databases
Allows separate system to communicate directly with each other
Forward integration
Backward integration