You will be required to prepare all the tables for your database system and you will be given 7 business questions for the system. Your table structure should allow you to create queries in SQL that will provide the data to answer the business questions (they are listed below). In addition, create a Data Dictionary for the tables (a sample can be found in your text).
Queries
1. Select all the customer records
2. Select loans that have been approved
3. List all the delinquent accounts
4. List the customers who have been approved loans in last 3 months
5. List all the underwriters who have reviewed loans in last 30 days
6. List the customers who have more than one outstanding loans
7. List the loan applications that have been denied in last 6 months