The process used to normalize the truck fleet maintenance system database will be done by a three-stage method for normalization. The most important reason to normalize the truck fleet maintenance system database is for the data integrity.
The first stage in this process will be to find any redundancies in any of the information. In order to find the redundancies you will have to go through each table in the Truck fleet maintenance system database and figure out if there were any groups that were recurrent on each table. If there were any redundancies found, we then will make the necessary change needed to eliminate the redundancies from the truck fleet maintenance system database. After all redundancies have been removed we can start identifying dependencies within tables. In most cases Identifying the dependencies are usually done by figuring out which keys remain dependent on the other keys.
The next stage in this process of normalization will require the removal of partial dependencies that appear when there’s a combination primary key, which usually means there are two columns arranged together as primary keys. When this occurs in the truck fleet database it has to be removed by breaking down the table with the dependencies. This process will remove the partial dependencies
The third and final 3NF stage in this normalization process of the truck fleet maintenance system database will be to eliminate all of the transitive dependencies. This is usually seen when a key is dependent on another key, which is also nonprime. This will have to be removed, in order for the removal the nonprime, which has the dependency and the primary key of the new table and all of its dependencies are eliminate from the prior table and added to the new table. For the truck fleet maintenance system database it is now in 3NF. You will have to monitor the database to make any necessary changes and look out for any issues or problems with the tables that need attention.
Normalization. (n.d.). Retrieved from http://condor.depaul.edu/gandrus/240IT/accesspages/normalization3.htm