Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Engage everyone in the dialogue

Answered: 1 week ago

Question

What are Electrophoresis?

Answered: 1 week ago