Ask Question
19 August, 23:42

discuss the benefits of normalization, and do you think we should normalize our designs to higher levels than 3NF? Why or why not?

+3
Answers (1)
  1. 20 August, 00:47
    0
    Normalization allows us to design database tables efficently. it reduces data redundancy and avoid data anomalies

    Explanation:

    Normalization on database can go till 3rd NormalForm. BCNF is always not possible to apply on all tables. so BCNF and Higher Normal forms which is dependent on BCNF is always not possible to apply on all database designs. In general we will go till 3rd normal form. 1st normal form illustrates that there should not be any repeating data in a record it should be atomic. 2nd normal form illustrates that it should be in 1st normal form and if any composite key exist then all remaining values should dependent on that composite key. 3rd normal form illustrates that if should be in 2nd normal form and all keys should dependent directly on primary key.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “discuss the benefits of normalization, and do you think we should normalize our designs to higher levels than 3NF? Why or why not? ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers