Question: 1 . What is normalization? 2 . When is the table in 1 NF ? 3 . When is a table in 2 NF ?

1. What is normalization?
2. When is the table in 1NF?
3. When is a table in 2NF?
4. When is a table in 3NF?
5. Identify and discuss each of the indicated dependencies in the dependency diagram shown below:
6. Fill in the blanks:
a.________________________ produces a lower normal form.
b. Any attribute whose value determines other values within a row is called a(n)__________________________.
c. An attribute that cannot be further divided is said to display _______________.
d._______________________ refers to the level of detail represented by the values stored in a tables row.
e. A relational table must not contain ______________________ groups.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!