|
RecipeID |
IngrOrd |
IngrID |
IngrAmt |
MixB4Cook |
Rest |
IngrTime |
|
102345 |
01 |
22 |
2 |
Y |
N |
1 |
|
102345 |
02 |
12 |
3 |
Y |
Y |
1 |
|
102345 |
03 |
16 |
2 |
Y |
N |
1 |
This concept is not specifically related to 1NF but it is needed to cover some of the examples. In this table I need both RecipieID AND IngrOrd to make the Unique Key field. This is a practice that is used in Database Design