I am making a database about disney princesses. I chose cinderella, belle, ariel, jasmine, tiana, rapunel, and snow white. For the tables i choose kingdom, princesses main song of movie, princes, and movie they are featured in$.$ Write one simple query for each of the tables in your database$/$schema$.$ Save these queries in a $.$sql file format. Now upload all of your files. NAME your files so that the reader will understand the contents of each.

Create a single sql script that completes all requirements.

Add a date field to one of your tables. If might be a date of birth, a purchase date, a date a match is completed for example.

Continue with your project by adding queries that perform calculations.

What to submit:

Submit a fresh model of your database model in $.$mwb format

Submit the script that does the following:

Deletes schema if it exists

Creates schema if it does not exist

Includes use command

Creates tables with relationships.

One table must have a date field.

One table must have a set or enum field.

The date field and the set$/$enum fields must be populated in all rows of the table.

Inserts at least $5$ records in each table

Create a query using the date field. Possibilities include that a field equals a certain date, or is between $2$ dates. You could pick the earliest or latest date. The query needs to filter based on the date field.

Create a query that performs any calculation. Examples include adding, subtracting, multiplying or dividing.

Create a query that performs an average or minimum or maximum.

Create a query that joins two or more tables and pull fields from each table.

Create a query that uses GROUP BY and HAVING.

Create a query that concatenates at least $2$ fields with a space in between. Example: first name and last name.