Discuss how normalization may be used in database design.

      

Discuss how normalization may be used in database design.

  

Answers


kelvin
Normalization can be used in database design in two ways: the first is to use normalization as a bottom-up approach to database design; the second is to use normalization in conjunction with ER modeling.
Using normalization as a bottom-up approach involves analyzing the associations between attributes and, based on this analysis, grouping the attributes together to form tables that represent entities and relationships. However, this approach becomes difficult with a large number of attributes, where it’s difficult to establish all the important associations between the attributes. Alternatively, you can use a top-down approach to database design. In this approach, we use ER modeling to create a data model that represents the main entities and relationships. We then translate the ER model into a set of tables that represents this data. It’s at this point that we use normalization to check whether the tables are well designed

kevowmuchiri answered the question on July 9, 2018 at 18:57


Next: With the aid of an appropriate example, explain what economists mean by the term public good.
Previous: Describe the types of update anomalies that may occur on a table that has redundant data.

View More Computer Science Questions and Answers | Return to Questions Index


Exams With Marking Schemes

Related Questions