Please enable JavaScript.
Coggle requires JavaScript to display documents.
Chap 7 : Storing Organizational Information - Databases - Coggle Diagram
Chap 7 : Storing Organizational Information - Databases
Fundamental concepts of the relational database model
The relational databse models stores information in the form of logically related two-dimensional tables
Entites, attributes, primary keys, and foreign keys are all fundamental concepts included in the relational databse model
The advantages of the relational database model
Database advantages from a business perspective include
Increase flexibility
Increased scalability and performance
Reduced information redundancy
Increased infromation integrity (quality)
Increased information security
The difference between operational integrity constraints and business-critical integrity constraints
Operational integrity constraints are rules that enforce basic and fundamental information-based constraints
Business-critical integrity constraints are rules that enforce business rules vital to an organization's success and often require more insight and knowledge than operational integrity constraints
The benefits of a data-driven website
Development
Content management
Future expandability
Minimizing human error
Cutting production and update costs
More efficient
Improved stability