$.[25$ Points$]$ We have information about students, courses, and enrollments stored in

the following three tables; the underlined attribute$($s$)$ in each table denotes its key.

Students $=\{$SID$,$ SName, Program, Address$\}$

Courses $=\{$CID$,$ CName, NoOfCredits$\}$

Enrollments $=\{$SID$,$ CID, Semester, Year, Grade$\}$

$($a$).$ Use a file processing approach and write a C or Java program that implements the

query Q: $$List the name and ID of every student who took the course Databases

in Winter $2024,$ and obtained at least B$+.$ Test your program using instances of

the above tables that contain information for at least $5$ students, $5$ courses, and

$10$ enrollment records. Provide your program, test data, and the output.

$($b$).$ Use a DB approach to answer the query Q$.$ For this, you may use any relational

DBMS$.$ Provide your SQL query expression and the results produced.

$($c$).$ Compare the approaches A and B above in terms of the efforts involved in coding$/$

developing, processing, and maintenance.

Before evaluating Q$,$ create the input data, that is$,$ create the data as $3$ text files

for part $($a$)$ and create data as relations$/$tables in $($b$).$ The efforts involved in

creating and maintaining the data will show further advantages of DB approach

over file processing systems $$ an issue not considered in this question.. $[25$ Points$]$ We have information about students, courses, and enrollments stored in

the following three tables; the underlined attribute$($s$)$ in each table denotes its key.

Students $=\{$SID$,$ SName, Program, Address$\}$

Courses $=\{$CID$,$ CName, NoOfCredits$\}$

Enrollments $=\{$SID$,$ CID, Semester, Year, Grade$\}$

$($a$).$ Use a file processing approach and write a C or Java program that implements the

query Q: $$List the name and ID of every student who took the course Databases

in Winter $2024,$ and obtained at least B$+.$ Test your program using instances of

the above tables that contain information for at least $5$ students, $5$ courses, and

$10$ enrollment records. Provide your program, test data, and the output.

$($b$).$ Use a DB approach to answer the query Q$.$ For this, you may use any relational

DBMS$.$ Provide your SQL query expression and the results produced.

$($c$).$ Compare the approaches A and B above in terms of the efforts involved in coding$/$

developing, processing, and maintenance.

Before evaluating Q$,$ create the input data, that is$,$ create the data as $3$ text files

for part $($a$)$ and create data as relations$/$tables in $($b$).$ The efforts involved in

creating and maintaining the data will show further advantages of DB approach

over file processing systems $$ an issue not considered in this question.