Consider the following scenario.

The restaurant employs a number of chefs. A record is kept of each chef's ID, name, address, ID number, phone number and salary. A Chef can have more than one phone number.

Each chef can prepare a number of meals. The name of the meal and the price of the meal are recorded.

Each meal consists of a number of ingredients. The name of the ingredient and the quantity required for that particular meal is recorded.

These meals are ordered by customers. A record is kept of the customer's NIC, name, address and phone number. A record is kept of the time and date the meal is ordered.

Design and create a database to the above scenario.

State any assumptions made (if any).

Map the diagram in to Relational Schema and Proof your answer is normalized up to 3NF.

Create the Database using MySQL