Tools Management System Database-2
Tools Management System Database-2
BACHELOR OF TECHNOLOGY
in
CSE(Data Science)
By
MANIKANTH (21K91A6796)
V.SAIKRISHNA (21K91A6791)
CINEMA BOOKING SYSTEM under the guidance of MRS. Raja Raja Cholan, Assistant
professor,is submitted in partial fulfillment of the requirements for the award of the degree of
Bachelor of Technology in Computer Science and Engineering (Data Science).
MANIKANTH (21K91A6796):
SAIKRISHNA (21K91A67C8):
Place: Meerpet
Date: 29/01/2024
CERTIFICATE
This is to certify that the main project report entitled Tools management system
database
, being submitted by Mr.manikanth(21K91A6796), Mr.Vamshi kumar (21K91A6773),
Mr.Sai krishna (21K91A67C8), in partial fulfillment of requirements for the award of the
degree of Bachelor of Technology in Computer Science and Engineering (Data Science), to the
TKR College of Engineering and Technology, is a record of bonafide work carried out by
them under my guidance and supervision.
Place: Meerpet
Date: 29/01/2024
TABLE OF CONTENTS
ABSTRACT i
ACKNOWLEDGEMENTS ii
1 INTRODUCTION 1
Motivation 1
Problem definition 1
Proposed system 1
2 LITERATURE REVIEW 2
Review of Literature 2
3 REQUIREMENTS ANALYSIS 11
Functional Requirements 11
Non-Functional Requirements 11
4 DESIGN 12
5 CODING 17
Pseudo Code 17
6 IMPLEMENTATION and RESULTS
Implementation 27
Technologies Used 27
7 SCREENSHOTS 28
8 CONCLUSION 29
REFERENCES 30
ABSTRACT
Developing any large scale computer system requires the support of a whole
range of automated software tools. It is useful to distinguish two different kinds
of tools: technical tools, to deal with the technical aspects of system development
and management tools, as to have managerial control over the system's
development. To construct an effective, supportive development environment for
system engineering, it is essential that both the technical that both the technical
and managerial tools are integrated within a consistent, unifying framework. The
author considers system development as a database application, approaches to
providing software development databases, tool interfaces, object-oriented
database and some key issues in the field of database support for system
engineering
Key words: Tool, tool checkout, maintenance log, location, classification, Tool
tracking
ACKNOWLEDGEMENTS
The satisfaction and euphoria that accompanies the successful completion of any task would
be incomplete without the mention of the people who made it possible and whose en- couragement and
guidance have crowned our efforts with success.
My profound thanks to the management of TKR College of Engineering and Technology for
fostering an environment conducive to academic growth and providing the necessary resources for the
completion of this Thesis/Dissertation.
I extend my gratitude to Dr. V. Krishna, Head of the Department in Computer Science and
Engineering (Data Science), for his valuable support and guidance throughout the Thesis/Dissertation,
steering me through the intricacies of the project.
A special thanks to the Project Coordinator, Mr.Arokia Muthu, Faculty in the Department of
Computer Science and Engineering (Data Science) for his effective coordination and instrumental
assistance during the course of this academic journey, ensuring a smooth and well-guided project
execution.
Finally, my sincere commendation goes to Mrs. S . Raja Raja Cholan the Internal Guide and
Faculty in the Department of Computer Science and Engineering (Data Science), for her unwavering
encouragement and guidance, in the successful completion of this Thesis/Dissertation.
MANIKANTH (21K91A6770)
VAMSHI KUMAR (22K95A6710)
SAIKRISHNA (21K91A6791)
Place: Meerpet
Date: 29/01/2024
ii
LIST OF FIGURES
iii
Chapter 1
INTRODUCTION
Motivation
In today's fast-paced world, efficient tools management is essential for businesses and
organizations across various industries. The effective utilization and maintenance of tools are
critical to streamline operations, reduce downtime, and optimize resource allocation.
A Tools Management System Database is a modern solution designed to address these
challenges by providing a structured and centralized platform for tracking, monitoring, and
managing tools and equipment. This system aims to enhance productivity, reduce costs, and
improve overall operational efficiency.
This system provides a centralized platform to efficiently handle the acquisition,
maintenance, and utilization of tools, which is crucial for optimizing productivity, reducing
operational costs, and minimizing downtime. In a world driven by technology and data, having
a well-organized and automated tools management system is vital for enhancing overall
operational efficiency.
Proposed System
Tools Management System Database aims to simplify the organization and
tracking of tools within a workplace. This system would maintain a comprehensive list of
tools, recording details such as their names, types, purchase dates, and current locations.
User information, including names, job titles, and contact details, would be managed to
keep track of who is using the tools. A tool check-in/check-out system would monitor
when a tool is taken out and returned, with notes on its condition. Maintenance logs
would be kept to record any repairs, including costs and details of the work done.
Additionally, locations where tools are kept or used, tool categories, and supplier
information would be stored for efficient organization. The system would feature tool
tracking to monitor movements or changes in tool locations, ensuring real-time
information for users.
Chapter 2
LITERATURE REVIEW
1
2.1 Review of Literature
The literature survey on tools management system databases reveals a substantial body of
research, particularly in the 1980s and 1990s, driven by the emergence of computerized
manufacturing systems, including flexible manufacturing systems (FMS). Researchers
recognized that tooling posed a significant constraint, impeding the realization of full flexibility
in manufacturing systems. Various approaches to address these challenges have been proposed.
Notably, Mitsui et al. have delved into the design methodologies for tool databases, emphasizing
their role in planning tool usage within flexible automated manufacturing systems.
The existing limitations of tools management systems include the need for
comprehensive support throughout the tool life cycle, ensuring efficient tool utilization and
flexibility, especially in shared tool scenarios. To enhance the efficiency of tool use in these
systems, it is imperative for the tool database to encompass information spanning the entire tool
life cycle. The literature emphasizes the importance of providing real-time tool status and
machining schedule integration to facilitate optimal tool deployment.
Overall, the literature underscores the significance of robust tool management systems in
maximizing manufacturing system flexibility and efficiency, especially in the context of
evolving computerized manufacturing environments.
LITERATURE SURVEY-1
2
Merits:
LITERATURE SURVEY-2
Merits:
Merits:
LITERATURE SURVEY-4
4
Title: "RFID-Based Tool Tracking Systems in Manufacturing Environments"
Author: Gupta, S., & Sharma, R.
Merits:
Cost: Implementing RFID systems may involve initial setup costs, including the
purchase of RFID tags, readers, and related infrastructure.
Security Concerns: RFID technology raises security concerns, such as the
potential for unauthorized access or data interception. Proper encryption and
access control measures are crucial.
5
Environmental Challenges: Factors like interference from metal surfaces or other
electronic devices can impact the reliability of RFID signals, requiring careful
planning of system deployment.
Integration Complexity: Integrating RFID systems with existing tools
management databases and manufacturing systems may pose challenges,
especially in legacy environments.
Chapter 3
REQUIREMENTS ANALYSIS
Functional Requirements
1. Usability requirement
2. Serviceability requirement
3. Security requirement
5. Capacity requirement
6
6. Availability requirement
7. Scalability requirement
8. Interoperability requirement
9. Reliability requirement
7
Chapter 4
DESIGN
Manage
Customer Customer Manage
Information Database Booking
Records
Customer
Information Category Booking Info
Cate Database
gory
list
Category
Customer list
Admin
Category Booking
Choosen Database
Booking Transaction Information
Info
Booking
Manage Details
Booking
Records Transaction Manage
Database Transaction
8
DFD shows the entities that interact with a system and defines the border between the
system and its environment.
The illustration presents the main process in a single node to introduce the project context.
This context explains how the project works in just one look. The user feeds data into the system
and then receives the output from it.
A UML Use Case Diagram is a visual representation of a system's actors and the
system's use cases. A use case represents a function or group of functions, from the point of
view of an actor. Actors are external entities that interact with the system being modeled using
the provided functionality. They can be human users, other hardware devices, or software
systems. Use cases are represented as ellipses. They can be linked with dashed lines to show the
9
actor using them (and which actor initiated the use case).
A database design is a collection of stored data organized in such a way that the data
requirements are satisfied by the database. The general objective is to make information access
easy, quick, inexpensive and flexible for the user. There are also some specific objectives like
controlled redundancy from failure, privacy, security and performance. A collection of relative
records make up a table. To design and store data to the needed forms database tables are
prepared. Two essential settings for a database are:
1. Primary key: - The field that is unique for all the record occurrences.
2. Foreign key: -The field used to set relation between tables. Normalization is a technique to
avoid redundancy in the tables.
10
Relational Table:
User Transaction
Payment
f id
id
id
tool_id
cardholder_name
firstname
user_id
card_number
lastname
check_out_data
expiryDate
email
payment_id
cvv
password
Return_date
Location_date
id Admin
tool_id
id
start_time
email
end_time
password
description
11
ER DIAGRAM:
Tools
User_sign_up manage user_login
ment sy
emailid password
emaild
passwod
user_contact
password
firstname
emailid
lastname gender
12
Chapter 5
CODING
Pseudocode:
index.html:
<!DOCTYPE html>
<html lang="en">
<head>
<title>Tools management system database</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Poppins">
<link rel="stylesheet" href="style.css">
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-
q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo
" crossorigin="anonymous"></script>
<script
src="https://cdn.jsdelivr.net/npm/popper.js@1.14.7/dist/umd/popper.min.js"
integrity="sha384-
UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHN
Dz0W1" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.3.1/dist/js/bootstrap.min.js"
integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDs
f4x0xIM+B07jRM" crossorigin="anonymous"></script>
<link rel="stylesheet"
href="https://cdn.jsdelivr.net/npm/bootstrap@4.3.1/dist/css/bootstrap.min.css"
integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhc
Wr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<style>
body,h1,h2,h3,h4,h5 {font-family: "Poppins", sans-serif}
body {font-size:16px;}
.w3-half img{margin-bottom:-6px;margin-top:16px;opacity:0.8;cursor:pointer}
.w3-half img:hover{opacity:1}
</style>
</head>
<body>
13
<!-- Sidebar/menu -->
<nav class="w3-sidebar w3-red w3-collapse w3-top w3-large w3-padding"
style="z-index:3;width:300px;font-weight:bold;" id="mySidebar"><br>
<a href="javascript:void(0)" onclick="w3_close()" class="w3-button w3-hide-
large w3-display-topleft" style="width:100%;font-size:22px">Close Menu</a>
<div class="w3-container">
<h3 class="w3-padding-64"><b>TOOLS MANAGEMENT<br>SYSTEM
DATABASE</b></h3>
</div>
<div class="w3-bar-block">
<a href="signin.html" onclick="w3_close()" class="w3-bar-item w3-button w3-
hover-white">LOGIN</a>
<a href="#showcase" onclick="w3_close()" class="w3-bar-item w3-button w3-
hover-white">Showcase</a>
<a href="#services" onclick="w3_close()" class="w3-bar-item w3-button w3-
hover-white">Services</a>
<a href="#designers" onclick="w3_close()" class="w3-bar-item w3-button w3-
hover-white">Designers</a>
<a href="#contact" onclick="w3_close()" class="w3-bar-item w3-button w3-
hover-white">Contact</a>
</div>
</nav>
<!--Login-page
14
-->
<!--login-end-->
<div class="w3-half">
<img src="pexels-ricky-esquivel-4011762 (2).jpg" style="width:100%"
onclick="onClick(this)" alt="Tools management system database">
<img src="pexels-tima-miroshnichenko-8327720.jpg" style="width:100%"
onclick="onClick(this)" alt="Tools management system database">
<img src="pexels-brett-sayles-3803517.jpg" style="width:100%"
onclick="onClick(this)" alt="Tools management system database">
<img src="pexels-panumas-nikhomkhai-1148820.jpg" style="width:100%"
onclick="onClick(this)" alt="Tools management system database">
</div>
</div>
15
<!-- Services -->
<div class="w3-container" id="services" style="margin-top:75px">
<h1 class="w3-xxxlarge w3-text-red"><b>Services.</b></h1>
<hr style="width:50px;border:5px solid red" class="w3-round">
<p>Building a tools management system involves not only designing a robust
database but also implementing services or functionalities that interact with that
database to provide a comprehensive system. Here are some services or features
you might consider for a tools management system:</p>
<p><b>User Authentication and Authorization:</b><br>
Secure login and authentication mechanisms to control access to the
system.<br>
Role-based access control to determine user permissions.<br>
<br>
<b>Tool Tracking Services:</b><br>
Services for adding, updating, and deleting tool information.<br>
Search and filter functionalities for easy tool retrieval.<br>
Notification services for low-stock levels or upcoming maintenance
needs.<br>
<br>
<b>Tool Assignment Services:</b><br>
Check-in and check-out functionalities for tools.<br>
Alerts for overdue tool returns.<br>
History tracking of tool assignments.<br>
<br>
<b> Maintenance Services:</b><br>
<p>"Together, we can turn challenges into opportunities and ideas into reality.
Let's embark on this journey as a united team!"<br>
Our individual strengths make us strong, but our collaboration will make us
unstoppable. Let's work together to achieve greatness.
16
</p>
<p><b>Our designers are thoughtfully chosen</b>:</p>
</div>
<script>
// Script to open and close sidebar
function w3_open() {
document.getElementById("mySidebar").style.display = "block";
document.getElementById("myOverlay").style.display = "block";
}
function w3_close() {
document.getElementById("mySidebar").style.display = "none";
document.getElementById("myOverlay").style.display = "none";
}
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"
integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRv
H+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
<script
src="https://cdn.jsdelivr.net/npm/popper.js@1.14.7/dist/umd/popper.min.js"
integrity="sha384-
UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHN
Dz0W1" crossorigin="anonymous"></script>
<script
src="https://cdn.jsdelivr.net/npm/bootstrap@4.3.1/dist/js/bootstrap.min.js"
integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDs
f4x0xIM+B07jRM" crossorigin="anonymous"></script>
<link rel="stylesheet"
href="https://cdn.jsdelivr.net/npm/bootstrap@4.3.1/dist/css/bootstrap.min.css"
integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhc
Wr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<title>Document</title>
</head>
<body>
<h1 style="text-align: center; font-weight: 700;">SIGN IN</h1>
<section class="vh-100 showcase ">
<div class="container py-5 h-100">
<div class="row d-flex align-items-center justify-content-center h-100">
<div class="col-md-8 col-lg-7 col-xl-6">
<img src="https://mdbcdn.b-cdn.net/img/Photos/new-templates/bootstrap-
login-form/draw2.svg"
class="img-fluid" alt="Phone image">
</div>
<div class="col-md-7 col-lg-5 col-xl-5 offset-xl-1">
<form>
<!-- Email input -->
<div class="form-outline mb-4">
<input type="email" id="form1Example13" class="form-control form-
19
control-lg" />
<label class="form-label" for="form1Example13">Email
address</label>
</div>
</form>
</div>
</div>
</div>
</section>
</body>
</html>
Signup.html:
<!DOCTYPE html>
<html lang="en">
<head>
<style>
20
</style>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"
integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi
6jizo" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.14.7/dist/umd/popper.min.js"
integrity="sha384-
UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1"
crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.3.1/dist/js/bootstrap.min.js"
integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07
jRM" crossorigin="anonymous"></script>
<link rel="stylesheet"
href="https://cdn.jsdelivr.net/npm/bootstrap@4.3.1/dist/css/bootstrap.min.css"
integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRx
T2MZw1T" crossorigin="anonymous">
</head>
<body>
<section class="vh-100">
<center><h1 style="font-weight: 700; font-size: 60px;">SIGNUP</h1></center>
<div class="container py-5 h-100">
<div class="row d-flex align-items-center justify-content-center h-100">
</form>
</div>
</div>
</div>
</section>
</body>
</html>
Chapter 6
index.html:
The index.html file is like the blueprint for our Tools management system database. It's
where we organize everything so that when people visit, they can easily find what they're
looking for. It uses special codes to create different sections,. Think of it as the skeleton that
holds all the important information together. It's designed to be user-friendly, with buttons and
links guiding visitors to the important parts of the site.
Signup.html:
This signup page is designed to facilitate your registration process and grant you access
to our platform's features. To get started, kindly fill in the required information in the form
below. We value your privacy, and the details you provide will be handled securely in
accordance with our privacy policy. The registration process includes basic information such as
22
your name, email address, and a secure password. Additionally, please take a moment to review
and accept our terms and conditions. Once you've completed the form, click the "Sign Up"
button to create your account. After successful registration, you'll receive a confirmation email to
verify your account. We're excited to have you on board, and we hope you enjoy the benefits and
services our platform has to offer. If you encounter any issues during the signup process or have
questions, feel free to reach out to our support team for assistance. Thank you for choosing us,
and welcome to our growing community!.
Signin.html:
We're delighted to have you back! To access your account, please enter your registered
email address and password below. If you've forgotten your password, don't worry – simply
click on the "Forgot Password?" link, and we'll guide you through the steps to reset it. The
security of your account is of utmost importance to us, and our system employs robust
encryption to ensure the confidentiality of your login credentials. Once you've entered the
required information, click the "Sign In" button to access your account dashboard. If you
encounter any issues or have questions, our support team is readily available to assist you. Thank
you for choosing our platform, and we look forward to providing you with a seamless and secure
user experience. Welcome back!
Implementation
System Implementation:
Implementation is the realization of an application, or execution of a plan, idea, model, design,
specification, standard, algorithm, or policy. We worked so hard to implement this project. We
used system implementation and website implementation.
For implementation of a website:
1. The website can be installed on a server .
2. The owners of the website are to be properly trained to use all the features of the website.
3. To show the accuracy of the website and conformance of the owners or users.
Technologies Used:
Server: Apache (XAMPP)
23
Database: cinema
System Tools:
A project development and an implementation technology can be mapped out using a project
timeline. It is a process for defining designing, testing, and implementation of a software
application or program. Acquisition of their party tools like dependency manager, database
system all can be included for customizing the total system.
HTML
CSS
JavaScript
Bootsrap
Chapter 7
Screenshots
24
Chapter 8
CONCLUSION
In conclusion, our proposed solution, Jade Bird Program Analysis System, aims to
revolutionize the way we analyze and work with software, particularly C++ programs. By
integrating various program analysis tools into a unified toolkit, we've addressed the
inefficiencies of the existing system, where standalone tools often work in isolation and lack a
shared program information database.
Jade Bird Program Analysis System offers a more streamlined and productive approach,
providing a single source of program information for a range of software engineering tasks.
This not only saves time but also ensures consistency and accuracy across different tools. We
believe that JBPAS has the potential to significantly improve the efficiency and quality of
software development and research across multiple domains
25
26
REFERENCES
1. Tool Management System with Dynamic Life Adjustment, Published in 2020 IEEE
International Conference on Artificial Intelligence and Information Systems (ICAIIS)
Design and Implementation of Cinema Online Booking System, published in 2011
International symposium on Computer science and Society on 16-17 July 2011 by Bo
Hang
Tech
, published in IPCC 2005 . Proceedings. International Professional Communication
conference, 2005 on 10-13 July 2005 by D . Gillette
27