Project 2: Use of Views and Database Programming with Function Calls and Class Libraries JDBC
Introduction to Database Systems CS 41636523
Points: 100
There are two parts of this project, for which you will use the tables that you created for Project 1.
1. You need to modify and run the attached jdbcMySQL.java file to retrieve the results of the query:
Display, without duplicates, users who have a friend of a different gender.
Note that you have to put in your username and password and change the query written in the attached file. You can compile and execute the jdbcMySQL.java file using Eclipse. You need to include the provided mysqlconnectorjava8.0.13.jar file into your Java Build Path. Submit the modified file as well as a file containing the result obtained from the database for the query.
2. Create two views, one updatable and the other not updatable. Present sample queries and results on both views. Update the table with the updatable views and show before and after contents of the table. Submit a file containing the views, the update commands and the contents of the table before and after updates.