Using Visual Basic, develop a Course Record Keeping Application $($CRKA$)$ to keep track of the courses that you have completed at PMU.

Design the User Interface as shown in Figure $1$ below.

Figure $1$: CRKA User Interface

Note how the Final Grade ComboBox lists all possible final grades. As shown in Figure $2$ below, at startup and assuming that $3$ courses have been inserted before, update the number of courses label to reflect the number of courses currently in the Course ID ComboBox as shown in Figure $2$ below. Remember to update it following every insert or delete operation.

Figure $2$: CRKA at Startup

Next, insert the necessary code to enable the user to perform the insert, retrieve, update, delete, and clear operations. Tip: copy the code from the VB Code folder or from the Music Sales application developed in the lab and make the necessary changes. At startup, make sure that the Course ID ComboBox lists the IDs of all courses that have been inserted before $($adjust the Number of Courses label accordingly$).$

Next, log in to Oracle SQL Developer and use the CREATE TABLE command in Chapter $7$ to create your MYCOURSES table. The table should have three columns as shown in Table $1$ below:

Attribute Name Data Type

ID VARCHAR$(10)$

Title VARCHAR$(30)$

FGrade VARCHAR$(6)$

Next, use Tool$$Connect to Database... to connect your Visual Basic application to the database and create the adaptor. While creating the adaptor, select the MYCOURSES table you created in the previous step.

Finally, test your application thoroughly. Start by inserting at least $5$ courses. If the insertion is successful, test the retrieve and the clear operations. For the insert, delete, and update operations, display a success message and clear the screen as we have done in the Music Sales application developed in the lab. Make sure to test the update operation with or without a retrieve operation.

Good Luck