Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.14

Question

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

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