Need someone to help me connect cloud and my java pj...javafx, mysql, googlecloud
Budget: $10 – $30 USD
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 app.config( 10 points)
Please create one stored procedure to access the data and call it from your code. (5 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 app.config( 10 points)
Please create one stored procedure to access the data and call it from your code. (5 points)