Question
The Happy Valley Food Coop (HVFC) keeps a database in which its members balance, their orders and possible suppliers and prices are recorded. The tables
The Happy Valley Food Coop (HVFC) keeps a database in which its members balance, their orders and possible suppliers and prices are recorded. The tables below show some sample data. Table (a) gives data about members; Table (b) shows the ORDERS relationship and (c) gives data about suppliers, their addresses and the prices they charge for the items they are willing to supply.
NAME | ADDRESS | Item | Quantity | BALANCE |
Brooks, B. | 7 Apple Rd. | Granola | 5 | +10.5 |
|
| Unbleached flour | 10 |
|
Field, W. | 43 Cherry Lane | NULL | NULL | 0 |
Robin, R | 12 Banana Cove | Granola | 3 | -123.45 |
|
| Sunflower Seeds | 2 |
|
|
| Lettuce | 8 |
|
Hart, W. | 65 Peach St | Whey | 5 | -43.00 |
Members Table
SName | SAddress | ITEM | Price(per pound) |
Sunshine Produce | 16 River St | Granola | 1.29 |
|
| Lettuce | .89 |
|
| Sunflower Seeds | 1.09 |
Purity Foodstuffs | 180 Sea Wall | Whey | .70 |
|
| Curds | .80 |
|
| Granola | 1.25 |
|
| Unbleached Flour | .65 |
Tasti Supply Co. | 17 River St. | Lettuce | .79 |
|
| Whey | .79 |
|
| Sunflower Seeds | 1.19 |
Supplier Table
Normalize the tables in the above database
Please answer Clearly and Legible
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started