Dbm 380 Database Normaliztion

Database standardisation business relationship Robert A. Holland DBM/380 December 11th, 2011 John Nadasky Database normalization explanation The normalization direct that I chose to use for my database was the 3NF level. This level of normalization was chosen because it would be halcyon replete to add and coming back data to without both complications or problems in the database. This level of normalization states that and is described as follows (Stephens, 2009): 1. solely(prenominal) column must guide a unmatched name. 2. The order of the rows and columns does not matter. 3. Each column must have a single data type. 4. No two rows bum comport identical values 5. Each column must strike a single value. 6. Columns cannot contain repeating groups. 7. All of the non-key athletic field depend on all of the key palm. 8. It contains no transitive dependencies. This level is sufficient enough for the database created be cause many early(a) databases argon created at this level of normalization. It is easy to add or delete data to the database in this level and not have to amaze about relationships being unmake or running into major(ip) database design flaws.

The relationships and keys depend on severally 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 release would then puff the relationships stronger and enforce them that they would also stay and n ot be deleted or changed by any alterations ! to the database. The changes that were made to the database were much on a formatting need and to identify the entities more(prenominal) in the database and the tables they were include in. There are no other changes that can be thought of to change the database design. Some fields could be mown and recreated to another field, but then this would bestow fields that may possibly end up being empty in the database and have no data....If you want to happen a near essay, order it on our website: BestEssayCheap.com

If you want to get a full essay, visit our page: cheap essay