Study notion

A PROJECT REPORT

Submitted by

ANURAG YADAV

2101030400443

BACHELOR OF ENGINEERING
In
Computer Engineering

College of Technology
Silver Oak College of Engineering & Technology

Silver Oak University, Ahmedabad

April, 2025
 Silver Oak College of Engineering & Technology
Opp. Bhagwat Vidhyapith, S.G. Highway, Ahmedabad-382481

CERTIFICATE
This is to certify that the Project report submitted along with the Project entitled
Study notion has been carried out by Anurag Yadav under my guidance in partial
fulfillment for the Bachelor of Engineering in Computer Engineering, 8th Semester
of Silver Oak University, Ahmedabad during the academic year 2024-25.

Mr. Paras Narkhede Mr. Mayuresh Kulkarni

Internal Guide Head of the Department
21

Silver Oak College of Engineering & Technology

Opp. Bhagwat Vidhyapith, S.G. Highway, Ahmedabad-382481

DECLARATION
We hereby declare that the Project report submitted along with the Project entitled
Study Notion submitted in partial fulfillment for the Bachelor of Engineering in
Computer Engineering to Silver Oak University, Ahmedabad, is a Bonafide record of
original project work carried out by me under the supervision of Mr. Paras Narkhede
and that no part of this report has been directly copied from any students’ reports or
taken from any other source, without providing due reference.

Name of Student Sign of Student

Yadav Anurag
2101030400443

ACKNOWLEDGEMENT

I would like to extend my heartily thanks with a deep sense of gratitude and respect to all
those who has provided me immense help and guidance during my project. I would like
to express my sincere thanks to my faculty guide Mr. Paras Narkhede for providing a
vision about the system and for giving me an opportunity to undertake such a great
challenging and innovative work. I am grateful for the guidance, encouragement,
understanding and insightful support given in the development process. I would like to
extend my gratitude to Mr. Mayuresh Kulkarni Head of Computer Engineering
Department, Silver Oak College of Engineering and Technology, Ahmedabad, for his
continuous encouragement and motivation.

Yours Sincerely,
Yadav Anurag
2101030400443

Silver Oak University i Silver Oak College of engineering & Technology

2101030400443

Abstract

This project presents the design and development of a comprehensive

freelancing website tailored to provide a seamless, efficient, and user-
friendly platform for both freelancers and clients. The primary objective of
the platform is to bridge the gap between skilled professionals and project
owners by facilitating smooth interactions, effective project management,
and secure transactions. The platform enables freelancers to discover relevant
job opportunities, showcase their expertise, bid on freelance projects, manage
ongoing tasks, and receive payments—all within a unified interface. Clients,
on the other hand, can post detailed job listings, review freelancer profiles,
hire qualified professionals, and monitor project progress through a
centralized dashboard. Developed using Python and Django on the backend
and React.js for the frontend, the system ensures a scalable architecture and
responsive user experience across devices. Core functionalities include
secure user authentication, job bidding mechanisms, real-time chat support,
and integrated project management tools—each designed to streamline the
freelancing workflow and improve productivity. In addition to standard
features, the platform aspires to implement advanced capabilities such as AI-
powered freelancer-client matching, milestone-based payment processing,
and a transparent rating and feedback system. These innovations aim to foster
trust, increase user satisfaction, and create a more dynamic and reliable
freelancing ecosystem.

Silver Oak University ii Silver Oak College of engineering & Technology

2101030400443

List of Figures Pg No.

1.7 Gantt Chart of Project 01

3.2.1 Use-case Diagram 03
3.2.2 E-R diagram 04
3.2.3 Data flow Diagram 08
4.2.1 Landing Page 14
4.2.2 Login Page 15
4.2.3 Registration Page 16
4.2.4 Account Profile 16
4.2.5 Project detail 16
4.2.6 Client Profile 17
4.2.7 Project Posting Page 17
4.2.8 Add a new Project 18
4.2.9 Set Budget 18

Silver Oak University iii Silver Oak College of Engineering & Technology
2101030400443

List of Tables Pg No.

Table 1.5.1 Technologies Used 06

Table 5.5.1 User Data 20
Table 5.5.2 Client Projects detail 25

Silver Oak University iv Silver Oak College of Engineering & Technology

2101030400443

ABBREVIATIONS

HTML HyperText Markup Language

CSS Cascading Style Sheets
JS JavaScript
React.js React JavaScript Library
Node.js Node JavaScript Runtime
Express.js Express JavaScript Framework
MongoDB Mongo Database
MySQL My Structured Query Language
AWS Amazon Web Services
AI Artificial Intelligence
UPI Unified Payments Interface
API Application Programming Interface
UI User Interface

Silver Oak University v Silver Oak College of Engineering & Technology

2101030400443

Table of Contents

Section Page No.

Acknowledgment i
Abstract ii
List of Figures iii
List of Tables iv
List of Abbreviations v
Table of Contents vi
1 Chapter 1: Introduction to Project 1
1.1 Project Summary 2
1.2 Purpose 2
1.3 Objectives 3
1.4 Scope 5
1.5 Technology and Literature 6
1.6 Project Planning 7
1.7 Project Scheduling 8
2 Chapter 2: System Analysis 9
2.1 Problem and Weakness of Current System 9
2.2 Requirements of New System 9
2.3 System Feasibility 9
2.4 Proposed System 10
2.5 Features of New System 10
2.6 List of Main Modules 11
2.7 Selection of Hardware and Software 11
3 Chapter 3: System Design 13
3.1 System Design 13
3.2 Input/Output Design 14
4 Chapter 4: System Implementation 16
4.1 Implementation of Database 16
4.2 Implementation of User-End Website 16
5 Chapter 5: Testing 20
5.1 Testing Strategy 20
6 Chapter 6: Conclusion and Future Extension 21
6.1 Overall Analysis of Project 21
6.2 Problem Encountered and Possible Solution 21

Silver Oak University vi Silver Oak College of Engineering & Technology

2101030400443

Section Page No.

Conclusion ` 22
References 22

Silver Oak University vii Silver Oak College of Engineering & Technology
2101030400443 Introduction to Project

Chapter-1 Introduction to Project

1.1 Project Summary

Study Notion is an innovative freelancing platform designed to revolutionize the gig
economy by providing lower service fees, faster payments, and intelligent job matching for
freelancers and clients alike. Unlike traditional freelancing platforms that suffer from high
commission rates, payment delays, and inefficient project allocation, Study Notion
leverages modern web technologies and AI to create a seamless, trustworthy, and
productive experience for both parties.

The platform is built using a robust MERN stack architecture—React.js for the front-end,
Node.js and Express.js for the backend—with MySQL and MongoDB handling relational
and non-relational data storage. Hosted on AWS, Study Notion ensures scalability, speed,
and security. Key features include real-time chat and video communication, secure payment
integration, skill verification, and AI-powered recommendations that match freelancers to
the most relevant projects.

Future enhancements will include blockchain-based smart contracts, cryptocurrency and

UPI payments, a subscription model, and a marketplace for digital products—opening up
passive income opportunities for freelancers. Study Notion is not just another freelancing
site—it’s a complete ecosystem built for the future of flexible work.

1.2 Purpose
The purpose of Study Notion is to create a more efficient, fair, and transparent freelancing
platform that addresses key issues faced by freelancers and clients. By lowering service
fees, enabling faster and more secure payments, and improving job matching through AI,
the platform aims to enhance user experience. It also seeks to build trust with verified
profiles and offer seamless communication tools. Ultimately, Study Notion supports the
evolving needs of the modern remote workforce.

1.3 Objective
• To apply and demonstrate full-stack development skills through a real-world
project.
• To build a modern freelancing platform that addresses common issues like high fees
and delayed payments.
• To integrate secure and efficient payment systems for both freelancers and clients.
• To implement AI-based job matching and verified user profiles for better reliability.

• To create a scalable, cloud-hosted solution using the MERN stack and AWS service

Silver Oak University 1 Silver Oak College of Engineering & Technology

2101030400443 Introduction to Project

1.4 Scope

The scope of TrackMate includes:

• Build a full-stack freelancing platform connecting freelancers and clients with
secure payment and communication features.
• Implement user registration, profile management, project posting, bidding, and
assignment functionalities.
• Integrate AI-driven job matching based on freelancer skills and project
requirements.
• Provide real-time communication through chat and video calls.
• Future plans include blockchain smart contracts, UPI/crypto payments, and a digital
product marketplace.
• Use the MERN stack (MongoDB, Express.js, React.js, Node.js) and host the
platform on AWS for scalability.

1.5 Technology and Literature Review

1.5.1 Technology

The Table 3.1 list out the complete bundle of technologies used.
Category Technology
Backend Framework Express.js, Node.js
Web Framework React.js, Express.js
FrontEnd HTML, CSS, React.js
Programming language JavaScript
Data Base MySQL Server

1. React.js: React.js is a JavaScript library for building user interfaces. It allows

developers to create reusable UI components and efficiently update the UI in
response to user interactions or data changes. React.js is widely used for building
dynamic and interactive web applications.

2. JavaScript: JavaScript is a programming language commonly used for client-side

scripting in web development. It enables interactive features and dynamic content
on web pages, such as form validation, animations, and event handling.

Silver Oak University 2 Silver Oak College of Engineering & Technology

2101030400443 Introduction to Project

3. MySQL: MySQL is an open-source relational database management system

(RDBMS) that uses Structured Query Language (SQL) for database management.
It is widely used for web applications due to its reliability, scalability,
and ease of use.

1.5.2 Literature Review

The literature review for Study Notion focuses on existing research on freelancing
platforms, their challenges, and emerging technologies in job matching and
communication. It also examines best practices for managing databases, ensuring security,
and creating efficient user interfaces in web applications. The review will help identify key
insights to inform platform development, particularly around efficient data management
and user interaction.

1.6 Project Planning

Project Development Approach and Justification

Given the scope and goals of Study Notion, an agile development approach is chosen,
allowing flexibility for feature updates and changes as needed. This iterative process
ensures that features like real-time communication and project tracking are developed and
tested effectively, with room for improvements based on feedback.

Project Effort and Time

Effort and time are allocated according to the phases outlined in the project timeline,
considering the capacities and availability of the developer. Each phase has specific
durations assigned to ensure steady progress. Tasks are prioritized using milestone planning
and agile techniques to ensure optimal productivity.

Roles and Responsibilities

As the sole contributor, all roles and responsibilities fall on the project owner. This includes
project management, development, design, testing, and documentation tasks. The project
owner is responsible for overseeing all aspects of the project, from conceptualization to
deployment and review. Clear delineation of tasks and priorities is essential to ensure
efficient progress and successful completion of the project within the specified timeline.

Silver Oak University 3 Silver Oak College of Engineering & Technology

2101030400443 Introduction to Project

1.7 Project Scheduling (Gantt Chart)

Fig 1.7 Gantt Chart for Project Planning

Silver Oak University 4 Silver Oak College of Engineering & Technology

2101030400443 System Analysis

Chapter-2 System Analysis

2.1 Problem and Weakness of Current System

Existing freelancing platforms face several significant challenges that hinder the overall
user experience for both freelancers and clients. The most pressing issues include:
1. High Service Fees: Many popular freelancing platforms charge hefty service fees,
often as high as 20-30% of the freelancer's earnings. This reduces the overall
income for freelancers, making it difficult for them to sustain long-term projects.
2. Delayed Payments: Freelancers frequently experience delays in receiving
payments, leading to financial instability. Traditional payment processes are often
slow and cumbersome, adding to the frustration of both freelancers and clients.
3. Poor Job Matching: Most freelancing platforms rely on simple keyword-based
search systems to match freelancers with clients. This results in inefficient and
inaccurate matches, often leading to frustration for both parties and wasted time.
4. Lack of Skill Verification: Freelancers’ skills and qualifications are not always
verified on many platforms, leaving room for uncertainty and potential dishonesty.
Clients may struggle to find qualified individuals for specialized tasks, which can
impact project quality and trust.
5. Limited Communication Tools: Communication is often limited to basic chat
features, lacking more dynamic and real-time options such as video calls or
advanced project tracking. This reduces collaboration and hampers productivity on
both sides.
6. Security Concerns: Many freelancing platforms store sensitive information
without robust security measures, putting both freelancers and clients at risk of data
breaches and fraud.
These weaknesses make the current freelancing platforms inefficient and less trustworthy,
leaving room for innovation and improvement. Study Notion aims to address these
problems by offering lower service fees, instant and secure payments, AI-powered job
matching, verified freelancer profiles, and enhanced communication tools.

Silver Oak University 5 Silver Oak College of Engineering & Technology

2101030400443 System Analysis

2.2 Requirements of New System

• Efficient Job Matching.

• Real-Time Communication.
• Skill Verification.
• User-Friendly Interface.
• Project Tracking.
• Scalable Architecture

2.3 System Feasibility

The Study Notion system is feasible across technical, economic, and operational
dimensions. Technically, the use of the MERN stack and MySQL, combined with the
developer's expertise, ensures successful implementation. Economically, the platform
offers value through lower service fees, secure payments, and AI-powered job matching,
which will drive user engagement and revenue. Operationally, the user-friendly interface
and real-time communication features align with the platform's goals, ensuring efficiency
and scalability. Ongoing monitoring and evaluation will address challenges and ensure the
system’s long-term success.

2.4 Proposed System

• Frontend Architecture:

Study Notion's frontend architecture is built using React.js, utilizing a component-based

approach to ensure modularity and reusability. Components like job listings, user profiles,
and bid submissions are encapsulated, enabling easy customization and scalability.
React.js’s virtual DOM optimizes UI rendering and updates, while state management tools
like Redux ensure a seamless user experience.

• Backend Architecture:

Study Notion's backend is developed using Node.js and Express.js, following a RESTful
API architecture for efficient communication between the frontend and backend. The
backend handles user authentication, job posting, and bid management. MySQL is used for
managing relational data, ensuring efficient storage and retrieval. The backend structure
promotes maintainability, scalability, and effective management of user data and job
interactions.

Silver Oak University 6 Silver Oak College of Engineering & Technology

2101030400443 System Analysis

• Database Architecture:

Study Notion uses MySQL as its relational database to store user profiles, job postings,
bids, and payment details. Foreign key constraints ensure data integrity; while indexing and
optimization techniques improve query performance. The database architecture is designed
to handle a growing user base and maintain efficient data management, supporting smooth
interactions between freelancers and clients.

2.5 Features of New System

• Lower Service Fees: The platform offers reduced service fees compared to
traditional freelancing platforms, improving cost-effectiveness for freelancers and
clients.
• Real-Time Communication Tools: Integrated chat and video call functionality for
seamless communication between freelancers and clients, enhancing collaboration.
• Skill Verification: Freelancers can verify their skills through assessments,
certifications, or third-party endorsements to build credibility.
• Job Posting and Bidding: Clients can easily post job listings with detailed
descriptions, and freelancers can browse available jobs and submit proposals based
on their skills and availability.
• Project Tracking: Real-time project tracking allows both clients and freelancers to
monitor progress, milestones, and deadlines effectively.
• Feedback and Rating System: Clients and freelancers can rate and review each
other after project completion, fostering trust and transparency.
• User-Friendly Interface: A clean, intuitive, and responsive design ensures a
smooth user experience across all devices.
• Admin Panel: Admins have the ability to manage user activities, moderate content,
and resolve disputes efficiently.

2.6 List Main Modules

The system after careful analysis has been identified to be presented with the following
modules and roles. The modules involved are:

1. User Management
2. Job Posting and Bidding
3. Project Tracking
4. Communication Tools
5. Skill Verification
6. Feedback and Rating System

Silver Oak University 7 Silver Oak College of Engineering & Technology

2101030400443 System Analysis

7. Admin Panel
8. Service Fee Management
9. Database Management
10. User Interface

2.7 Selection of Hardware and Software

2.7.1 Requirements of Hardware:

1. Processor: A modern multi-core processor capable of handling concurrent user

requests and running web browsers and server software efficiently. A higher clock
speed and multiple cores will improve performance during peak usage times.

2. Memory (RAM): A minimum of 8GB of RAM is recommended for smooth

operation, especially during periods of high traffic or multiple simultaneous users. More
RAM will benefit performance when handling large datasets or numerous active
sessions.

3. Storage: At least 100GB of storage is recommended for the application files, user
data, databases, and backups. The storage requirement will grow based on the number
of users, job postings, and project data.

4. Network Interface: A stable and high-speed internet connection is essential for

hosting the web application, ensuring fast data transfer and smooth interaction between
users and the server.

5. Operating System: Study Notion can be deployed on any operating system that
supports required software, including Windows, macOS, and Linux distributions. The
choice of OS will depend on the developer's preferences and the server hosting
environment.

6. Server Infrastructure: If self-hosting, consider a dedicated server or cloud-based

hosting services like AWS, Google Cloud, or Azure. The server should have sufficient
resources (CPU, RAM, bandwidth) to handle expected traffic, data storage, and user
activity.

Silver Oak University 8 Silver Oak College of Engineering & Technology

2101030400443 System Analysis

2.7.2 Requirements of Software

1. Web Server
2. Operating System
3. Database Management System
4. Node.js and Express.js packages
5. Version Control (Github)
6. Development Tools

Silver Oak University 9 Silver Oak College of Engineering & Technology

2101030400443 System Design

Chapter-3 System Design

3.1 System Design And methodology:

The design of Study Notion focuses on building a scalable, secure, and user-friendly
freelancing platform that can efficiently handle various processes, including job posting,
bidding, project tracking, and communication. The design incorporates modular
components that ensure maintainability and flexibility. Below are the key components of
the system design:
1. Frontend Design:
o Built using React.js for a dynamic and responsive user interface.
o Redux is used for efficient state management.
2. Backend Design:
o Developed with Node.js and Express.js using a RESTful API architecture
for modular and scalable backend management.
3. Database Design:
o MySQL for relational data (user profiles, job postings, bids) and MongoDB
for non-relational data (user activity logs).

Table 5.5.1 User (Client & freelancer) data

Column Type & Constraints

User_Id Int primary key

Email Varchar not null

First_name Varchar not null

Last_name Varchar not null

Password Varchar not null
Address Varchar not null
City Varchar not null
State Varchar not null
isClient Boolean

Silver Oak University 10 Silver Oak College of Engineering & Technology

2101030400443 System Design

Table 5.5.2 Client Projects table

Column Type & Constraints

Project_Id Int primary key
Ttitle Varchar not null
Description Varchar not null
Category Varchar not null
Skills Varchar not null
Scope Varchar not null
Duration Enum not null
Experience Type Enum not null
Project_Rate Int not null
File Varchar not null
Total_Proposals Int not null
User_Id(isClient: true) Int foreign key not null

4. Security Design:
o JWT for authentication and role-based access control (RBAC) for
authorization.
o Data encryption ensures user privacy and security.
5. Communication Design:
o WebSockets and third-party APIs are used for real-time chat and video calls.

Methodology

1. Agile Scrum Framework:

o Development in 2–3 week sprints, delivering functional features
incrementally.
2. Requirements Gathering:
o Initial requirements are collected from user feedback and market research.
3. Iterative Development:
o Features developed and tested in increments, allowing for early feedback
and refinement.
4. Continuous Integration & Testing:
o CI/CD pipelines and rigorous testing ensure smooth development and
deployment.
5. User Feedback & Refinement:
o Continuous feedback collection and iterative improvements to meet user
needs.
6. Deployment:
o Deployed on cloud infrastructure for scalability and high availability.

Silver Oak University 11 Silver Oak College of Engineering & Technology

2101030400443 System Design

3.2 INPUT/OUTPUT DESIGN

3.2.1 Use-Case Diagram

Fig 3.2.1 Use-Case Diagram

Silver Oak University 12 Silver Oak College of Engineering & Technology

2101030400443 System Design

3.2.2 E-R Diagram

Fig 3.2.2 E-R Diagram

Silver Oak University 13 Silver Oak College of Engineering & Technology

2101030400443 System Design

3.2.3 Data Flow Diagram

Fig 3.2.3 Data flow Diagram

Silver Oak University 14 Silver Oak College of Engineering & Technology

2101030400443 Testing

Chapter – 4 System Implementation

4.1 Implementation of Database

MySQL integration in Study Notion involves designing a relational schema for users,
jobs, contracts, and messages, setting up the MySQL environment, and creating tables. The
database is connected to the Node.js backend using an ORM or direct queries. Error
handling, testing, and query optimization ensure smooth performance. Security measures
like SQL injection prevention and credential protection are implemented to safeguard user
data .

Fig 4.1.1 Home page

Silver Oak University 20 Silver Oak College of Engineering & Technology

2101030400443 Testing

Fig 4.2.2 Log in Page

Fig 4.2.2 Sign Up Page

Silver Oak University 21 Silver Oak College of Engineering & Technology

2101030400443 Testing

Chapter-5 TESTING

5.1 TESTING STRATEGY

1. Unit Testing: Conduct unit tests for individual components, including React.js
frontend components and backend Node.js/Express.js functions, to ensure they
work correctly in isolation.
2. Integration Testing: Test the interaction between frontend and backend modules
to ensure smooth data flow and API communication.
3. End-to-End Testing: Perform end-to-end tests to validate complete workflows like
user registration, job posting, bidding, and payments.
4. User Acceptance Testing (UAT): Involve selected users to test Study Notion’s
features and provide feedback on functionality, usability, and overall performance.
5. Regression Testing: Repeatedly test the system after updates to ensure existing
features remain unaffected by new changes.
6. Performance Testing: Assess system performance under different loads to ensure
it can handle peak traffic and large-scale data operations efficiently.
7. Security Testing: Identify and fix potential vulnerabilities, ensuring user data,
transactions, and communications are secure.
8. Compatibility Testing: Verify that Study Notion functions consistently across
various browsers, devices, and operating systems.
9. Accessibility Testing: Ensure the platform is accessible to users with disabilities,
following standard accessibility guidelines.
10. Usability Testing: Evaluate the user interface and experience to identify
improvements that enhance overall ease of use.

Silver Oak University 22 Silver Oak College of Engineering & Technology

2101030400443 Conclusion and Future Work

Chapter-6 Conclusion and Future Work

6.1 OVERALL ANALYSIS OF PROJECT

Study Notion offers an efficient and user-friendly freelancing platform that tackles major
issues like high fees, delayed payments, and poor job matching. Built with React.js,
Node.js, MySQL, and MongoDB, it ensures smooth performance, secure data handling,
and real-time project tracking. Though advanced features like AI and payment integration
are planned for the future, the current version provides a solid, scalable foundation.
Thorough testing and security measures further strengthen the platform’s reliability and
user trust.

8.2 PROBLEM ENCOUNTERED AND POSSIBLE SOLUTIONS

• Problem Encountered:
One major problem encountered during the development of Study Notion was the challenge
of efficiently managing and processing large volumes of user and project data in real-time.
This led to performance issues, slow API responses, and occasional delays in loading job
listings and chat data, negatively impacting user experience.

• Possible Solutions:
1. Data Optimization: Implement data optimization strategies such as indexing, query
optimization, and caching frequently accessed data to reduce load on the database and
improve response times.

2. Asynchronous Processing: Use asynchronous programming (via async/await and

background jobs) to handle time-consuming tasks like file uploads and chat syncing,
allowing the server to remain responsive.

3. Scalability Planning: Design the backend architecture to be scalable using load

balancing and modular microservices. Consider cloud-based solutions for database and
server scaling as traffic grows.

4. Performance Monitoring: Integrate monitoring tools like PM2, New Relic, or custom
logging to track performance metrics, identify bottlenecks, and fine-tune the system for
optimal performance.

Silver Oak University 21 Silver Oak College of Engineering & Technology

2101030400443 Conclusion and Future Work

Conclusion
Study Notion aims to further enhance the freelancing experience with advanced features
such as:
• AI-powered job and talent matching for better opportunities.
• Integration with cryptocurrency and UPI payment systems for faster, more flexible
transactions.
• Blockchain-based smart contracts for secure and transparent project agreements.
Study Notion represents a new era in freelancing platforms, offering users unmatched
efficiency, trust, and control. By leveraging modern technology, Study Notion empowers
freelancers and clients alike to collaborate seamlessly and thrive in the digital economy.

Silver Oak University 22 Silver Oak College of Engineering & Technology

2101030400443 Conclusion and Future Work

References
1. React.js Documentation – Guides UI development for the freelancing platform. React Docs
2. Node.js Documentation – Supports backend and API handling. Node.js Docs
3. MongoDB Documentation – Database management for users and jobs. MongoDB Docs
4. McKinsey Report – Covers freelancing and remote work trends. McKinsey Report

END

Silver Oak University 23 Silver Oak College of Engineering & Technology