Introduction
An organization needs the right amount of workforce as well as the right amount of personnel to bring in the best amount performance that they are expected to deliver. The performance that is to be delivered by the organization is based on the number of goals the organization seeks to satisfy. These goals are however set by the organization depending on their nature of work as well as their needs in the organization. Many of the organizations would choose the people that are to become future employees by looking at how they are able to conform to the different competitive world as well as improve the value of the company. If the employees do not meet the requirements of the company, the company is usually forced to lay off some of the workers in a bid to stay to the course that they wish to remain. Regulations are always drawn to ensure that the process of the choosing the people to enter the company limits the number of the people being employed by the company to the desired number. In a technology firm, the same method is applied if the company is not satisfied with the achievements of the workers.
A relational database is the cumulative collection of data items. These items are then organized into sets of tables through which the same data may be is assembled and be re-assembled. Each table in this type of database relation is built out of rows and columns. This are however referred to as attributed and tuples when one is using the relational theory .The data in the database is organized into tables that contain five pre-defined categories that are used to store the necessary data that is needed by the program. This type of database uses structured query language, and the user can access the data by use of an application that can access data from the database and present it to a user in a manner that he can understand. In a database that has been organized well, there are no repetitions in terms of the nature of the data that is stored.
Relational database systems are very important since they ensure that data that is saved on the system remains in a single unit and does not replicate the data that is stored in the system. the relational database system is also considered to be the best since it is most effective when compared to other database systems. The relational database system is also useful in companies and other government structures when they need to fill in the information of a person. The relational database is what has made possible the storage of this data and thus has made it easier for the government offices to obtain the information about anyone whenever they need. Relational databases are also needed since they are used to separate the information about a person and are used in many institutions.
Database normalization is the process of rearranging the different fields and tables that are found in a database so that the fields may be free from anomalies that may occur in the system. The problems may also be in the form of redundant data. The anomalies are thus the occurrences that are responsible for the weakening the integrity of the data that is stored. Normalization seeks to eliminate these types of anomalies in the design. This process of organization of the data in the database system also seeks to ensure that data dependencies that may occur in the system make sense. This is always done when a database is poorly designed.
The process of normalization is important to the database systems is important since it organizes the data in a logical manner. Apart from the logical organization of the data, anomalies and redundancy are also removed from the database system. this also minimizes the amount of duplicated data. Through the process, more space is freed by this process and this makes sure that more data can be stored in the system. The process of normalization ensures that one can access and use the data that is stored in the database system more effectively and quickly. After the process of normalization, the nature of modification incase one does a modification will only affect one place and not the entire database system.
The logical database model presents the data as models compared to the physical database model where this deals with the construction of database systems only. This is a key difference that occurs between the two groups. The logical database model creates the data stored in form of diagrams. These are entity relationship diagrams that show the different relationships between different data. The logical database modeling thus does not include the use of constraints and indexes in the designing of such systems and is used across database software. The physical database modeling on the other hand is concerned with constraints and indexes and is thus used in the modeling of certain hardware specific and software.
