Project instructions

Please follow strictly the following instructions:

Include the IDs and names of all group members clearly on the first page of your submission file.

Copying is strictly prohibited. If any part of your submission is found to be copied, a $0$ mark will be given to all copied submissions, regardless of the group involved.

Include both the code and screenshots of the code.

The assignment should be completed and saved as a PDF with your group name $($e$.$g$.,$ Group $1),$ and submitted through Blackboard $($BB$).$

Submit a clear and well$-$organized PDF or Word document that includes all specified requirements.

The project must be submitted to Blackboard $($BB$)$ on or before $30-11-2024$ at $11$:$59$ PM$.$ Late submissions will not be tolerated.

Only one group member should submit the assignment.

Failure to follow any of these instructions will result in a deduction of $1$ mark for each violated instruction."

Project Overview

The University Management System is a comprehensive database project designed to efficiently manage academic operations and student data. The database comprises $3$ core entities: Student, Course, and Enrollment, each with clearly defined attributes and relationships to support essential academic functionalities.

Student

StudentID FirstName LastName IdentificationNumber PhoneNumber

$\backslash$table$[[1,$Alice,Johnson,S$12345678,1234567890],[2,$Bob,Smith,S$98765432,2345678901]]$

Course

CourseID CourseName Credits Department Status

$101$ Database Systems $3$ Computer Science Active

$102$ Data Structures $4$ Computer Science Active

$103$ Calculus $3$ Mathematics Active

Enrollment

$\backslash$table$[[$Enrollme ntID,EnrollmentDate Grade StudentID CourseID $r^P,$ectionNumbe,,Seme,Year$],[1001,2023-01-15,$A$,1,10,,,50,$Spring,$2023],[1002,2023-01-15,$B$,2,102,2,,50,$Spring,$2023],[1003,2023-02-10,$A$,1,103,1,,50,$Spring,$2023]]$

Requirements

Create the three tables $($Student$,$ Course, Enrollment$)$ ensuring proper primary and foreign keys.

Write a PL$/$SQL function named get student grade that takes a