Perform the following tasks to create the database required for the application:
Create a database for the application.
Create the required schemas in the database.
Create the required tables under each of the schemas.
Populate the tables with sample data.