The following "Courses ERD" represents courses and sections as offered at UNB. This ERD

applies to Questions $2$ to $7.$

UNB offers courses in a wide variety of subject areas, including the subject area codes CS$,$

MATH, and ENGL, just to name a few. Those three codes represent the subject areas named

Computer Science, Mathematics, and English, respectively.

Each course in UNB's Undergraduate Calendar is in exactly one subject area and has a course

title $($e$.$g$.$ 'Introduction to Databases'$).$

A section is an offering of a course that takes place during a specific academic term, such as

Winter $2022($represented in this database by the code $\text{'}$W$2022\text{'}).$

$7.$ The following partial text$-$based JDBC program is used to remove a section from the database.

Fill in the blanks to complete this program.

import java.sql$.$Connection;

import java.sql$.$DriverManager;

import java.sql$.$SQLException;

import java.sql$.$PreparedStatement;

import java.util.Scanner;

public class RemoveSection

$\{$

public static void main$($String$[]$ args$)\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$\{$ Scanner scan $=$ new Scanner$($System$.$in$)$;

System.out.print$("$

Enter the id of the section to be removed: $")$;

int sectionId $=$ scan.nextInt$()$;

Connection connector $=$ DriverManager.getConnection

$("$jdbc:mysql:$//$cs$1103.$cs$.$unb.ca:$3306/$dbname$",$

"userid", "PASSWORD"$)$;

String deleteText $=\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

PreparedStatement deleteStatement $=$

connector.prepareStatement$($deleteText$)$;

deleteStatement.$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$;

int affectedRows $=\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$;

if $(\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_)$

System.out.println$("$

Removal failed

$")$;

else

System.out.println$("$

Removal succeeded

$")$;

connector.close$()$;

$\}//$ end main$()$

$\}//$ end RemoveSection class