Querying Object Information from SQL Server Database, Like stored proc, viewa, functions, triggeres and more.......

Question

I have a task to basically write an C sharp application to basically tell the user about the an specific SQL SERVER Database.  
Lets Say the Database Name is CSharpCorner.mdb.  My goal is to add this function or capability to an existing winform application for all new Software Engineers that the company hires that may work or used the database, to simply give a quick helpful tutorial of whats going on behind the scenes. Below is the first set of requirments. C sharp corner lets accomplished  Section A below first, and then as we are working or completing the task below, we can add to or give suggestions to this task. Lets start on section A First then we will work on the next section.


Requirements:

Section A:

1. Query a list of all stored procedures
2. Query a list of List all Views
3. Query a list of List all triggers
4. Query a list of List all functions



Section B:

1. For all or each Stored Procedures being used Query CSharpCorner.mdb for list of all tables that are being affected
2. For all or each Views being used Query CSharpCorner.mdb for list of all tables that are being affected
3. For all or each Triggers being used Query CSharpCorner.mdb for list of all tables that are being affected
4. For all or each Function being used Query CSharpCorner.mdb for list of all tables that are being affected


Section C:

1. For I want to create Diagram and then