Help please!!

The database CWHDemo on the server at IP address 68.178.216.151has a table named fall 2014 with information about computer courses offered at College in the Fall 2014

semester.

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 youwill write. The results can be displayed neatly on the console.

Your query might answer a question such asWhat 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.

Here is annotated metadata for the table:

Column

Type

Notes

crn

char(20)

CRN primary key

subject

varchar(5)

CIS, CSCI, or OA

course

varchar(5)

cou

rse number

section

varchar(5)

section number

credits

integer

number of credits

time

varchar(20)

the time the course meets.

days

varchar(8)

the days the course meets: M T W R F S (No Sunday courses.)

term

varchar(5)

15A means the course meets for the

entire 15

-

week term.

7A courses meet for the first half of the term.

7B or 7N courses meet for the second half of the term.

campus

varchar(5)

MAIN, NERC,NWRC, WEST

room

varchar(8)

the room number

enrollment

integer

The data in this column is not real.

It was randomly generated.

All other columns contain real data.

(The data in the table is real data, except for the enrollment, which was randomly generated before

students began registering for the courses.)