Dbm 380 Database Normaliztion

Database normalization explanation Robert A. Holland DBM/380 December 11th, 2011 fundament Nadasky Database normalization explanation The normalization train that I chose to use for my infobase was the 3NF aim. This take of normalization was chosen because it would be unaccented sufficiency to attention deficit hyperactivity dis put together and take data to without twain complications or problems in the database. This take of normalization states that and is described as follows (Stephens, 2009): 1. distributively column essential acquit a left(p) name. 2. The order of the rows and columns does non matter. 3. distributively column must gift a single data type. 4. No two rows tin can comport identical values 5. Each column must claim a single value. 6. Columns cannot check into repeating groups. 7. All of the non-key vault of heaven depend on either of the key bailiwicks. 8. It contains no transitive dependencies. This level is sufficient enough for the database created because many other(a) databases are created at this level of normalization. It is easy to add or remove data to the database in this level and not hold to sit about relationships be done for(p) or running into major(ip) database cast flaws.

The relationships and keys depend on separately other to be in the database and cannot be deleted because the database depends on them. The keys that were chosen to be utilize in the database were chosen for the fact that the field they are in would never be deleted. This in tour would then puff the relationships stronger and execute them that they would also stay and not be deleted or changed by any alterations to the database. The changes that were made to the database were much on a format need and to identify the entities to a greater extent in the database and the tables they were include in. thither are no other changes that can be ruling of to change the database design. Some field could be mown and recreated to some other field, but then this would perish fields that may mayhap end up being empty in the database and have no data....If you want to move a near essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper