mis582 week 2 discussion (dq1+dq2) latest 2017

Subject: General Questions / General General Questions
Week 2 discussion


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?


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?


We can do it for you