ADDED:
NOTE: The INV_NUM is a partial dependency to DATE_SOLD, INV_SUB, INV_TAX.
This is the dependency diagram for the 1NF. This is a layout for the attributes used in the table. The partial dependencies are listed above in the diagram. A partial functional dependency occurs when the value in a non-key attribute of a table is dependent on the value of some part of the table's primary key (but not all of it). Also, the transitive dependencies are also labeled in the diagram above. A transitive dependency is basically when a non-key attribute depends on another non-key attribute.
1 comments:
You did not eliminate the repeating group. When you look at invoice, its repeating group is the list of products ordered and its information which is grouped by invoice line.
I do not see the INF for request order here.
Great descriptions!
What is invoice tax -- how does that relate?
Post a Comment