You are designing a small database for recipes. The analysis has revealed that you need the following data
- dish_code
- dish_name
- material_id
- material_name
- amount_needed (how much of a certain ingredient is needed in a portion)
- portion_size (for how many persons the portion is intended)
- preparation_time
- easiness
- phase_number_in_preparation
- phase_name
- phase_description
Define the functional dependencies and give a Boyce-Codd normal form schema for this database.
Give the schema as SQL create table statements.
Mail your answer to Tiina.Pelkonen@helsinki.fi by 3rd of March 2003 17:00