-
Essay / Database Essay - 972
Since their inception, databases have been among the most sought-after areas of knowledge in computer science. Database is a generic term used to refer to the collection of similar or related information/data in an organized and integrated manner, so that it can be easily accessed, managed and updated. Kroenke 2010 refers to the database as a set of tables plus the relationships between the rows in these tables, as well as special data (metadata) that describes the structure of the database. From the above, we can simply define database as a repository of data intended to facilitate effective and efficient storage, retrieval, maintenance and dissemination of data. How are they used? As Faubl 2011 states, databases are primarily created for three main functions; to organize, store and retrieve information in the most effective and efficient way possible. Basically, this forms the basis of why and how to use the database. To use a database, you must first determine the purpose of the database you intend to create, then collect and organize the required information, create the logical and physical data models. However, its fields of application are multidisciplinary and cut across different sectors of the economic, social and political spaces in which the three main functions are exercised. These areas of application may include, but are not limited to: The government must record information such as statistics, election information, and tax records, among others; Police for the management of criminal records; Banks to store, track and analyze all customers and their associated transactions; Department of Motor Vehicles to maintain records and history of drivers and vehicles. A database management system (DBMS), sometimes used interchangeably with the terms database server, database system...... middle of paper ...... special models or concepts ; discs and sets. Records include fields that can be organized hierarchically, while sets establish one-to-many relationships between defined records. This database normally presents a divergence from the previous hierarchical database discussed previously, as it is designed on the concept of multiple branches originating from one or more nodes while the models vary from the hierarchical one in that their branches can be linked to several nodes. These databases are able to represent any data redundancy more effectively and efficiently. Network database operations are usually done by navigation, that is, the program maintains the current position and moves from one record to another following the defined relationship according to which the file is involved . Records can also be located by providing key values.