Description

MAKAUT Notes is a database-driven educational content management system designed to securely store, manage, and deliver academic PDF notes to users. The system focuses on efficient database design and backend management to support structured content browsing, secure purchases, and controlled access to premium study materials.

The primary objective of this project was to implement a robust Database Management System using MySQL, integrated with Laravel (PHP) and Node.js, to ensure reliable data storage, fast retrieval, transactional integrity, and secure handling of user authentication and purchase records.

Key Features

• Structured Database Design: Designed a well-normalized MySQL database to manage users, streams, semesters, subjects, PDF files, purchases, and access validity, ensuring minimal redundancy and high data consistency.

• Relational Data Management: Implemented strong relationships between multiple tables using primary keys and foreign keys, enabling efficient navigation through streams → semesters → subjects → PDFs.

• Secure User Data Handling: Implemented a recommendation system that suggests destinations, accommodations, and activities based on user preferences and past behaviors.

• Payment & Purchase Record Management: Stored and managed payment transactions and purchase validity using structured database tables, ensuring accurate tracking of paid content and time-based access control.

• Controlled PDF Access System: Ensured PDFs are accessible only to authorized users by validating purchase records and expiry dates through backend database queries.

Technologies Used

• Database: MySQL is used for structured and relational data storage, handling user profiles, educational content, purchase history, and access permissions.

• Back-End: 

  • Laravel (PHP): Custom RESTful APIs developed using Laravel to perform CRUD operations, manage secure content delivery, and control time-based PDF access.
  • Node.js: Used for additional backend services and asynchronous operations where required.

• APIs: Integrated third-party APIs for flight, hotel, and car rental bookings to provide a wide range of options to users.

• Payment Data Management: Secure storage of payment and transaction data linked with user accounts to ensure reliable purchase verification.

Design Highlights

• Database Normalization : Applied normalization techniques to reduce data redundancy and improve data integrity across all tables.
• Performance Optimization: Used indexing and optimized queries to ensure fast data retrieval even with increasing users and content.
• Scalability: Designed the database schema to allow easy expansion for new streams, subjects, PDFs, and future features.
• Security: Ensured secure data access using backend validation, preventing unauthorized downloads and protecting sensitive user and transaction data.