Introduction

This week you will be designing the data base for the Food Order App and will create and insert records in the Food Order App data base tables. All the create and insert operations should be performed using MySQL$.$ You can use MySQL Work bench to write the necessary commands. You can refer to the FoodOrderApp$\_$ERDiagram. pdf and FoodOrderApp$\_$Database Design Document. pdf documents provided to understand the basic design of the data base. We will only focus on the creation of tables and insertion of records in the tables.The sql files are provided to you.

Problem Statement

Your task is as follows $-$

$1.$ Create tables $($FoodOrderApp$\_$DDLCommands.sqlfile$)$

$$ As shown in$-$ the Food Order App$\_$ERDiagram. pdf there are in all $13$ tables in the Food Order App. Create commands for the first $3$ tables are provided for your reference.

$$ You need to create another $10$tables. You can refer to the FoodOrderApp$\_$Database Design Document. pdf file to understand the schema of each of these tables.

$2.$ Insert records $($FoodOrderApp$\_$InsertCommands.sqlfile$)$

$$ As shown in the FoodOrderApp$\_$ERDiagram. pdf there are in all $13$ tables in the Food OrderApp. Insert commands for the first $3$ tables are provided for your reference.

$$ You need to insert records in another $10$ tables. Records to be inserted are provided in the SQL file.

Program Organization

$$ You will be getting a zip folder containing a folder named SQL$1$ Assessment which has all the required files.

$$ The FoodOrderApp$\_$ERDiagram. pdf and FoodOrderApp$\_$DatabaseDesignDocument. pdf are for your reference which demonstrates the basic design of all the tables of the food$\_$order$\_$appdatabase.

$$ The FoodOrderApp$\_$DDLCommands. sql file contains the commands to create the food$\_$order$\_$appdatabase and to create $3$ tables in the database. You need to modify this file to complete Task$1.$Proprietary content.

$$The FoodOrderApp$\_$InsertCommands. sql file contains the commands to insert records in the first $3$ tables in the database. You need to modify this file to complete Task$2$