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 |
|
1.55 |
750 |
RST Co. |
3415 8th St |
555 3421 |
|||||
|
1.45 |
742 |
XYZ Co. |
510 Smit |
555 8921 |
|||||
|
982 |
NAIL |
100 |
50 |
800 |
1.00 |
987 |
ABC Co. |
654 Elm St |
555 5498 |
|
1.10 |
742 |
XYZ Co. |
510 Smit |
555 8921 |
|||||
|
1.00 |
549 |
LMN Co. |
18 Oak St |
555 9987 |
|||||
Prepare the 3NF base tables needed to produce the sales report view shown in the diagram for Problem