Kernel Records

Short Description

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: ​Prof. Dr. Vangel V. Ajanovski

Course: Databases in 2025/2026/Winter

Content

Phase	Link	Status	Date
P0	Project Definition	Completed	05.05.2026
P1	Conceptual Model (ERD)	Completed	05.05.2026
P2	Logical and Physical Design, DB Creation (DDL)	In Progress
P3	Application Scenarios for DB Access (SQL)	Not Started
P4	First Application Prototype	Not Started
P5	Normalization	Not Started
P6	Complex DB Reports (SQL, Stored Procedures, Relational Algebra)	Not Started
P7	Advanced Database Development (SQL DDL)	Not Started
P8	Advanced Application Development (Transactions, Pooling)	Not Started
P9	Other topics (Performance, Security, …)	Not Started