Design a relational database schema for a database application of your choice.

a. Declare your relations using the SQL DDL.
b. Specify a number of queries in SQL that are needed by your database application.
c. Based on your expected use of the database, choose some attributes that should have indexes specified on them.
d. Implement your database, if you have a DBMS that supports SQL.