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 positionStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
