With 163 coded files and 20 database tables, AIF School Web Portal, was my first serious project! :). The client needed a program to help managing their academic procedures. In short, these are what we did:
Inclusion of 3 major panels, namely the students' access panel, the professors' access panel, and the office staff (registrar, dean, assistant registrar, etc.) panel.
In order to ensure the optimum performance of the database system, we injected thousands of dummy data/rows into the tables and performed some query tasks. Things went on flawlessly which was also thanks to our robust Linux server.
In order to securely handle the authentication of all 3 types of users (i.e. students, profs., office staff), we used PDO framework of PHP under Object Oriented Programming.
We designed three custom CSS (Cascade Style Sheet) files to make the three above-named panels visually distinctive. Surely, we also considered responsive design to allow all users to be able to connect to the website using their own mobile and tablet devices.
Perhaps the coolest part of this project, can be the fact that we were able to finish the whole thing way ahead of the scheduled deadline, thanks to intensive concept design and early database planning, and of course, thanks to the client for providing the necessary information. P.S. this credit also goes to coffee & tea! :)