$1.$ Data dictionary

Create a data dictionary for the database $($see an example in Figure $2).$

$2.$ SQL codes for database creation and population

Generate SQL codes to create and populate the database with the data shown in Figure $3.$

$3.$ Queries and SQL statements

Write ten queries and SQL codes for the database and show the results.

The minimum requirement is that join condition, filtering condition, aggregation function, subquery function must be used at least once.

$4.$ Custom entities

Create custom entities for expansion of the database.

At least, two entities with three attributes, respectively, must be connected.

$5.$ Populating new tables and additional queries

Populate the new tables with dummy data $($at least five records for each table$)$ and write three queries and SQL statements and show the results.

Please refer to the image attached and help me in solving these questions. Thank you in advance :)