Question

In: Computer Science

How do you transform from first normal form to second normal form?

How do you transform from first normal form to second normal form?

Solutions

Expert Solution

Answer: To transform the first normal form into the second normal form, remove the partial dependency.

A relation is said to be in second normal form if there is no partial dependency in the relation.

Partial dependency: When a non-prime attribute functionally dependent on the part of a candidate key.

Example: Consider a relation R{ABCDE} with functional dependency A ->C, AB -> D, AB->E

The candidate key for the relation R is AB. C, D, E are a nonprime attribute. C is functionally dependent on A. A is part of the candidate key. So, due to the existence of the partial dependency A ->C this relation is not in the second normal form.

To convert this relation into the second normal form we need to remove the partial dependency.

First, find the closure of A

(A)+ -> AC

Now decompose the relation to remove partial dependency and create a separate relation.

                                                           

Now in both the relation R1 and R2 there is no partial dependency. The candidate key of R1 is AB and for R2 is A


Related Solutions

11. How do cells transform energy? Consider the first and second law of thermodynamics. 12. Describe...
11. How do cells transform energy? Consider the first and second law of thermodynamics. 12. Describe the chemical reactions that either release or stores energy. Remembering that energy must be conserved. what do you think happens to the energy we obtain from food during cellular respiration? photosynthesis? 13. What is this energy that drive ALL cellular work? Is it a renewable source? 14. Explain how ATP transfers energy from exergonic to endergonic processes in the cell. 15. How do enzymes...
1. triple integral... first form 0 to pi, second from 0 to pi/3, third to sec(phi)...
1. triple integral... first form 0 to pi, second from 0 to pi/3, third to sec(phi) to 2 of p^2*sin(phi) dp d(phi) d(theta) 2. triple integral... first form 0 to pi, second from -sqrt(3) to sqrt(3), third to 1 to sqrt(4-r^2) of r dz dr d(theta) 3. triple integral... first form 0 to pi/2, second from 0 to sqrt(3), third to 1 to sqrt(4-r^2) of r dz dr d(theta) 4. triple integral... first form 0 to pi, second from 0...
Create an example of a table that violates first normal form. Create an example of a...
Create an example of a table that violates first normal form. Create an example of a table that is in first normal form but violates second normal form. Create an example of a table that is in second normal form but violates third normal form. Please use own table or no plagiarism please.Thank you.
4) Laplace Transform and Solving second order Linear Differential Equations with Applications The Laplace transform of...
4) Laplace Transform and Solving second order Linear Differential Equations with Applications The Laplace transform of a function, transform of a derivative, transform of the second derivative, transform of an integral, table of Laplace transform for simple functions, the inverse Laplace transform, solving first order linear differential equations by the Laplace transform Applications: a) Series RLC circuit with dc source b) Damped motion of an object in a fluid [mechanical, electromechanical] c) Forced Oscillations [mechanical, electromechanical] You should build the...
Describe the six characteristics that cancer cells acquire, or lose, as they transform from normal cells....
Describe the six characteristics that cancer cells acquire, or lose, as they transform from normal cells. Provide an example for each characteristic and describe the types of DNA changes that may occur to cause such protein changes.
In a Servlet, how do you read HTML Form Data (data from the previous Web page)...
In a Servlet, how do you read HTML Form Data (data from the previous Web page) into the Servlet?
Assuming normal heptane and normal octane to form ideal solutions, do the following: d) Calculate the...
Assuming normal heptane and normal octane to form ideal solutions, do the following: d) Calculate the dew pressure of the solution at 40 ◦C. e) Calculate the bubble temperature at 1 bar. f) Calculate the dew temperature at 1 bar. g) Calculate the amount and composition of vapor and liquid when a solution with z1 = 0.45 is flashed to 40 ◦C, 0.065 bar. The saturation pressures of the two components are given by the Antoine equation: ln Pi sat...
How do you differentiate ‘Normal Process Losses’ from ‘Abnormal process Losses’. (6 marks)
How do you differentiate ‘Normal Process Losses’ from ‘Abnormal process Losses’.
Two words form a "metathesis pair" if you can transform one into the other by swapping...
Two words form a "metathesis pair" if you can transform one into the other by swapping two letters; for example, "converse" and "conserve". Write a function metathesis(word1, word2) to check if the two words can form a metathesis pair. The function will return a Boolean value (True or False). python code without using Zip method
Due to the corona virus, How much of a decline do you anticipate for the Second...
Due to the corona virus, How much of a decline do you anticipate for the Second Quarter of 2020? Will be in recession? This would mean GDP was down during the first quarter and/or the third quarter. Will it last long enough to be the second depression in 100 yeards?   On inflation/deflation,what would your life have been like during the early 80's when the inflation rate was in double digits? Imagine what life would have been like in Germany in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT