4. Write a sentence-fragment answer for each question (except e) about this table:

The table:

IngredientOrder

ingredient	vendor	quantity vendorPhone	vendorPhone
01	Sysco	2	555-1212
01	FoodServ	4	777-8888
02	Sysco	3	555-1212
02	FoodServ	6	777-8888
03	Schwann	3	111-0000
04	Sysco	2	555-1212
04	FoodServ	4	777-8888

The schema:

IngredientOrder ( ingredient, vendor, quantity, vendorPhone )

(a) Theres a repeated pairing of values that causes a fact to be restated more than once. (This is a data redundancy). What fact is being repeated? (b) What's the key of the table?

(c) What's the determinant of vendorPhone?

(d) What normal form is in question for this table?

(e) Write the two schamas for the normalized tables. (Dont show the whole tables, just jot down the schemas; there will be two of them).