(Solved): USING JAVA:- Create a new java project in IntelliJ called Assignment10. Place the MCCSchedule.db fil ...

USING JAVA:

- Create a new java project in IntelliJ called Assignment10.

• Place the MCCSchedule.db file inside your project folder
• Place the JDBC driver file inside your project folder

- Create the following java files in your project to use for this assignment:

• ScheduleSystem.java - the "visual" class that has the main method and will have the menus to search, add, etc.
• ScheduleDB.java - the database class that will hold on the methods to connect, search, add, etc.
• Other files to help you - these are optional, a little freedom here if you need other classes.

----------Part 1: Setting Up the Database and Connection----------

Set up a connection to the database file using the SQLite JDBC driver provided.

You should then code a method that gets your connection to the database to use in the other methods you create. Test it out and make sure you get a connection.

You should create a database object in the ScheduleSystem.java file to be able to call methods on.

You should setup a base menu like the following for people to choose from. Then use a switch to call methods that perform said operations. (Method coding for each in each part below)

----------Part 2: Search through available classes----------

We have a lot of different things that we can search for in this database. We can see if classes are at a specific campus, date/time, specific department/class, and instructor. We need to provide all of those options to the user to search through the database.

You should provide a menu something like this that the user can choose from, then get input and query the database based on input. Remember to use prepared statements.

----------Part 3: Add and Delete---------

-Add a class

• We need to be able to add to the schedule. To do this prompt for the required data (Course ID, Section, Campus, Dates and Times, etc.) then attempt to add it into the table. The problem here is that it is a little tougher to check for duplicates. The primary key for the schedule table is just an integer that counts up. What we need to do is check to see if the class is already in the schedule. To do that we need to check against the Course ID and the section. Those two things are unique to the class. So do some querying and see if it is in the list before adding. Otherwise we will have duplicates and no one would ever know. Again make sure to use prepared statements.

-Delete a class

• Deleting a class should be pretty easy. To delete we should have the user enter in the Course ID and the section. Those are some unique identifiers that we can use and if found delete. If you remember in SQL you have the 'and' keyword that can check multiple values to be true. You will want to do that because some sections repeat themselves across different departments. This should use prepared statements here as well.

----------MCCSchedule.db info----------