Scribd
Upload
25 views1 page

Exercise 1 Normalization

The document outlines a series of questions and exercises related to the concept of normalization in databases. It covers topics such as data redundancy, the advantages of normalization, and the identification of problems in un-normalized tables. Additionally, it prompts the reader to discuss database anomalies and their types with examples.

Uploaded by

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

Exercise 1 Normalization

The document outlines a series of questions and exercises related to the concept of normalization in databases. It covers topics such as data redundancy, the advantages of normalization, and the identification of problems in un-normalized tables. Additionally, it prompts the reader to discuss database anomalies and their types with examples.

Uploaded by

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

Exercise 1: Normalization

Name: _____________ & ________________


1. What is the concept normalization? Explain normalization based on your understanding.

2. What is data redundancy?

3. How do normalization avoid redundancy?

4. What does decomposition of a relation mean?

5. What is the major advantage of normalization?

6. Look at the relation/table on page 2, create the table using MS-Access, review the table
and answer the questions:
a. What problems do you see on the table? Identify the major problems?

b. What are the problems we can face if we proceed without normalization?

c. What is the need of normalization regarding the given example?

7. Develop one un-normalized table based on the above example. Identify its problems.
8. What are database anomalies?

9. Discus on the different types of anomalies with examples

You might also like