ITC556 Assignment 3 Normalisation

Home Assignment Answers ITC556 Assignment 3 Normalisation

What is Normalization?

Normalization is the database design technique which helps in organizing table in a manner which helps in reducing redundancy and dependency of data which exists within the tables. It is also responsible for dividing larger tables to smaller tables and link them using relationships. Normalization is mainly used for two purposes which are as follows:
• Elimination of redundant data
• Ensuring data dependencies which make sense that data is logically stored.

Problems without Normalization

If the tables are not properly normalized and have data redundancy then it will not require extra memory space, but unfortunately it will become difficult to handle and update the database without facing any database loss. The three problems which are very frequent and will arise when database is not normalize is updation, deletion and insertion anomalies.

Normalization Rule

Normalization rules are divided into various normal forms which are as:
• First Normal form
• Second Normal Form
• Third Normal Form
• BCNF

First Normal Form

To be in a first normal form, the table should have single valued attributes. Along with this, the columns in table must have unique names.
• Each table cell should consist of a single value
• Each record in table must be unique.

Table name: Book_Records

 

ISBN

Title

Edition

Media

Publisher

Date

 

Table name: Author_Records

 

ISBN

Author_LastName

Auhtor_FirstName

Second Normal Form

To be in second normal form, the table must be in first normal form as well as there should be no partial dependency between the columns in table.
• Table must be in 1st  normal form
• Partial dependencies must not exist in the table

Table Name: Author_Records

 

ISBN

Author_LastName

Auhtor_FirstName

Note: As there was no partial dependency in the table, so in second normal form will remain the same as in first normal form.

Third Normal Form

To be in third normal form, the table must be in second normal form as well as there should not be any transitive dependency in the table.
Steps which are to be practiced are as:
• Table must be in 2nd  normal form
• Transitive dependency must not exist in the table

Table name: Publisher_Records

 

Publisher

Media

Search Here

Latest Reviews

  • Marcus
    30 Apr, 2019

    My assignment help services are provided in the best way by this website. The writers have completed my assignment in such a way that they helped me increase my overall performance.

  • Emy
    29 Apr, 2019

    Awesome work done by the experts of this company. I visited this site to get math assignment completed. My assignment was complete in every aspect. Thanks to the professionals who provided assignment writing help.

  • Darina
    25 Apr, 2019

    All thanks to the writers of Assignment Help 4 Me who completed my Physics assignment in the right manner. The structure of the assignment was totally customized according to my needs and that too at cheap prices.

View All Reviews

Facebook

Assignment Help 4 Me