Task $4,$ page name: task$4.$php$,$ chapters: all prescribed chapters, marks: $70$

In this task, you will design and implement a booking system for the management of national Olympiads for schools. In brief, Olympiads are subject$-$ and grade$-$specific assessments that are set by specialists and schools enrol their learners and provide them with an opportunity to compete nationally.

You will design and implement a web$-$based database application that has the following functionalities:

Registration of a school: A school must be able to register to participate in Olympiads. The user must be able to provide basic information about a school and allowed to create a user account $($username and password$)$ for the school.

$7$

ICT$3612/103/0/2024$

Registration of learners: Once the school is registered and logged in$,$ the school should be able to enrol learners for the Olympiad. Each learner must be enrolled independently for various reasons, for example, to create personalised question papers and answer sheets. The user must be able to enter each learner's name, grade and choices of subject exams.

Management of learners registered for Olympiad at a school: Once the school is registered and logged in$,$ they should be able to do the following:

$(1)$ View the list of learners registered for the Olympiad.

$(2)$ Modify and delete individual learners registered for the Olympiad.

$(3)$ Generate invoices for individual learners, if requested.

$(4)$ Generate an invoice for the entire school, if requested.

The fees for a learner can be calculated using a fixed registration fee $($for example, R$30)$ plus a fixed fee $($for example, R$20)$ per enrolled subject. The fee for the school is the sum of the fees for all the registered learners of the school.

Administrative functionality: The application must allow administrative functionality after logging in as an administrator where the overall registration status can be viewed. For example, the admin user must be able to see upon request:

$(1)$ the number of schools registered for Olympiads,

$(2)$ the total number of learners registered across all registered schools.

$(3)$ the total number of learners registered across a grade in all subjects.

$(4)$ the total number of learners registered for a subject in a registered grade.

You need to structure the application code using the model view controller principle.

You are expected to give attention to the overall view, ease of navigation and usability of your application.

When this application is made available for marking, each database table should be populated with at least $3$ rows of data.

You need to include your DB design as an image file and a file named users.txt that contains the usernames and passwords of existing user accounts in your submission folder so that we can login and test your application.