After re-studying and looking over Normalization, I pose some questions:
1) It says in the coursepack and handouts that for 1NF you should remove all repeating groups and put them in another relation. However, I believe it also says that there is only one relation (or table) when the database is in the 1NF form only. Therefore, how does this work? And if this is the case, what would another table of the repeating groups come to look like, what fields should be included?
2) What does it mean when it says that X & Y of Multi-Value Dependency (MVD) can contain either single or composite attributes?
3) What does entity refer to when talking about normalization? Does it refer to a particular field (column name) of the relation?
4) For Handout Normalization Exercise #2, how is sell date part of the primary key? What if the customer hasn't sold the stock yet, and therefore the value is null? because a primary key can't have a null value in it, and therefore it does not make sense to me.
must check cheap ugg boots for women to your friends ugg boots for women with confident
Posted by: sycle | December 13, 2011 at 01:12 AM