Need someone to help me connect cloud and my java pj...javafx, mysql, googlecloud
$10-30 USD
Closed
Posted over 2 years ago
$10-30 USD
Paid on delivery
1. Access the data from Database( You must connect to the database in the cloud). You can use any database, such as sqlserver(Azure), mysql, oracle, etc) ( 15 points)
3. Create tables such as student, course, enrollment, professor(new), Department(new)
3a. Professor table should have professor id as primary key and deptid as a foreign key.
3b. Course table should have courseid as primary key, professor id, and department id as foreign keys.
4. Establish a relationship between department and professor
5. Establish a relationship between the Course and Professor.
6. Make sure that all of your queries/insert/update statements are inside stored procedures and invoke it from the java. (New) ( 10 points)
Please note that when you are creating a new course, you should give a drop down of a list of departments to chose from. And when a department is selected, the professor dropdown should only show the professors from that department.
Both department dropdown and professor drop down should show department name and professor name, but when selected, the program should store the corresponding ids in the tables.
Also, add code to add/modify a professor and department. The professor should be associated with a department. Please use Jtable to display professor/Department
Also, please store the connection string in a separate text file called [login to view URL]( 10 points)
Please create one stored procedure to access the data and call it from your code. (5 points)
Hi,
Looks like you want development in database and Java. I am confident to be able to solve your project!
Please send me a chat and so I can begin to work on your project!
Thank you.
Kind regards,
Jason