Please enable JavaScript.
Coggle requires JavaScript to display documents.
Viewing and Protecting Organizational Information - Coggle Diagram
Viewing and Protecting Organizational Information
Information is everywhere in an organization which, it is stored in databases
Database Model
Network database model
a flexible way of representing objects and their relationships
Relational database model
stores information in the form of logically related two-dimensional tables
Hierarchical database model
information is organized into a tree-like structure (using parent/child relationships) in such a way that it cannot have too many relationships
Entity – a person, place, thing, transaction, or event about which information is stored
Attributes (fields, columns) – characteristics or properties of an entity class
Primary key – a field (or 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 tables
Integration
allows separate systems to communicate directly with each other
Backward integration
Building a central repository specifically for integrated information
Forward integration
Database management systems (DBMS
software through which users and application programs interact with a database
Data-driven Web sites
an interactive Web site kept constantly updated and relevant to the needs of its customers through the use of a database
Data-driven Web sites Advantages
Development
Content management
Cutting production and update costs
Future expandability
Minimizing human error
More efficient
Improved Stability
Data-driven Web sites are especially useful when the site offers a great deal of information, products, or services.
Web site visitors are frequently angered if they are buried under an avalanche of information when searching a Web site.
Database advantages from a business perspective
Reduced information redundancy
Redundancy
Increased information integrity (quality
Information integrity
Integrity constraint
Relational integrity constraint
Business-critical integrity constraint
Increased scalability and performance
Scalability
Performance
Increased information security
Password
Access level
Access control
Increased flexibility
Physical view
Logical view
