Using the registrar database that you created in the previous task, write a Java Swing application that exercises these queries. 1.Develop a query to select all course rosters by instructor sorted by instructor and course name for fall semester 2009 (F09) 2.Develop a query to select all student schedules sorted by student for fall semester 2009 (F09). Hint: The queries can just be typed in utilizing a jTextfield. The result of queries should be shown in a Swing Table. Submit your zipped NetBeans projects with screenshots showing that your application runs. and here is the registrar; DROP DATABASE IF EXISTS `address`; CREATE DATABASE address; USE address; DROP TABLE IF EXISTS `course`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `course` ( `courseID` varchar(8) NOT NULL, `courseName` varchar(20) NOT NULL, `section` varchar(1) NOT NULL, `Instructor` varchar(20) NOT NULL, PRIMARY KEY(courseID) ); -- -- Dumping data for table `course` -- INSERT INTO `course` VALUES ('CS123','Intro to','A','Mickey Mouse'),('IT170','Intro to OO','B','Daisy Duck'),('IT171','Intro to OO','B','Daisy Duck'),('CS124','Intro to UNIX','A','Mickey Mouse'),('IT235','Database Systems','A','Minnie Mouse'),('MATH260','Discrete Math','C','Goofy'),('IT371','Java','A','Sorrentino'); -- -- Table structure for table `enrollment` -- DROP TABLE IF EXISTS `enrollment`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `enrollment` ( `studentID` int(10) NOT NULL, `courseID` varchar(8) NOT NULL, `semester` varchar(3) NOT NULL, PRIMARY KEY(studentID,courseID) ); -- -- Dumping data for table `enrollment` -- LOCK TABLES `enrollment` WRITE; INSERT INTO `enrollment` VALUES (1425,'IT170','S08'),(1425,'CS123','F09'),(4156,'MATH260','S08'),(4156,'IT171','F09'),(7458,'MATH260','S08'),(7458,'IT235','F09'),(5682,'CS123','F09'),(5682,'MATH260','S08'),(8541,'IT170','S08'),(8541,'CS124','S08'),(6523,'CS123','F09'),(6523,'IT235','F09'),(6523,'IT170','S08'),(5748,'IT170','S08'),(5748,'CS124','S08'),(5748,'IT235','F09'),(1425,'IT171','F09'),(1425,'CS124','F09'),(4156,'CS124','F09'),(4156,'CS123','F09'),(7458,'CS123','F09'),(5682,'IT170','S08'),(5682,'IT171','F09'),(8541,'IT235','F09'),(6523,'IT171','F09'),(5748,'IT171','F09'); UNLOCK TABLES; -- -- Table structure for table `student` -- DROP TABLE IF EXISTS `student`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `student` ( `studentID` int(10) NOT NULL, `firstName` varchar(20) NOT NULL, `lastName` varchar(20) NOT NULL, `degreeProgram` varchar(4) NOT NULL, `gender` char(1) NOT NULL ); -- -- Dumping data for table `student` -- LOCK TABLES `student` WRITE; INSERT INTO `student` VALUES (1425,'Mary-Ann','Summer','BSIT','F'),(4156,'Thurston','Howell III','BSSE','M'),(7458,'Skipper','Grumby','ASIT','M'),(5682,'Ginger','Grant','ASSE','F'),(8541,'Giligan','Unknown','ASIT','M'),(6523,'Professor','Hinckley','DCS','M'),(5748,'Eunice','Howell','ASSE','F'),(1425,'Mary-Ann','Summer','BSIT','F'),(1234,'Rich','Guill','BSIT','M'); UNLOCK TABLES;