I have Database project I made the tables and some of the required.I need to complete the following:I. An…

I have Database project I made the tables and some of the required. I need to complete the following: I. An E-R Diagram (hand drawn or using MS-Visio) II. An MS Access 2010 database including the following “special features” 1. Create a database with multiple normalized tables with the necessary design to support your application and sufficient data to demonstrate the following (data may be real or fictional). 2. Examples of the use of validation rules and input masks for data fields 3. At least two forms, one of which must be a multi-table form (form with a subform). 4. At least two reports, one of which must be a multi-table report 5. At least five queries including examples of each of the following a. Select queries b. Sorting queries c. Calculation field queries (Field created by another field or fields) d. Function queries using By Group (counts,totals, averages) 6. At least two examples of advanced reporting techniques (design mode) 7. At least two examples of advanced form techniques (report mode) 8. A switchboard or button/macro interface for form, reporting navigation.