BASED FROM TABLE AND RELATIONAL SCHEME:

EMPLOYEE (EMP_ID, EMP_NAME, EMP_ADDRESS, EMP_SALARY, EMP_GENDER)

FOOD (FOOD_ID, FOOD_NAME, FOOD_PRICE, FOOD_QUANTITY)

SKILL (SKILL_ID, SKILL_NAME, SKILL_DESCRIPTION)

STOCK (STOCK_ID, STOCK_NAME, CONTACT_NUMBER)

INGREDIENT (ING_ID, ING_ITEM)

CUSTOMER (CUST_ID, CUST_NAME, CUST_PHONE, *EMP_ID)

STORE (STORE_ID, STORE_TYPE, *ING_ID)

INVOICE (INV_ID, INV_DATE, *CUST_ID, *FOOD_ID)

EMPLOYEEPRODUCE (*EMP_ID, *FOOD_ID)

EMPLOYEELEARN (*EMP_ID, *SKILL_ID)

STOREKEEP (*STOCK_ID, *STORE_ID)

EMPLOYEECOUNT (*EMP_ID, *STOCK_ID)

PLEASE DO 10.1 AND 10.2 AND FOLLOW THE INSTRUCTION, ASAP

Database Implementation The report must include Structured Query Language (SQL) commands using MySQL workbench for the following sections: 10.1. Section A: Data Definition Language (DDL) This section describes the SQL command languages and the *output for: - CREATE TABLE statement for all table structures. 10.2. Section B: Data Manipulation Language (DML) i. The SELECT statements for ALL TABLES which displayed minimum of 10 records for appropriate tables. ii. Describes the queries which consist of the: 1) questions, 2) MySQL SQL command languages and 3) output. - Queries for each lab topic: Retrieving Data from Multiple Tables (Joining Database Tables) which at least 5 queries. *Simple SQL Queries (SELECT, WHERE, ORDER BY, DISTINCT) which at least 5 queries.: - Comparison Operators (=,,==,,> ) - Logical Operators (AND, OR NOT) - Special Operators (BETWEEN, LIKE, IS NULL, IN, DISTINCT) Column Functions and Grouping (SUM, AVG, MIN, MAX, COUNT (*), COUNT (DISTINCT), GROUP BY, HAVING, ORDER BY) - at least 3 queries Using Subqueries (WHERE, HAVING, IN) - at least 3 queries