The database CWHDemo on the server at IP address 68.178.217.12 has a table named fall2014 with information about computer courses offered at Community College of Philadelphia in the Fall 2014 semester.

* host IP address: 68.178.217.12 * database: CWHDemo * username: CWHDemo * password: Cwhdemo%123 (Note: The password is case sensitive.)

Your task is to develop a Java application with two methods:

1. a method that queries the database, retrieving and writing in a CSV file: the crn, subject, course, section, days and time for all CSCI courses, in order according to the course number. You should be able to open the CSV file in Microsoft Excel.

2. a method that queries the database with a query of your own design based on a question you will write. The results can be displayed neatly on the console.

Your query might answer a question such as What 4 credit courses are available on Tuesday and Thursday? or What sections of OA courses are being offered online? You should make up your own question, write the query to find the answer, and then create a method to get the answer from within a java application.

You can write a single application with methods for each of the two queries.