Databases Coursework Example | Topics and Well Written Essays - 1000 words

Databases - Coursework Example Relational databases use specific integrity rules to facilitate accurate collection of data and to make that data accessible. Firstly, the rows in a relational database must all be unique. In case of duplicate rows problems can crop up when resolving which of the two likely selections is the right one. For most DBMSs (databases management systems) users are able to specify that duplicate rows are not permitted, and when that is done the DBMS will block the addition of any rows that are identical to an existing one. Another integrity rule of relational databases is that column values should not be repeating arrays or groups. The third involves the logic of a null value. A database handles situations where information may not be available by employing a null value to show that a value is absent (Pathak, 2008). It is not equal to a blank or zero; a blank is equal to another blank and a zero is only equal to another zero. Two null values are not equal. When each row in a table is unique, it is possible to use one or more columns to mark a specific row. This distinct column or group of columns is referred to as a primary key. Any column that forms a primary key cannot be null; in any case it were the primary key which it is a part of would cease to be a complete identifier. This rule is known as entity integrity. Relational databases can greatly enhance the quality control and accessibility to organizations’ sensitive and valuable information materials. It can contribute towards a competitive edge by facilitating business analysis that can help to determine methods of improving products and services (Pathak, 2008). In comparison to non-relational database settings, relational databases are more flexible hence easily adapt to dynamic business needs. In addition, unlimited access to sensitive data means better data for more effective decision-making. Relational databases can also have a huge positive impact on numerous MIS