Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is for mySql, I'm not sure what is meant by frame work... The database CWHDemo on the server at IP address 68.178.216.151 has a

This is for mySql, I'm not sure what is meant by frame work...

The database CWHDemo on the server at IP address 68.178.216.151 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.)

I NEED A STEP-BY-STEP procedure that shows me how to implement the code, because I can't get it to work. I also need it to have the appropriate javadoc notations.

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.

MY QUESTION:

What sections of CSCI are offered online for the 15-week term?

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)

course 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.)

Please submit code with appropraite JAVADOC annotations AND explicit directions on how to create it in Netbeans... any directions including folders or files that need to be made and so on...

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Flash XML Applications Use AS2 And AS3 To Create Photo Galleries Menus And Databases

Authors: Joachim Schnier

1st Edition

0240809173, 978-0240809175

More Books

Students also viewed these Databases questions

Question

Describe the economic model that is proposed for the operation.

Answered: 1 week ago

Question

Ty e2y Evaluate the integral dy

Answered: 1 week ago

Question

Why is the System Build Process an iterative process?

Answered: 1 week ago