Volatile: A database system is very volatile. It is costly: A database will require substantial hardware and software start-up costs which makes them quite expensive when they are being set up.ģ. Complexity: Database systems are complex, difficult, and time-consuming to design hence requiring a substantial amount of work.Ģ. This report is based on real-time data that keeps on updating within the database.ġ. Can provide complex reports: A database can be used to pull reports in any desired format for presentation. Can contain text or numbers: A database can store information in more than one single format including numbers and letters.ġ8. Data querying possible: You can ask questions about the data (‘querying’) and pull the information into a formatted report in the desired format.ġ7. Database and reporting features are separate: This means you can generate multiple reports from the same data (ask it lots of questions)ġ6. This means the data to be stored is basically unlimited and can be accessed at any time.ġ5. Large storage capacity: Databases can store very large amounts of data at any given point in time. Long-term storage: Databases are good for long-term storage of records that are subject to changes periodically.ġ4. Multiple access: It is easier for more than one person to access the file at once which makes databases more versatile.ġ3. Minimize irregularities: There are very few chances of irregularities when dealing with data within a database as opposed to other data manipulation systems.ġ2. Reduce duplication: A database plays a vital role in ensuring data integrity and reduction of redundancy which eliminates instances of data duplication.ġ1. Can handle large amounts of data: A Database is much more powerful and manageable when handling large amounts of informationġ0. Provide data integrity: A database is a secure application that guarantees all users’ data integrity that is free from external manipulation.ĩ. Facilitated development of new applications program: A database is an ideal tool that helps in the development of new application programs that depend on the data stored in the DBMS.Ĩ. Reduced data entry, storage, and retrieval costs: A database management system provides easy and fast data entry, storage, and retrieval all in one system which significantly reduces the cost of manipulating data.ħ. This guarantees the safety and security of the data stored.Ħ. Improved data security: The data stored in a database is often secure and free from any manipulation and interference from other computer applications. Improved data access to users through the use of host and query languages: It is easy for users to access all relevant data in a database through the use of hosts and query languages such as SQL.ĥ. Greater data integrity and independence from application programs: Database Management Systems (DBMS) are often independent of any other computer programs and can be accessed by all other applications.Ĥ. Also, there are few incidences of data errors within a database which creates consistency.ģ. Reduced updating errors and increased consistency: A database offers the end-user consistency in its operation, be it in data analysis or updating the data. A database will eliminate any data redundancy occurrence before the data is presented to the end-user.Ģ. Reduced data redundancy: Databases play an important role in the reduction of data redundancy within a computer application. Below are some of the pros and cons of databases.ġ. The data captured is well organized in a manner that can easily be accessed, managed, and updated as and when the need arises. A database is a computer application that interacts with end-users, other computer applications, and software to capture, store and analyze data.
0 Comments
Leave a Reply. |