Prepare the base tables, in third normal form, needed to produce the user view in the table for Problem.
|
USER VIEW |
|||||||||
|
Part Num |
Description |
QOH |
Reorder |
EOQ |
Unit |
Ven |
Ven Name |
Ven |
Tel |
|
132 |
Bolt |
100 |
50 |
1000 |
1.50 |
987 |
ABC Co. |
654 Elm St |
555 5498 |
|
143 |
Screw |
59 |
10 |
100 |
1.75 |
987 |
ABC Co. |
654 Elm St |
555 5498 |
|
760 |
Nut |
80 |
20 |
500 |
2.00 |
742 |
XYZ Co. |
510 Smit |
555 8921 |
|
982 |
Nail |
100 |
50 |
800 |
1.00 |
987 |
ABC Co. |
654 Elm St |
555 5498 |