Question

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

Answer 1

Answer:

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.