Advantages of Database Approach Flashcards
Eliminate the redundancy by integrating the file.
Control of Data Redundancy
It controls the amount of redundancy inherent in the database.
Control of Data Redundancy
It ensures all copies of the data are kept consistent.
Data Consistency
It may be possible to derive additional information for the same data
More Information
Database belongs to the entire organization and can be shared by all authorized users
Sharing of Data
Database integrity provides the validity and consistency of stored data.
Improved Data Integrity
It is usually expressed in terms of constraints, which are consistency rules that the database is not permitted to violate.
Integrity
Database approach provides a protection of the data from the unauthorized users.
Improved Security
The integration of the database enforces the necessary standards including data formats, naming conventions, documentation standards, update procedures and access rules.
Enforcement of Standards
Cost savings can be obtained by combining all organization’s operational data into one database with applications to work on one source of data.
Economy of Scale
By having a structural design in the database, the conflicts between users or departments can be resolved. Decisions will be based on the use of resources for the organization as a whole rather that for an individual entity.
Balance of Conflicting Requirements
By having an integration in the database approach, data accessing can be crossed departmental boundaries. This feature provides more functionality and better services to the users.
Improved Data Accessibility and Responsiveness
The provision of these functions allows the programmer to concentrate more on the specific functionality required by the users.
Increased Productivity
Database approach provides a data independence. As a change of data structure in the database will not affect the application program, it simplifies database application maintenance.
Improved Maintenance
Database can manage concurrent or simultaneous data access effectively. It ensures that here is no interference between users and that would not result any loss of information nor loss of integrity.
Increased Concurrency
