Scribd
Upload
11 views1 page

Data Analysis Challenges and Normalization

The document outlines an activity involving data analysis based on Table 1, requiring identification of four potential challenges with justifications. It also asks for the characteristics of the first three normal forms (1NF, 2NF, and 3NF) and includes a task to normalize data using a provided dependency diagram up to 3NF. The activity emphasizes understanding data normalization and its associated challenges.

Uploaded by

Aaliyah Andrea
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
11 views1 page

Data Analysis Challenges and Normalization

The document outlines an activity involving data analysis based on Table 1, requiring identification of four potential challenges with justifications. It also asks for the characteristics of the first three normal forms (1NF, 2NF, and 3NF) and includes a task to normalize data using a provided dependency diagram up to 3NF. The activity emphasizes understanding data normalization and its associated challenges.

Uploaded by

Aaliyah Andrea
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Activity

Table 1

Questions

• Looking at Table 1 above, what potential challenges might arise when analysing
the data? Mention four challenges with justification. (8)
• State the characteristics of 1NF,2 NF and 3NF (6)
• Use the below dependency diagram below to normalize data until the 3NF. (14)

Dependency Diagram

You might also like