= Kernel Records


== Short Description

{{{#!div style="text-align: justify; width: 100%;"
Our goal behind Kernel Records is to create a modern online solution for physical media shopping of musical releases. We plan to achieve this objective by creating a comprehensive web store that makes it easy and fun for everyone to find and buy their favorite vinyl, CDs, and cassettes. The e-commerce platform will be specifically optimized to meet the needs of music collectors and enthusiasts.

At its core, a robust relational database will serve as the foundation for the entire system. This database will store detailed information regarding the products themselves, including metadata for artists, albums, and individual song tracks. Furthermore, it will securely manage user profiles, historical purchase data, and personalized wishlists to ensure a customized experience for every visitor. By implementing advanced filtering and search logic, the database will allow users to navigate our inventory with precision.

Ultimately, we hope to express our love for music by providing easier access to analog copies in our region. This project represents a blend of modern web development and a passion for physical media, bridging the gap between digital convenience and the classic listening experience.
}}}

== Project Info

**Team Members:**
 * Darko Dimzov (232012)
 * Marko Milevski (231241)

Under the supervision of: [http://ajanovski.info/ Prof. Dr. Vangel V. Ajanovski]

**Course:** Databases in 2025/2026/Winter

== Content

{{{#!html
<table style="width: 100%; border-collapse: collapse; border: 1px solid #cccccc; margin: 10px 0;">
  <thead>
    <tr style="background-color: #f7f7f7;">
      <th style="border: 1px solid #cccccc; padding: 8px; text-align: center;">Phase</th>
      <th style="border: 1px solid #cccccc; padding: 8px; text-align: center;">Link</th>
      <th style="border: 1px solid #cccccc; padding: 8px; text-align: center;">Status</th>
      <th style="border: 1px solid #cccccc; padding: 8px; text-align: center;">Date</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td style="border: 1px solid #cccccc; padding: 8px; font-weight: bold; text-align: center;">P0</td>
      <td style="border: 1px solid #cccccc; padding: 8px;"><a href="https://develop.finki.ukim.mk/projects/KernelRecords/wiki/About">Project Definition</a></td>
      <td style="border: 1px solid #cccccc; padding: 8px; color: #228B22;">Completed</td>
      <td style="border: 1px solid #cccccc; padding: 8px;">05.05.2026</td>
    </tr>
    <tr>
      <td style="border: 1px solid #cccccc; padding: 8px; font-weight: bold; text-align: center;">P1</td>
      <td style="border: 1px solid #cccccc; padding: 8px;"><a href="https://develop.finki.ukim.mk/projects/KernelRecords/wiki/ERModel">Conceptual Model (ERD)</a></td>
      <td style="border: 1px solid #cccccc; padding: 8px; color: #228B22;">Completed</td>
      <td style="border: 1px solid #cccccc; padding: 8px;">05.05.2026</td>
    </tr>
    <tr>
      <td style="border: 1px solid #cccccc; padding: 8px; font-weight: bold; text-align: center;">P2</td>
      <td style="border: 1px solid #cccccc; padding: 8px;"><a href="https://develop.finki.ukim.mk/projects/KernelRecords/wiki/RelationalDesign">Logical and Physical Design, DB Creation (DDL)</a></td>
      <td style="border: 1px solid #cccccc; padding: 8px; color: #d4ac0d;">In Progress</td>
      <td style="border: 1px solid #cccccc; padding: 8px;"></td>
    </tr>
    <tr>
      <td style="border: 1px solid #cccccc; padding: 8px; font-weight: bold; text-align: center;">P3</td>
      <td style="border: 1px solid #cccccc; padding: 8px;">Application Scenarios for DB Access (SQL)</td>
      <td style="border: 1px solid #cccccc; padding: 8px; color: #ba0000;">Not Started</td>
      <td style="border: 1px solid #cccccc; padding: 8px;"></td>
    </tr>
    <tr>
      <td style="border: 1px solid #cccccc; padding: 8px; font-weight: bold; text-align: center;">P4</td>
      <td style="border: 1px solid #cccccc; padding: 8px;">First Application Prototype</td>
      <td style="border: 1px solid #cccccc; padding: 8px; color: #ba0000;">Not Started</td>
      <td style="border: 1px solid #cccccc; padding: 8px;"></td>
    </tr>
    <tr>
      <td style="border: 1px solid #cccccc; padding: 8px; font-weight: bold; text-align: center;">P5</td>
      <td style="border: 1px solid #cccccc; padding: 8px;">Normalization</td>
      <td style="border: 1px solid #cccccc; padding: 8px; color: #ba0000;">Not Started</td>
      <td style="border: 1px solid #cccccc; padding: 8px;"></td>
    </tr>
    <tr>
      <td style="border: 1px solid #cccccc; padding: 8px; font-weight: bold; text-align: center;">P6</td>
      <td style="border: 1px solid #cccccc; padding: 8px;">Complex DB Reports (SQL, Stored Procedures, Relational Algebra)</td>
      <td style="border: 1px solid #cccccc; padding: 8px; color: #ba0000;">Not Started</td>
      <td style="border: 1px solid #cccccc; padding: 8px;"></td>
    </tr>
    <tr>
      <td style="border: 1px solid #cccccc; padding: 8px; font-weight: bold; text-align: center;">P7</td>
      <td style="border: 1px solid #cccccc; padding: 8px;">Advanced Database Development (SQL DDL)</td>
      <td style="border: 1px solid #cccccc; padding: 8px; color: #ba0000;">Not Started</td>
      <td style="border: 1px solid #cccccc; padding: 8px;"></td>
    </tr>
    <tr>
      <td style="border: 1px solid #cccccc; padding: 8px; font-weight: bold; text-align: center;">P8</td>
      <td style="border: 1px solid #cccccc; padding: 8px;">Advanced Application Development (Transactions, Pooling)</td>
      <td style="border: 1px solid #cccccc; padding: 8px; color: #ba0000;">Not Started</td>
      <td style="border: 1px solid #cccccc; padding: 8px;"></td>
    </tr>
    <tr>
      <td style="border: 1px solid #cccccc; padding: 8px; font-weight: bold; text-align: center;">P9</td>
      <td style="border: 1px solid #cccccc; padding: 8px;">Other topics (Performance, Security, …)</td>
      <td style="border: 1px solid #cccccc; padding: 8px; color: #ba0000;">Not Started</td>
      <td style="border: 1px solid #cccccc; padding: 8px;"></td>
    </tr>
  </tbody>
</table>
}}}