Question 1:
Post 2-3 detailed paragraphs on one of the following topics:
1) What
is a partial dependency? With what normal form is it associated?
What 3 data anomalies are likely to be the result of a data redundancy
and how can they be eliminated? Give examples.
2) Explain
the concept of transitive dependencies. How are they identified and how
are they removed? Give examples.
Question 2:
Research and provide one to two pages. Pick one of the
following questions:
1.
Why is normalization an important step in
database development?
2.
What would you give as a broad description of
normalization?
3.
Does normalization dictate the database physical
design, why or why not?
4.
What are BCNF, 4NF, and 5NF used for, when are
they used?
5.
Why would denormalization be applied;
provide an example?
Be sure to
cite your references.
Please share both the
answers in separate word documents
Need Assignment
in below format Format
First Question as written in the assignment:
[Paste it here.]
Critical thinking: My
guess answer is (in your own words)
Reference #1 –
What does the book say about the question:
Use the bibliograghy for our book after the quote in APA form.
Reference #2 –
What does the Internet say about the question (or another resource): Paste it here
with the link to the website in APA form.
How did your guess and the two references answers
differ?
Were you wrong? Were
you right?
What do you think the right answer is now in your own words.
0 comments