= IKnow Student Information System (Modern Reimplementation)

Short description:

This project represents a modern reimplementation of the IKnow student information system used by universities to manage academic workflows for students, professors, and administrators.

The goal is to preserve core academic functionality while redesigning the system using a modern web stack and cloud deployment approach. The system is implemented as a Next.js single-page application, a .NET 9 REST API backend, and a PostgreSQL database using Entity Framework Core.

Authentication is handled using short-lived JWT access tokens with persistent refresh tokens. The system also supports automated PDF document generation using PuppeteerSharp and is deployed in the cloud using Vercel, Render, and Neon.

Team members:

Boris Gjorgjievski 233188

Stefan Saveski 233149 

Course: Databases in 2025/2026/Winter Under the supervision of: Prof. Dr. Vangel V. Ajanovski 

Content:
{{{#!html
<table border="1" cellpadding="6" cellspacing="0" style="border-collapse: collapse; width: 100%;">
  <tr style="color: darkred; font-weight: bold; text-align: center;">
    <th>Phase</th>
    <th>Link to Wiki page</th>
    <th>Status</th>
  </tr>

  <tr>
    <td style="color: darkred; font-weight:bold;">Ph0</td>
    <td><a href="/projects/iknow2026/wiki/Ph0">Project Definition</a></td>
    <td style="color:darkred; font-weight:bold;">Not started</td>
  </tr>

  <tr>
    <td style="color: darkred; font-weight:bold;">Ph1</td>
    <td><a href="/projects/iknow2026/wiki/Ph1">System Architecture & Planning</a></td>
    <td style="color:darkred; font-weight:bold;">Not started</td>
  </tr>

  <tr>
    <td style="color: darkred; font-weight:bold;">Ph2</td>
    <td><a href="/projects/iknow2026/wiki/Ph2">Database Design</a></td>
    <td style="color:darkred; font-weight:bold;">Not started</td>
  </tr>

  <tr>
    <td style="color: darkred; font-weight:bold;">Ph3</td>
    <td><a href="/projects/iknow2026/wiki/Ph3">Backend Implementation</a></td>
    <td style="color:darkred; font-weight:bold;">Not started</td>
  </tr>

  <tr>
    <td style="color: darkred; font-weight:bold;">Ph4</td>
    <td><a href="/projects/iknow2026/wiki/Ph4">Authentication & Security</a></td>
    <td style="color:darkred; font-weight:bold;">Not started</td>
  </tr>

  <tr>
    <td style="color: darkred; font-weight:bold;">Ph5</td>
    <td><a href="/projects/iknow2026/wiki/Ph5">Frontend Implementation</a></td>
    <td style="color:darkred; font-weight:bold;">Not started</td>
  </tr>

  <tr>
    <td style="color: darkred; font-weight:bold;">Ph6</td>
    <td><a href="/projects/iknow2026/wiki/Ph6">CI/CD & Deployment</a></td>
    <td style="color:darkred; font-weight:bold;">Not started</td>
  </tr>

  <tr>
    <td style="color: darkred; font-weight:bold;">Ph7</td>
    <td><a href="/projects/iknow2026/wiki/Ph7">Testing & Validation</a></td>
    <td style="color:darkred; font-weight:bold;">Not started</td>
  </tr>

  <tr>
    <td style="color: darkred; font-weight:bold;">Ph8</td>
    <td><a href="/projects/iknow2026/wiki/Ph8">Performance & Security Review</a></td>
    <td style="color:darkred; font-weight:bold;">Not started</td>
  </tr>

  <tr>
    <td style="color: darkred; font-weight:bold;">Ph9</td>
    <td><a href="/projects/iknow2026/wiki/Ph9">Final Documentation</a></td>
    <td style="color:darkred; font-weight:bold;">Not started</td>
  </tr>

</table>