VISVESVARAYA TECHNOLOGICAL UNIVERSITY

Jnana Sangama, Belagavi-590010

DBMS MINI PROJECT REPORT

ON
“IMPLEMENTATION OF SUPPLY CHAIN MANAGEMENT FOR
L&T CONSTRUCTION AND MINING USING DATA
ANALYTICS”
Submitted in partial fulfillment for the requirements for the fifth semester

BACHELOR OF
ENGINEERING
IN
COMPUTER SCIENCE AND ENGINEERING

For the Academic Year 2023-2024

Submitted by:
BHARATH N 1MV13CS027
BHARATH M.S 1MV13CS028
K VARSHA MEGHANA 1MV13CS043
MADIRAJU MONA SRI 1MV13CS060

Under the guidance of:

Dr. Suma Swamy
Professor, Department of CSE
Sir M. Visvesvaraya Institute of Technology, Bengaluru

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

SIR M. VISVESVARAYA INSTITUTE OF TECHNOLOGY
HUNASAMARANAHALLI, BENGALURU-562157

I
SIR M. VISVESVARAYA INSTITUTE OF TECHNOLOGY
Krishnadevaraya Nagar, International Airport Road,
Hunasmaranahalli, Bengaluru – 562157
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

CERTIFICATE
It is certified that the DBMS Mini Project work entitled " PREDICTIVE ANALYSIS OF
DEPRESSION VIA SOCIAL MEDIA MINING " is carried out by DEEPTHI KUMAR
(1MV16CS027), DONA SARKAR (1MV16CS030), SEEMA G (1MV16CS132),
ARPITHA K N (1MV16CS134) bonafide students of Sir M. Visvesvaraya Institute of
Technology in partial fulfillment for the 5th semester for the award of the Degree of Bachelor
of Engineering in Computer Science and Engineering of the Visvesvaraya Technological
University, Belagavi during the academic year 2023-2024. It is certified that all corrections
and suggestions indicated for Internal Assessment have been incorporated in the report
deposited in the department library. The project report has been approved as it satisfies the
academic requirements in respect of project work prescribed for the course of Bachelor of
Engineering.
Name & Signature Name & Signature Name & Signature
of Guide of HOD of Principal

Dr . Suma Swamy Dr. Anitha T N Prof. Rakesh S G

Prof & Internal Guide HOD, Dept. Of Principal,
Dept. Of CSE, Sir MVIT CSE, Sir MVIT Sir MVIT
Bengaluru - 562157 Bengaluru - 562157 Bengaluru – 562157

External Examination:

Name of Examiner Signature with Date

1)

2)

II
DECLARATION

We hereby declare that the entire project work embodied in this dissertation has been carried
out by us and no part has been submitted for any degree or diploma of any institution
previously.

Place: Bengaluru

Date:

Signature of Students:

DEEPTHI KUMAR DONA SARKAR

(1MV16CS027) (1MV16CS030)

SEEMA G ARPITHA K N
(1MV16CS132) (1MV16CS134)

III
ACKNOWLEDGMENT

It gives us immense pleasure to express our sincere gratitude to the management of

Sir M. Visvesvaraya Institute of Technology, Bengaluru for providing the opportunity and
the resources to accomplish our project work in their premises.

On the path of learning, the presence of an experienced guide is indispensable and we

would like to thank our guide Dr Suma Swamy, Professor, Department of CSE, for her
invaluable help and guidance.

Heartfelt and sincere thanks to Dr. Anitha T N, HOD, Department of CSE, for her
suggestions, constant support and encouragement.

We would also like to convey our regards to Prof. Rakesh S G, Principal, Sir MVIT
for providing us with the infrastructure and facilities needed to develop our project.

We would also like to thank the staff of Department of Computer Science and
Engineering and lab-in-charges for their co-operation and suggestions. Finally, we would like
to thank all our friends for their help and suggestions without which completing this project
would not have been possible.

- DEEPTHI KUMAR 1MV16CS027

- DONA SARKAR 1MV16CS030
- SEEMA G 1MV16CS132
- ARPITHA K N 1MV16CS134

IV
ABSTRACT

The growth in popularity of social networking leads to the problematic usage. An

increased number of social network mental disorders , such as Cyber-Relationship Addiction,
Information Overload , have been recently noted. Symptoms of these mental disorders are
usually observed less today, resulting in delayed clinical intervention . In this paper, we argue
that mining online social behavior provides an opportunity to actively identify depression at an
early stage. It is challenging to detect disorders because the mental status cannot be directly
observed from online social activity logs.

Our approach, new and innovative to the practice of mental depression detection, does
not rely on self- revealing of those mental factors via questionnaires in Psychology. Instead, we
propose a machine learning framework that exploits features extracted from social network data
to almost accurately identify potential case

V
TABLE OF CONTENTS

Chapters Page No.

1. Introduction 1-7

Introduction to SCM

Need For SCM

Aim / Objectives Of This Project

2. Front End and Back End 8-10

Python (Back-End)
Libraries
Django
HTML(Front-End)
CSS
JavaScript

15-20
3. Specifications

Hardware Requirements 15
Software Requirements 16

Functional Requirements 17
19
Non-Functional Requirements

4. System Design
21-22
4.1 UML Diagram 21
4.2 ER Diagram 22
5. Conceptual Design 23-26
5.1 Create Commands 23
5.2 Insert Commands and Data 24
5.3 SQL Queries 25

VI
5. Front End Design, Connectivity and 27-29
Implementation
4.1 Data Acquisition 27
4.2 Data Pre-processing 27
4.3 Data Segmentation 28
4.4 Data Clustering 28
4.5 Feature Extraction 29

7. Source Code- Front end 30-36

8. Results, Discussion & Screenshots 39-46

9. Conclusion & Scope 47

References & Weblinks 48-49

VII
LIST OF FIGURES

Fig. No. Description Page No.

5.1 System Architecture 10

5.2 Use-Case Diagram 11
5.3 Sequence Diagram 12
5.4 Activity Diagram 13
8.1 Preprocessing the train data 25
81.1 preprocess.py 25
8.2 Decisiontree_ Accuracy.py 26
8.3 LogisticRegression_Accuracy.py 26
8.4 MLP_Accuracy.py 27
8.5 NaiveBayes_Accuracy.py 27
8.6 RandomForest_Accuracy.py 28
8.7 SVM_Accuracy.py 28
8.8 XGBoost_Accuracy.py 29
8.9 Decisiontree.py 29
8.9.1 Decisiontree.py 30
8.10 SVM.py 30
8.10.1 SVM.py 31
8.11 Naïve Bayes.py 31
8.11.1 Naïve Bayes.py 32
8.12 views.py 32
8.12.1 views.py 33
8.13 RandomForest.py 33
8.13.1 RandomForest.py 34
8.14 Urls.py 34
10.1 Home screen 39
10.2 About the Project 39
10.3 Info Page 40

VIII
CHAPTER1 INTRODUCTION

CHAPTER 1

INTRODUCTION

History
References to mental illness can be found throughout history. The evolution of
mental illness, however, has not been linear or progressive but rather cyclical.
Whether a behaviour is considered normal or abnormal depends on the context
surrounding the behaviour and thus changes as a function of a particular time and
culture. In the past, uncommon behaviour that deviated from the sociocultural norms
and expectations of a specific culture and period has been used as a way to silence or
control certain individuals or groups. As a result, a less cultural relativist view of
abnormal behaviour has focused instead on whether behaviour poses a threat to
oneself or others or causes so much pain and suffering that it interferes with one’s
work responsibilities or with one’s relationships with family and friends.

In today’s world, many of us rely on social media platforms such as

Facebook, Twitter, Snapchat, YouTube, and Instagram to find and connect with each
other. Each has its benefits, it’s important to remember that social media can never
be a replacement for real-world human connection. It requires in-person contact
with to trigger the hormones that alleviate stress and make you feel happier,
healthier, more positive. Ironically for a technology that’s designed to bring people
closer spending too much time engaging with social media can actually make you
feel lonely and isolated and increase mental problems such as anxiety and depression

Since it’s a relatively new technology, there’s little research to establish the
long- term consequences, good or bad, of social media use. However, multiple
studies have found a strong link between heavy social media and an increased risk
for depression, anxiety, loneliness, self-harm, and even suicidal thoughts.

DEPT. OF CSE, SIRMVIT 2023-2024 1

CHAPTER1 INTRODUCTION

Overview
Social media platforms are designed to snare your attention, keep you online, and
have you repeatedly checking your screen for updates. It’s how the companies
make money. But, much like a gambling compulsion or an addiction to nicotine,
alcohol, or drugs, social media use can create psychological cravings. When you
receive a like, a share, or a favourable reaction to a post, it can trigger the release
of dopamine in the brain, the same “reward” chemical that follows winning on a
slot machine, taking a bite of chocolate, or lighting up a cigarette, for example.
The more you’re rewarded, the more time you want to spend on social media,
even if it becomes detrimental to other aspects of your life.

This project aims to develop a deep learning predictive model to classify

users with depression. Because depression is a recurrent disease, it is interesting
in finding unusual patterns in user-generated content over time. Social network
posts over time were extracted for time series data. The predictive model for the
classification is obtained from deep learning techniques and the result is obtained.

QUERY DRILL DOWN

Figure 1.1 Timeseries Data …

DEPT. OF CSE, SIR MVIT 2023-2024 2

CHAPTER1 INTRODUCTION

The above graph gives the total income and quantiy of order with time. Here, almost 3 years
of data. And from the above graph we can say that that is huge improvement in the salse from
previous year to next year.

We will further narrow down this analysis to each month of the year and day of the month.

DEPT. OF CSE, SIR MVIT 2023-2024 3