VISVESVARAYA TECHNOLOGICAL UNIVERSITY

“Jnana Sangama”, Belagavi – 590018, Karnataka

A Mini Project Report on

“DRIVE MANAGEMENT”

Submitted in the partial fulfillment for award of the degree of

BACHELOR OF ENGINEERING

in

INFORMATION SCIENCE AND ENGINEERING

Submitted by
NISHA MANJUNATH POORVIKA K
(4MN19IS018) (4MN19IS021)
Under the guidance of

Prof. Mohammed Salamath

Maharaja Institute of Technology Thandavapura

Information Science and Engineering
Just off NH 766, Nanjanagudu taluk, Mysore district-571302.
2021-2022

I
 MAHARAJA INSTITUTE OF TECHNOLOGY THANDAVAPURA
NH 766, Nanjangud Taluk, Mysuru- 571 302
(An ISO 9001:2015 and ISO 21001:2018 Certified Institution)
(Affiliated to VTU, Belagavi and approved by AICTE, New Delhi)

DEPARTMENT OF INFORMATION SCIENCE & ENGINEERING

CERTIFICATE
Certified that the minor project work entitled “DRIVE MANAGEMENT” is a bonafide
work carried out by NISHA MANJUNATH (4MN19IS018) & POORVIKA K
(4MN19IS021) for the DATABASE MANAGEMENT SYSTEM LABORATORY with
course code 18CSL58
of Fifth Semester in Information Science & Engineering under Visvesvaraya Technological
University, Belagavi during academic year 2021-22.

It is certified that all corrections/suggestions indicated for Internal Assignment have been
incorporated in the report. The report has been approved as it satisfies the course
requirements.

_____________ _____________
Signature of Lab Staff In-Charge
Signature of the HOD
Prof. Mohammed Salamath
Prof. Swarnalatha K
Assistant Professor Associate Professor & HOD
Dept. of IS&E Dept. of IS&E

External viva
Name of the Examiners Signature with date

1)…………………………… …………………………
2)…………………………… …………………………
II
 ACKNOWLEDGEMENT

It is the time to acknowledgement all those who have extended their guidance, inspiration and
their whole hearted co-operation all along our project work.

We would like to extend my thanks to Dr. Y T KRISHNE GOWDA, Principal, Maharaja

Institute of Technology Thandavapura, for his co-operation throughout the academics. That
has helped me in satisfactory completion of project.

We are grateful to Ms. SWARNALATHA K, Professor and HOD, Department of

Information Science & Engineering, for providing me an invaluable support throughout the
period of Internship.

We express my sincere thanks to Dr. H K Chethan, Joint Secretary MET, Mysore. For his
continous support and appreciation during this Program.

We express my deepest sense of gratitude to my guide Mr. Mohammed Salamath, Assistant

Professor, Department of Information Science & Engineering, for his valuable guidance,
suggestions and cheerful encouragement during the entire period of my Internship program.

We also take an opportunity to thank all the teaching and non teaching staff members of ISE
department.

Finally, we thank almighty god and I am grateful to my Parents for their faith, love and
kindness in believing me.

We are indebted to MITT, who has directly or indirectly supported me during the period of
my mini project.
Nisha Manjunath (4MN19IS018)

Poorvika K (4MN19IS021)

III
 CONTENTS
TABLE OF CONTENTS

CHAPTERS Page no
1. INTRODUCTION
1.1. Motivation 1
1.2. Proposed System 1
1.3. Related Work 1

2. REQUIREMENTS ANALYSIS AND SYSTEM SPECIFICATIONS

2.1 Software Requirements Specification Document 2

2.2 Validation 2

3. SYSTEM DESIGN
3.1 Design Approach 3

3.2 Layout Approach 4-5

4. IMPLEMENTATION
4.1 Introduction to Programming Languages, IDEs, Tools and Technologies 6

4.2 Layout Implementation 7-9

5. TESTING
5.1 Types of Testing 10

5.2 Test cases and its result 11

6. SNAPSHOTS 12-14
7. FUTURE WORK 15
8. CONCLUSION 16
9. BIBLIOGRAPY 17

IV
CHAPTER-1
INTRODUCTION

1.1 MOTIVATION

NOTE APP is a user-friendly application. It is used to digitize the note taking process through an
android app so that anyone can take notes and store it from anywhere efficiently, without any hassle.

1.2 PROPOSED SYSTEM

NOTE APP: Note taking app allow us to store all notes and important information. With the help of
this app, the entire process is digitized. Type notes on device just as one would using pen and paper.
The application is implemented on android platform which is linked to the SQLite database for access
of data.
Our project will make the note taking procedure easier for the users, by having a user-friendly UI for
typing, storing and manage the note according to priority. We can also delete the note with just a
swipe. There will be a provision for searching a note. We have proposed an exclusive feature which
lets the user add a note based on the priority of the note or work to be done.

1.3 RELATED WORK

Our project will make the note taking procedure easier for the users, by having a user-friendly UI for
typing, storing and manage the note according to priority. We can also delete the note with just a
swipe.

V
CHAPTER-2

REQUIREMENT ANALYSIS AND SYSTEM SPECIFICATIONS

2.1 SOFWARE REQUIREMENTS SPECIFICATION DOCUMENT

OS: Android 8 or

higher Memory:

4GB RAM

Free storage:

2GB

Android

Studio

Android Software

Development Kit Java

Development Kit

The SDK and AVD Manager

2.2VALIDATION
In this project, when the user creates note he/she should enter the title and also the description.
If any of these fields is kept empty, the app displays enter title if title is kept empty and enter
description if description is empty.
VI
CHAPTER-3

3. SYSTEM DESIGN

3.1 DESIGN APPROACH

3.2 LAYOUT APPROACH

MAIN SCREEN
MAIN_ACTIVITY SPLASH SCREEN

ADD NOTE
CHAPTER-4
IMPLEMENTATION

INTRODUCTION TO PROGRAMMING LANGUAGES, IDEs,

TOOLS AND TECHNOLOGIES
ANDROID STUDIO

Android Studio is the official Integrated Development Environment (IDE) for Android app
development, based on IntelliJ IDEA. On top of IntelliJ's powerful code editor and developer tools,
Android Studio offers even more features that enhance your productivity when building Android apps.

ANDROID SOFTWARE DEVELOPMENT KIT

The Android SDK (software development kit) is a set of development tools used to develop
applications for the Android platform. It’s a set of software tools and programs used by developers to
create applications for specific platforms. The Android SDK includes the following: Required
libraries, Debugger.

JAVA DEVELOPMENT KIT

Java is one of the most popular coding languages out there, and Java Development Kit (or JDK) is its
official development package. Currently, Java Development Kit is also one of the most popular
development

environments in which to code Java. The Java Development Kit offers a wide range of practical
tools like javac. You also have java and jdb which works as the debugger of the system.

THE SDK AND AVD MANAGER

The sdk manager is a command line tool that allows you to view, install, update, and uninstall
packages for the Android SDK. The avd manager is a command line tool that allows you to create and
manage Android Virtual Devices (AVDs) from the command line. An AVD lets you define the
characteristics of an Android handset, Wear OS watch, or Android TV device that you want to
simulate in the Android Emulator.

SQLITE-DATABASE

SQLite is a open source SQL database that stores data to a text file on a device. Android comes
in with built in SQLite database implementation. SQLite supports all the relational database features. In
order to access

2
Maharaja Institute of Technology Thandavapura
Chapter 2
Requirement and Analysis
2.1 Existing
System
The existing system would require a lot of time consuming process in filtering the students
based on their interests of domain .Students may not be having a good information about the
company requirements and a poor communication between the placement related admins is
a huge loss for their budding carrier . More man power is necessary to maintain the record
and paper work .The earlier system is not fully computerized . So there would be a high
chances of missing out of crucial data.

2.2 Proposed System

The proposed system would come in handy to both students as well as the college admins
handling the placement drives.The College Administrator would handle all the technical
issues related to the entire system. The role of the admin[Administrator] is to upload all the
student details and pick out the best suited candidate based on the company requirements.
The two tier tests conducted shall filter the candidates upon their comfort and level of
intellectual knowledge and would result in the undoubted recruitment

3
Maharaja Institute of Technology Thandavapura
2.3 Hardware Requirements
RAM : 4GB(Minimum)

Hard Disk :1TB

Processor : 1.4GHz 64 bit

2.4 Software Requirements

Operating system : Windows 10

Front End : Netbeans (Java FX)

Bank End : MySQL

4
Maharaja Institute of Technology Thandavapura
Chapter 3
System Design
3.1 Schema
Diagram

Fig 3.1 : Schema Diagram

5
Maharaja Institute of Technology Thandavapura
3.2 ER Diagram

Fig 3.2 : ER Diagram

6
Maharaja Institute of Technology Thandavapura
3.2.1 MySQL Server
SQL (Structured Query Language) is a domain-specific language used in
programming and designed for managing data held in a relational database
management system (RDBMS), or for stream processing in a relational data
stream management system (RDSMS). In comparison to older read/write APIs
like ISAM or VSAM, SQL offers two main advantages: first, it introduced the
concept of accessing many records with one single command; and second, it
eliminates the need to specify how to reach a record, e.g. with or without an
index. Originally based upon relational algebra and tuple relational calculus,
SQL consists of a data definition language, data manipulation language, and
data control language. The scope of SQL includes data insert, query, update
and delete, schema creation and modification, and data access control.
Although SQL is often described as, and to a great extent is, a declarative
language (4GL), it also includes procedural elements. SQL was initially
developed at IBM by Donald D.

Chamberlin and Raymond F. Boyce in the early 1970s. This

version, initially called SEQUEL

(Structured English Query Language), was designed to manipulate and retrieve

data stored in IBM's original quasirelational database management system,
System R, which a group at IBM San Jose Research Laboratory had developed
during the 1970s.

The SQL language is subdivided into several language elements,

including:
Clauses, which are constituent components of statements and

queries. (In some cases, these are optional.)

Expressions, which can produce either scalar values , or tables consisting

columns and rows of data

7
Maharaja Institute of Technology Thandavapura
3.2.2 Normalization
Normalization is the process of efficiently organizing data in a database. There
are two goals of the normalization process: eliminating redundant data (for
example, storing the same data in more than one table) and ensuring data
dependencies make sense (only storing related data in a table). Both of these
are worthy goals as they reduce the amount of space a database consumes and
ensure that data is logically stored. There are several benefits for using
Normalization in Database.

Benefits:

 Eliminate data Redundancy

 Improve Performance
 Query optimization
 Faster update due to less number of columns in one table index improve.

There are different types of normalizations form available in the database.

1. First Normal Form (INF):

First normal form (INF) sets the very basic rules for an organized database:

 Create separate tables for each group of related data and identify each row
withunique column or set of columns (the primary key).
 Remove repetitive groups .
 Create Primary Key
Before we proceed let's understand a few things A KEY is a value used to
identify a record in a table uniquely. A KEY could be a single column or
combination of multiple columns Note: Columns in a table that are NOT used
to identify a record uniquely are called non-key columns. Primary Key

8
Maharaja Institute of Technology Thandavapura
2. Second Normal Form(2NF):

Second normal form(2NF) further address the concept of removing duplicative data:

 Meet all the requirements of the first Normal form.

 Remove the subset of data that apply to multiple rows of a table and place them
in separate tables.

3. Third Normal Form (3NF):

Third normal form (3NF) goes one large step further:

 Meet all the requirements of the second normal form.

 Remove columns that is not dependent upon the primary key.

4. Fourth Normal Form (4NF):

Finally, fourth normal form (4NF) has one additional requirement:

 Meet all the requirements of the third normal form.

 A relation is in 4NF if it has no multi-valued dependencies.

If PK is composed of multiple columns then all non-key attributes should be

derived from FULL PK only. If some non-key attribute can be derived from
partial PK then remove it. The 4NF also known as BCNF NF.

The E-Drive Management Database satisfies 4th Normal Form.

9
Maharaja Institute of Technology Thandavapura
Chapter
4
Implementation and Results

Implementation of a DBMS project means carrying out the execution of any

idea or model. It refers to the process of setting a new software or hardware
for doing the specific task. In our mini project we have used NETBEANS
and MySQL for front-end and back-end respectively and Jar file is used to
connect both front-end and back-end.

Fig 4.1 : Connectivity between NetBeans and MySQL

10
Maharaja Institute of Technology Thandavapura
Implementation of Front End And Back End
4.1 PSEUDOCODE

To Insert An Element
Declare variables;
Try:
Import connection provider;
Create statement;
Perform
St.executeupdate(Insert into table _name values(attribute1,attribute2,attribute3…….);
Show message dialog(“inserted successfully”);
Catch;
Show message dialog(“Attribute value already exists”);

To update an Element
Declare variables;
Try;
Import connection provider;
Create statement;
Perform
St.executeupdate(update table_name set(attribute1=value1, attribute2=value2,
attribute3=value3…..);
Show message dialog(“updated successfully”);
Catch;
Show message dialog(“Please enter the data in the correct format”);

11
Maharaja Institute of Technology Thandavapura
To Delete an Element
Declare variables;
Try;
Import connection provider;
Create statement;
Perform
St.executeupdate(delete from table_name where attribute=value);
Show message dialog(“deleted successfully”);
Catch;
Show message dialog(“Attribute value dosen’t exist”);

To Search The Details

Declare variables;
Try;
Import connection provider;
Create statement;
Perform
Create an object rs from the class result set(Result Set) and perform the following;
St.executeQuery(“Select * from table_name where attribute=value”);
If(rs.next()):
jTextField2.setvalue(rs.value(2));
jComboBox1.setvalue(rs.getvalue(3));
jDataChooser1.setvalue(rs.getvalue(4));
jTextField5.setvalue(rs.value(5));
Else:
Show message dialog(“Attribute value dosen’t exist”);
End if;
Catch;

12
Maharaja Institute of Technology Thandavapura
To Display The Table
Drag and Drop another jframe to the current jframe on the screen;
Access another jframe through navigator
And insert the table into jframe
And perform the following in the coding section:
Set the visibility of the second jframe from to true;
Set the size of the table;
Import DefaultTableModel Class;
Create object model;
Try:
Import connection provider;
Create statement;
String query=Execute query(“select * from attribute”);
Import class ResultSet;
Create an object rs;
Execute the query;
While(rs.next()):
String value1=rs.getvalue(“attribute name1”);
String value2=rs.getString(“attribute name2”);
String value2=rs.getString(“attribute name2”);
String value2=rs.getString(“attribute name2”);
String value2=rs.getString(“attribute name2”);
Model.addRow(newObject[]{attribute1, attribute2, attribute3, attribute4, attribute5,});
Catch:
Show message dialog(“Error in fetching the data”);

13
Maharaja Institute of Technology Thandavapura
4.2 Results
4.2.1 Snapshots

Fig 4.3: Login form

Fig 4.4: Home Page

14
Maharaja Institute of Technology Thandavapura
Fig 4.5: New User Registration

Fig 4.6: Admin Registration

15
Maharaja Institute of Technology Thandavapura
 Fig 4.7: Saving Student Details

Fig 4.8: Updating Student Details

16
Maharaja Institute of Technology Thandavapura
 Fig 4.9: Company Details

Fig 4.10: Company Requirements

17
Maharaja Institute of Technology Thandavapura
Fig 4.11: Student Academic Details

Fig 4.12: Result Details

18
Maharaja Institute of Technology Thandavapura
 Conclusions and Future Enhancement

Presently we designed the E-drive project to be as user friendly as possible . The main motto
behind our intentions is to save the time of the candidate as well as the person in-charge of
the placements in the respected college.
We have given a chance to students to rate their own skills so as to showcase their
capabilities far more than just academics. Since there is a feature of double tier tests, there
are more chances that the candidates chosen truly belong to what they deserve.
Further the project can be more enhanced by including the following:
Conducting and including more competitive contests for Coding and English rounds. It can
be made more interactive and automated by adding extra features which eases out the
documentation process.
It can be made more authenticated by introducing the Date of Birth confirmation so the
privacy is maintained.

19
Maharaja Institute of Technology Thandavapura
References
[1] Fundamentals of Database Management System by Pearson author
Navathe7th

[2] PHP Pandas by Daylee rees.

[3] Learn to code HTML and CSS by shay Howe.

[4] Software engineering by Roger S. Pressman

[5] Raghu Ramakrishna and Johnnes Gehrke, Database Management System,

Mcgraw hill publication,3rd edition,2014.

20
Maharaja Institute of Technology Thandavapura