PT2520 Week 3 Forum

Topics: Relational model, Computer program, Requirement Pages: 2 (190 words) Published: January 7, 2015

Does the diagram meet all three levels of normalization? Explain your answer. Normalization is a process for evaluating and correcting table structures to minimize data redundancies and by helping to eliminate data anomalies. It helps evaluate table structures and produce good tables. Normalization is a very important database design that you should not assume that the highest level of normalization is always the most desirable. The higher the normal form is the more joins are required to produce a specified output and the more slowly the database system responds to end-user demands. A successful design must also consider end-user demand for fast performance you will occasionally be expected to de-normalize some portions of a database design in order to meet performance requirements. De-normalization produces a lower normal form. Normalization process you and will need to examine a business application. In this case you need to explore the simplified database activities of a company that manages several building projects each project has its own project number, names of employees assigned to it and so on. Each employee has an employee number, name and job classification such as engineer or computer technician.
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • PT2520 Week 1 Assignment Essay
  • Essay about Week 3
  • MAT540 Week 3 Homework Essay
  • PT2520 Week 4 Essay 4142015
  • week 3 Essay
  • Week 3 Essay
  • Week 3 Essay
  • week 3 Essay

Become a StudyMode Member

Sign Up - It's Free