paper-based database!

You are not required to develop an actual database, but are free to use one if you have a DBMS available.
You have been hired to develop an EHR database system for a medical group. The group includes 25 primary care clinicians who provide care for approximately 1000 patients, or 40 patients per doctor.
You is free to craft and exercise creative license in terms of the details of the database that you will be creating (i.e. tables, fields, queries, relationships, etc.)
You must provide a written data system plan for the institution, which includes all of the following:
1. Queries/SQL Statements (questions you will ask of the database)
a. Count of Patients per Physician
b. List of all male patients
c. List of all Female Patients
d. Count of Female Patients greater than 65 years of age
e. Count Male Patients between 45 and 65 years of age
f. Count of medication prescribed by each physician