Question: Submit the dataEntry . java file along with the tables created inside MySQL (as a .csv file) in a single .zip file. Install JDBC and

Submit the dataEntry.java file along with the tables created inside MySQL (as a .csv file) in a single .zip file.

Install JDBC and Eclipse.

(INSERT data into the database) Use the attached schema to implement the corresponding tables.

Foreign keys are omitted, but you are expected to identify and implement them correctly.

Populate the database using the uploaded data files.

Write a java program to solve this - name of the file should be: dataEntry.java. The methods in the java file will accept data file names as input (file names can be hardcoded) and will be able to read and parse data before inserting them into the corresponding tables. **Note: when executing the same statement repeatedly, you should use the JDBC PreparedStatement construct (Links to an external site.)Links to an external site. for greater efficiency as compared to the more generic Statement class.

Here are the data files for the assignment. You can download it from my google drive:

https://drive.google.com/drive/folders/0BycHCqxSw_g9dVVra3VpR1VTcHc?usp=sharing

Plavers plaver id tagreal name nationality birthday game race Teams team id name founded disbanded Members player team start date end date Tournaments tournament id name region major Matches match id date tournament playerA playerB scoreA scoreB offline Earnings tournamentplayer prize money position

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!