1) The fundamental concepts of the relational database model
• Database models include:
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
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.
2) The advantages of the relational database model
Database advantages from a business perspective include:
Ø Increased flexibility
Ø Increased scalability and performance
Ø Reduced information redundancy
Ø Increased information integrity (quality)
Ø Increased information security
3) The definition of a DBMS and Data Driven Website
Database management systems (DBMS) –
software through which users and application programs interact with a database
Data-driven websites –
an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database.
4) The two primary methods for integrating information across multiple databases
Integration – allows separate systems to communicate directly with each other
a) Forward integration – takes information entered into a given system and sends it automatically to all downstream systems and processes
b) Backward integration – takes information entered into a given system and sends it automatically to all upstream systems and processes
Advantages:
- development
- content management
- future expandability
- minimizing human error
- cutting production and update costs
- more efficient
- improved stability
0 comments:
Post a Comment