Relational database solution Essay Example | Topics and Well Written Essays - 500 words

Relational database solution - Essay Example Therefore this need has led to introduction of various data storage solutions. One very well known model for database management is the rational database solution. A relational data base can be explained or defined as a collection of data or information. The data is then stored in tables where it can be accessed or rearranged in different ways without changing the arrangement of the tables. Relational data base was invented in the 1970 by Edgar Codd at IBM Harrington (2004). The relational database management system is based on the relational model theory. A relational database model has a set of tables which are designed to hold data after collection. The data is arranged and put in categories which have a set order. Each of the tables which are also known as a relation has either one or more data groups in columns. Every row has a set of data for each of the categories and is defined by the columns Harrington (2004). A good example is when an entry in a normal business order database has a table that gives a description of a customer which includes columns for the name, an address and a phone number. In addition there can be another table describing an order with columns for; the product name, date, customer name, the sales price. Therefore any person assigned to use the database can get access the database depending on what information they want to gather. For example a branch office manager might want to view a report on company clients that have bought either a product or a service in a particular date. Many of today’s businesses rely on their database systems for accurate and up to date information Suad (2005). Without this much needed information business organizations find themselves in tough situations such as strategic planning as well as corporate decision making. On the other hand for it to be useful to a business organization or a firm, it must be accurate, complete and organized in such a way that data can be retrieved when needed and in