Database Applications Research Paper Example | Topics and Well Written Essays - 500 words - 1

Database Applications - Research Paper Example It mainly focuses on the safe management and maintenance of data, and providing access to multiple applications and users simultaneously. Despite its complexity as compared to flat text files and spreadsheets, it actually makes things easier considering the weaknesses of the latter (i.e. redundant information, outdated data, file size, complex protection of data from unauthorized use and from becoming corrupt), particularly when working with large-scale applications. These issues aforementioned are taken cared of Relational Database Management System (RDBMS), such that the flexibility and security of data outweighs the complexity of the system. Codd's idea was to break down a long row of data fields into smaller tables describing specific subsets of the data collected, ultimately reducing the data footprint and cost. Furthermore, it enforces data integrity by ensuring data type correctness (by using strong data types), eliminating redundant data (by saving data entities in just one p lace), disallowing harmful deletes (by using key constraints), and guarantees efficient retrieval and manipulation of data (by splitting up data into chunks). With SQL Server 2005 Express Edition, you get the advantages of RDBMS.