Memo Week 3 Dbm 381

Topics: Database normalization, First normal form, Second normal form Pages: 2 (329 words) Published: November 10, 2012
Database Management Memorandum

DBM 381

Database Management Project

Attn: Technical Services/Logistics Manager

Memorandum Overview

This memorandum is created to explain normalization, its level and why it is sufficient for the system. We are all aware that Microsoft Access database is the best fit for the Taylor Ambulance Company. This database will be efficient in storing, tracking and billing incidents. To reduce redundancy in the system, it is important to apply normalization. Normalization is the processes where data are organize in a database. This process includes creating tables and establishing keys and relationships of data between the tables. Normalization will also make the database more flexible, in which redundancy will be reduced and possibly completely eliminate. This will also reduce inconsistence dependency. It will also be faster to create queries between tables after the data is normalize. A non-normalize database is full of redundant data and it is unorganized. In efficiently storing data in the database, and eliminate redundancy, normalization is applied to be in five possible normal forms. Each form contains and enforces rules and some applies stricter rules based on the tables design. For the proposed database, we are using the third normal form design. This form will eliminate fields that do not depend on the key. In this form, tables meet the criteria for second normal form. Data that are not part of the key records will not be included in the tables. In other words, data that applies to more than one single record in the table will be placed in a separate table. The third normal form is more ideal because the data gathered by Taylor Ambulance Company frequently changes.

Overall, normalization is an important process to implement to ensure of the elimination of redundancy. Advantages of normalization process have great benefits that could help the organization’s...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Dbm 381 Week 1paper
  • Essay about Dbm 381 Week 1 Individual
  • Week 3 Memo Draft Research Paper
  • Essay on DBM/380
  • Essay about Week 3
  • Week 3 questions and problems Essay
  • MAT540 Week 3 Homework Essay
  • DBM 310 Week 4 Essay

Become a StudyMode Member

Sign Up - It's Free