import sqlite$3$

class Student:

def $\_\_$init$\_\_($self$,$ StudentID,StudentName$)$:

self.StudentID $=$ StudentID

self.StudentName $=$ StudentName

def print$\_$student$\_$details$($self$)$:

print$(\text{'}$Student Id:$\text{'},$ self.StudentID,$\text{'},$ Student Name:$\text{'},$self.StudentName$)$

def print$\_$all$\_$students$\_$details$($cursor$,$connection$)$:

pass

def add$\_$new$\_$student$($self$,$cursor,connection$)$:

cursor.execute$("$INSERT INTO StudentsCoursesRegistraions $($StudentID$,$StudentName$)$ VALUES $(?,?)",($self$.$StudentID, self.StudentName$))$

connection.commit$()$

print$(\text{'}$Student Added Successfully'$)$

def update$\_$student$($self$,$cursor,connection$)$:

cursor.execute$("$UPDATE StudentsCoursesRegistraions SET StudentName $=?$ WHERE StudentID $=",($self$.$StudentName, self.StudentID$))$

connection.commit$()$

print$(\text{'}$Student Updated Successfully'$)$

def delete$\_$student$($StudentID$,$cursor,connection$)$:

cursor.execute$("$DELETE FROM StudentsCoursesRegistraions WHERE StudentID $=?",($StudentID$,))$

connection.commit$()$

print$(\text{'}$Student Deleted Successfully'$)$

def create$\_$tables$()$:

cursor.execute$(\text{'}\text{'}\text{'}$CREATE TABLE IF NOT EXISTS StudentsCoursesRegistraions $($

StudentID INTEGER PRIMARY KEY,

StudentName TEXT,

CourseID INTEGER,

Course$\_$Details TEXT,

TeacherID INTEGER,

Teacher$\_$name TEXT,

Registration$\_$Date TEXT$)\text{'}\text{'}\text{'})$

connection.commit$()$

def main$\_$menu$()$:

print$(\text{'}$what would you like to manage:

press $1$ for Students,

$2$ for teachers,

$3$ for courses,

$4$ for enrollment'$)$

choice $=$ input$(\text{'}$Input your choice: $\text{'})$

if choice $==\text{'}1\text{'}$:

print$(\text{'}$

You have chosen Student Management,

press $1$ to add a new student,

$2$ to update an exsiting student,

$3$ to delete a student,

$4$ to view all students details'$)$

student$\_$management$\_$choice $=$ input$(\text{'}$Input your choice: $\text{'})$

if student$\_$management$\_$choice $==\text{'}1\text{'}$:

StudentID $=$ input$(\text{'}$input student id: $\text{'})$

StudentName $=$ input$(\text{'}$input student name: $\text{'})$

s $=$ Student$($StudentID$,$StudentName$)$

s$.$add$\_$new$\_$student$($cursor$,$connection$)$

s$.$print$\_$student$\_$details$()$

elif student$\_$management$\_$choice $==\text{'}2\text{'}$:

StudentID $=$ input$(\text{'}$Which student detail you want to update: input student id: $\text{'})$

StudentName $=$ input$(\text{'}$input an updated student name: $\text{'})$

s $=$ Student$($StudentID$,$StudentName$)$

s$.$update$\_$student$($cursor$,$connection$)$

s$.$print$\_$student$\_$details$()$

elif student$\_$management$\_$choice $==\text{'}3\text{'}$:

Student.delete$\_$student$(1,$cursor,connection$)$

elif student$\_$management$\_$choice $==\text{'}4\text{'}$:

Student.print$\_$all$\_$students$\_$details$($cursor$,$connection$)$

else:

print$(\text{'}$input is not valid'$)$

connection $=$ sqlite$3.$connect$(\text{'}$school$.$db$\text{'})$

cursor $=$ connection.cursor$()$

create$\_$tables$()$

main$\_$menu$()$

connection.close$()$

Assignment Task

Introduction

This assessment comprises enhancing an existing codebase to create an application that addresses a practical problem. It will assess the student's understanding of software development and implement relational database and the ability to document the development process.

The objective is to enhance this codebase by incorporating supplementary features and functionalities that contribute to the overall functionality and usability of the application

Assignment Description:

This assessment task focuses on the process of improving and refining an existing codebase that has been provided. The codebase serves as the ground work for a school management application. The application will be developed using an OOP $($Object Oriented Programming$)$ Language $($Python$)$ that supports CRUD $($Create$,$ Read, Update, and Delete$)$ operations.

A$.$ Artefact $[50$ Marks$]$

Student will be provided with codebase for a School Management Application. The student task is to perform the following steps by utilising the provided code to:

$$ Create an application in an OOP $($Object Oriented Programming$)$ Language $($Python$)$ that supports CRUD $($Create$,$ Read, Update, and Delete$)$ operations for each of the database tables using Stored Procedures.

$$ Adding more features and functionalities to align with a problem for a given scenario.

$$ Build a simple database using a DBMS $($DataBase Management System$)$ application such as MSSQL$,$ MySQL$,$ and Oracle. The application must successfully include a connected database that host tables.

$$ Understand the design of your application with the help of ERD $($Entity Relational Diagrams$),$ Conceptual, Logical and physical diagrams for the completed database.

$$ The database need to be normalised to $3$NF $($Normal Form$),$ at minimum.

$$ Your application should use sorting and searching algorithms to filter and sort loaded data.

Please note that the given codebase is not complete and require improvements and implementation of extra features and functionalities:

Required improvement to the codebase: