mis582 week 2 discussion (dq1+dq2) latest 2017
mis582 week 2 discussion (dq1+dq2) latest 2017
Subject: General Questions / General General Questions
Question
Week 2 discussion
DQ1
Normalizing the Database
Consider the following entity and its attributes. INVOICE (Number, Customer Name, Customer Number, Customer Address, Item Number, Item Price, Item Quantity, Sales Person Number, Sales Person Name, Subtotal, Tax, Total Due)
What issue does this entity have that can be solved by normalization?
What functional dependencies exist between the attributes?
How would you apply normalization to break this into more than one entity, each with a single theme?
DQ2
The Different Normal Forms
Many texts and articles will state that normalization to 3NF is sufficient.
Are there database environments that would require normalization to a higher normal form?
How about environments that do better when is there normalization to a lower normal form?
Why do you think there are so many different normal forms to choose from?
