The a$*$Fashion now requires a partial implementation of the design made in Assignment Part

$1.$ To keep consistency between the assignments, database specification containing the ER

diagram and the corresponding schema are provided with this document. You should create

your database according to this documentation. Make sure that your implementation is

consistent with this design, i$.$e$.,$ your table names, field names, and data types are according

to the specifications provided in this document. The implementation phase includes writing

SQL statements to create a database and its tables, populating the tables with appropriate test

data, and writing several queries to create reports that can be used by the management team.

You need to insert at least five records in each of the tables and ensure that each of the query

returns at least one record.

Implementation of the Database and Manipulation of the Data

You are required to perform the followings tasks:

$1.$ Task $1$: Create a text file named Create$\_.$sql or Create$\_.$txt

$($for example, Create$\_11.$sql or Create$\_11.$txt$)$ that will contain SQL statements to:

I. Create a database named aSFashion

$\_$

$.$

II$.$ Create all the tables for the database according to the Database schema

given with this document $($separately attached$).$

$2.$ Task $2$: Create a text file named Insert$\_.$sql or Insert$\_.$txt

that will contain SQL statements to:

I. Insert at least five records in each of the tables. The test data inserted into

the table must ensure that each of the queries, specified in Task $3,$ outputs at

least one record.

$3.$ Task $3$: Create a text file named Query$\_.$sql or Query$\_.$txt

that will contain all the queries to display the following:

I. List of names of all staff sorted by their hourly salary.

II$.$ The date on which the $2$nd oldest customer order has been made. The

customer$$s name who made the order and the date of the order will be

sufficient.

III. List of all the store names and their manager names, appointment levels and

hourly rates, sorted in the highest to the lowest of managers$$ hourly rate.

IV$.$ A list of all products that have been sold. Displaying product number,

description, type, size, and total quantity sold of each product will be

sufficient. Note that products that have been ordered but not picked up are

considered not sold yet.

V$.$ A list showing each product sold $($picked$)$ on or before May $20,2024.$ Show

product number, description, type, and total quantity sold, sorted by product

number and then total quantity sold.