need help connecting to Google Cloud database and myjava project.
$10-30 USD
Pagato alla consegna
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)
Rif. progetto: #32181650
Info sul progetto
6 freelance hanno fatto un'offerta media di $33 per questo lavoro
Hi, Thanks for sharing this opportunity here at Freelancer. I’ve read your job description and noticed you are looking Java Developer. I would love to be working with you as Java Developer and help you execute your str Altro
Hi, I am done with google certification on associate engineer and existing with almost 10 years of experience in Middleware administrator. I use to maintain all the environments in day to day activities. If my deal Altro