Supply chain management system 2021-22

CHAPTER 1

INTRODUCTION

1.1 Database

A database is an organized collection of data. A relation database, more restrictively, is a

collection of schemas, tables, queries, report, views, and other elements. Database designers
typically organize the data to model aspects of reality in a way that supports processes
requiring information, such as modelling the availability of rooms in hotels in a way that
supports finding a hotel with vacancies.

A database is not generally portable across different DBMS, but different DBMSs can
interoperate by using standards such as SQL and JDBC to allow a single application to work
with more than one DBMS. Computer scientists may classify database management system
according to the data base models that they support; the most popular database systems since
the 1980s have all supported the relational model- generally associated with the SQL
language. HB sometimes a DBMS is loosely referred to as a “database”.

1.2 Database Management System

A database-management system (DBMS) is a collection of interrelated data and a set of

programs to access those data. This is a collection of related data with an implicit meaning
and hence is a database. The collection of data, usually referred to as the database, contains
information relevant to an enterprise. The primary goal of a DBMS is to provide a way to
store and retrieve database information that is both convenient and efficient. By data, we
mean known facts that can be recorded and that have implicit meaning. For example,
consider the names, phone numbers, addresses, age of the person you know. You may have
recorded this data in an indexed address book, or you may have stored it on a diskette, using a
personal computer and software such as DBASE Ⅳ or Ⅴ, Microsoft ACCESS, or EXCEL.
While information can be transported, stored or shared without many difficulties the same
cannot be said about knowledge.

Database system are designed to manage large bodies of information management of data
involves both defining structures for storage of information and providing mechanisms for
the manipulation of information. In addition, the database system must ensure the safety of
the information stored, despite system crashes or attempts at unauthorized access. If data are
to be shared among several users, the system must avoid possible anomalous results.
Dept. Of CSE, BGSIT Page 1
Supply chain management system 2021-22

Figure:1.2 Database Management System

1.3 Application

Database are widely used some of the representative applications are:

1. Banking: For Customer Information, Accounts and Loans and Banking Transactions.
2. Universities: For Student Registration and Grades.
3. Online Shopping: Everyone Wants to Shop from Home. Everyone New Products Are
Added and Sold Only with The Help Of DBMS. Purchase Information, Invoice Bills
and Payment, all of these Are Done with The Help Of DBMS.
4. Airlines: For Reservation and Schedule Information.
5. Credit Card Transactions: For Purchases on Credit Cards and Generation of
Monthly Statements.
6. Library Management System: Maintain All the Information Related to The Book
Issue Dates, Name of The Book, Author and Availability of The Book.
7. Telecommunication: For Keeping Records of Call Made, Generating Monthly Bills,
Maintaining Balances on Prepaid Calling Cards.
8. Sales: For Customer, Products and Purchase Information.

Dept. Of CSE, BGSIT Page 2

Supply chain management system 2021-22

9. Finance: For Storing Information About Holdings, Sales, And Purchases of Financial
Instruments Such as Stocks and Bonds.
1.4 Introduction to MySQL

MySQL Is a Relational Database Management System (RDBMS)That Runs as A Server

Providing Multi-User Access to A Number of Databases. MySQL Is a Popular Choice of a
Database for Use in the Web Applications and Is an Open-Source Product. The Process of the
Setting Up a MySQL Database Varies from Host to Host, However We Will End Up with a
Database Name, A User Name and a Password. Before Using Our Database, We Must Create
a Table. A Table Is a Section of The Database for Storing Related Information. In A Table,
We Will Set Up Different Fields Which Will Be Used in that Table. Creating a Table. In
PhpMyAdmin Is Simple, We Just Type the Name, Select the Number of Fields and Click on
the ‘go’ Button. We Will Then Be Taken to a Setup Screen Where You Must Create the
Fields for The Database. Another Way of Creating Database and Tables in PhpMyAdmin Is
by Executing Simple SQL Statements. We Have This Method in Order to Create Our
Database and Tables. RDBMS is the basis for SQL, and for all modern database systems such
as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

The most comprehensive set of advanced features, management tools and technical support to
achieve the highest levels of MySQL scalability, security, reliability, and uptime. Over 2000
ISVs, OEMs, and VARs rely on MySQL as their products' embedded database to make their
applications, hardware and appliances more competitive, bring them to market faster, and
lower their cost of goods sold. SQL is used to communicate with the database. According to
ANSI (American National Standard Institute), it is the standard language for relational
database management systems. SQL statements are used to perform tasks such as update data
on a database, or retrieve data from a database. It is also used by business professionals or
program developers for administering, updating, maintaining and manipulating the databases
are tables that used for business decision-maki

1.5 XAMPP

XAMPP is an abbreviation for cross-platform, Apache, MySQL, PHP and Perl, and itallows
you to build WordPress site offline, on a local web server on your computer. This simple and
lightweight solution works on Windows, Linux, and Mac - hence the "cross-platform" part.
Since WordPress isn't a stand-aloneapplication, XAMPP provides twoessential components

Dept. Of CSE, BGSIT Page 3

Supply chain management system 2021-22

for its installation - Apache, which i the local server, and MySQLwhich you can use as a
database for your website. used to create

1.6 Introduction to Project

Supply chain management (SCM) is the management of a network of interconnected
businesses involved in the ultimate provision of product and service packages required by
end customers. Supply Chain Management spans all movement and storage of raw materials,
work-in-process inventory, and finished goods from point of origin to point of consumption
(supply chain).

Customer: The customer starts the chain of events when they decide to purchase a product
that has been offered for sale by a company. The customer contacts the sales department of
the company, which enters the sales order for a specific quantity to be delivered on a specific
date. If the product has to be manufactured, the sales order will include a requirement that
needs to be fulfilled by the production facility.

Planning: The requirement triggered by the customer's sales order will be combined with
other orders. The planning department will create a production plan to produce the products
to fulfill the customer's orders. To manufacture the products the company will then have to
purchase the raw materials needed.

Purchasing: The purchasing department receives a list of raw materials and services required
by the production department to complete the customer's orders. The purchasing department
sends purchase orders to selected suppliers to deliver the necessary raw materials to the
manufacturing site on the required date.

Inventory: The raw materials are received from the suppliers, checked for quality and
accuracy and moved into the warehouse. The supplier will then send an invoice to the
company for the items they delivered. The raw materials are stored until they are required by
the production department.

Production: Based on a production plan, the raw materials are moved inventory to the
production area. The finished products ordered by the customer are manufactured using the
raw materials purchased from suppliers. After the items have been completed and tested, they
are stored back in the warehouse prior to delivery to the customer.

Dept. Of CSE, BGSIT Page 4

Supply chain management system 2021-22

Transportation: When the finished product arrives in the warehouse, the shipping
department determines the most efficient method to ship the products so that they are
delivered on or before the date specified by the customer. When the goods are received by the
customer, the company will send an invoice for the delivered products.

Dept. Of CSE, BGSIT Page 5

Supply chain management system 2021-22

CHAPTER 2
LITERATURE SURVEY
The research was focused on recent articles that present studies related to practices on Supply
Chain Management and Supply Chain Maturity, aiming understand which practices are
helping companies to achieve better performance and maturity, and which areas have been
developed in the process. Supply Chain Management Practices Supply chains integrate
several areas and so several actors with divergent interests. The main challenge is conciliating
all the expectations and provide the appropriated level of service and quality for the
customers. Koh et al (2007) states that SCM’s practices involve a set of activities undertaken
by organization to promote effective management of their supply chain. Tutuncu and
Kucukusta (2008) go beyond that and states that SCM lead to changes in the structure of the
organization by integrating internal functions and linking these with the external operation of
suppliers, customers and others stakeholders of the supply chain. The study presents that
there is an extensive range of practices to be explored. Since the practices about forecasting,
inventory, collaboration, development of warehouses, hub, site factories and besides that
there is not recent research treating all those dimensions of management. Talib et al (2011)
worked on a project to link the TQM – Total Quality Management practices to SCM practices
as showed by Table 1. A set of 12 practices applicable to different organization were identify
above 50 TQM practices and 90 SCM practices. Authors indicate that implementation of
these TQM and SCM practices in the organization will result in many desirable outcomes and
benefits such as customer satisfaction; JIT delivery and reduced cycle time.

Dept. Of CSE, BGSIT Page 6

Supply chain management system 2021-22

CHAPTER 3

PROBLEM STATEMENT

Supply chain is the most crucial part in any business organizations. A hole in the supply
chain networks will affect the whole chain in the supply network. The causes of supply chain
activities to failed are due to the lack of understanding or knowledge on the nature of
demand.

Supply chains have become more multifarious than before thus the ruthlessness and
occurrence of supply chain disruptions seems to be increasing. These scenarios could be
worst to firms which does not achieve responsiveness in relation to its supply chain
strategies. For example, the manufacturers of PC such as Compaq used to fail because they
failed in responding quickly (Qrunfleh &Tarafdar, 2013).

Existing System

In the existing system the exams are done only manually but in proposed system we have to
computerize the exams using this application.

 Lack of security of data.

 More man power.
 Time consuming.
 Consumes large volume of pare work.
 Needs manual calculations.
 No direct role for the higher officials

Proposed System

The aim of proposed system is to develop a system of improved facilities. The proposed
system can overcome all the limitations of the existing system. The system provides proper
security and reduces the manual work.

 Security of data.
 Ensure data accuracy.
 Proper control of the higher officials.
 Minimize manual data entry.

Dept. Of CSE, BGSIT Page 7

Supply chain management system 2021-22

 Minimum time needed for the various processing.

 Greater efficiency.
 Better service.
 User friendliness and interactive.
 Minimum time required.

ADVANTAGES

Here’s listing the main advantages of supply chain management:

1. Higher Efficiency: When a company’s supply chain operations which include the resource
procurement, logistics, and delivery are strategically planned and executed, businesses can
predict demand more accurately as well as cater to them. This enhances the efficiency of a
company to adjust to disruptions, ever-evolving markets and fluctuating industry trends.

Supply chain leaders who invest in making real-time data available and have supply chain
processes automated can avoid unnecessary delays in manufacturing and shipping. Since they
have backup plans in case of resource procurement or inventory issues, they can better
respond to challenges, which then helps improve customer experience.

2. Customer Retention and Experience: An effective supply chain management helps

companies establish a strong reputation in the market. It increases a system’s effectiveness to
respond to customer demands. This doesn’t just attract new consumers but also influences
their loyalty to a brand. Businesses that prioritize customer service invest in effective supply
chain management to ensure a seamless flow of goods and services.

3. Better Risk Assessment and Management: Agile management in the supply chain allows
companies to respond to disruptions efficiently. It is important to deploy predictive analysis
tools for risk assessment. Responsible supply chain management also results in proactive
action with respect to quality control. Businesses that do so are not just able to predict risks
but also have corrective solutions in place to dodge or cover the losses they might incur from
disruptions.

4. Improved Relationships: Supply chain management involves fostering profitable

relationships with suppliers and distributors. Strengthening collaborations with vendors

Dept. Of CSE, BGSIT Page 8

Supply chain management system 2021-22

through effective communication and cooperation helps enhance productivity and cut down
costs.

5. Cost-Effectiveness: Supply chain management includes inventory management, which

when effectively planned and executed can help cut down costs. To maximize the outcome of
internal inventory, supply chain management has inventory management software which
allows managers to benefit from an on-demand or lean inventory model.

6. Qualitative Improvements: Responsible supply chain management directly impacts the

quality of a company’s products and services which are produced keeping global CSR
standards and guidelines in mind. This compliance contributes to sustainability and customer
gratification.

7. Reduces Legal Liabilities: Effective supply chain management helps companies avoid
negative publicity and legal liabilities that result from violations of global CSR standards.

8. Reduces Delays: An important advantage of supply chain management is that effective

dialogue and coordination result in reduced inconsistencies in distribution, logistical errors
and delays in production and shipment.

9. Uninterrupted Cash Flow: One of the main benefits of supply chain management is that it
contributes to data-driven decision-making and profitable partnerships. There are also tools
and technologies in place to conduct predictive analysis of potential risks to respond to
changes and disruptions better.

10. Benefits of Technologies: The role of digital technologies in enhancing the functionality
of supply chain management is unmissable. From efficiency, performance and risk
management to quality and customer experience, technology plays an important role in
streamlining every aspect of the supply chain.

BENEFITS

Here are the top benefits of Supply chain management:

Greater Efficiency: Supply chain incorporates product innovation strategies, integrated

logistics, production tactics and forecasting demand. This will put you in a great position to
predict demand and also make moves accordingly.

Dept. Of CSE, BGSIT Page 9

Supply chain management system 2021-22

Decreased Costs: One of the main benefits of supply chain management is its ability to
decrease costs by improving inventories, adapt according to customer requirements, stabilizing
relationships with distributors and vendors.

Collaboration: Another underlying benefit of the supply chain is that it adds up to wonderful
coordination of all the business entities in delivering the final product to your end customers.
When there is a lack of communication between your vendors or distributors, you have no idea
what is really going on. However, when you open the doors and embrace supply chain
systems, you can gain access to greater communication with forecasts, reporting, quotation
and statuses in real time.

Increased Output: When your business is able to collaborate better, streamline the whole
production and distribution process, this directly translates to the company’s bottom line and
improves the overall output. As a result, your business can enjoy greater profits and stay ahead
of the competition.

No more Delays: You can meet customer expectations and deliver the product to the customer
in a timely fashion. Since everyone knows what to do at a given time, this will remove the
bottlenecks on production lines, logistical errors in distribution channels and late shipments
from suppliers. Altogether there will be no delay in getting the product to the consumers
without any damage.

Response to Conflicts: Unfortunately, businesses today have to face a lot of challenges in the
market. There are a number of aspects that can lead to production or logistical problems. A
supplier might go out of business or a distributor can give you problems. In either case, supply
chain management systems can help you cope with these problems at either side of the
spectrum.

Dept. Of CSE, BGSIT Page 10

Supply chain management system 2021-22

CHAPTER 4
REQUIRMENTS SPECIFICATION
Hardware Requirements

The Physical Components Required Are:

• Processor-Intel Pentium Processor At 500 MHz Or Faster.

• Memory- 256MB RAM or More.

• Wi-Fi Card OR Ethernet Card.

• Mouses Or Others Pointing Device.

• Keyboard

• Hard-Disk Drive/Optical Driver.

Software requirements

The softer being used are:

• Operating system (ex: windows 10)

• Xampp server

• Subline text editor

• Internet browser (ex: chrome).

REQUIREMENTS

Front end

Introduction to PHP: Hypertext Pre-processor is a widely used, general purpose scripting

language that was originally designed for web development for web development to produce
dynamic web pages. For this purpose, PHP code is embedded into the HTML source
document and interpreted by a web server with a PHP processor model, which generates the
web page document

Back end

Introduction to MYSQL server: MYSQL is a relational database management system. A

relational database store s data in separate tables rather than putting all the data in one big

Dept. Of CSE, BGSIT Page 11

Supply chain management system 2021-22

storeroom. This adds speed and flexibility. The SQL is part of MYSQL stand for “structured
query language”.

Case tool

Introduction to rational rose

This is a brief overview to get students started in using rational rose to quickly
create object-oriented models and diagrams. it is not by any means a complete
introduction to rational rose, but it should get you started.

 Getting started
 Use case diagram

Dept. Of CSE, BGSIT Page 12

Supply chain management system 2021-22

CHAPTER 5
IMPLEMENTATION
5.1 MODULES

 Admin
 Login
 Manufacturer
 Retailer
 Feedback

Admin Side

 Manage Products
 Manage Retailers
 Manage Manufacturer
 Manage Distributors
 Manage Unit of Measure
 Manage Categories
 Manage Areas
 Change Password
 Manage Orders
 Create Invoice
 Print Invoice
 Manage Profile

Manufacturer Side

 Manage Products
 View Retailers
 View Distributors
 Manage Unit of Measure
 Manage Categories
 Manage Orders
 Create Invoice
 Print Invoice

Dept. Of CSE, BGSIT Page 13

Supply chain management system 2021-22

 Manage Profile

Retailer Side

 View Products
 Manage Orders
 View Invoice
 Print Invoice
 Manage Profile

CODE OF ADMIN
?php
include("../includes/config.php");
session_start();
if(isset($_SESSION['admin_login'])) {
if($_SESSION['admin_login'] == true) {
//select last 5 retialers
$query_selectRetailer = "SELECT * FROM retailer,area WHERE
retailer.area_id=area.area_id ORDER BY retailer_id DESC LIMIT 5";
$result_selectRetailer = mysqli_query($con,$query_selectRetailer);
//select last 5 manufacturers
$query_selectManufacturer = "SELECT * FROM manufacturer
ORDER BY man_id DESC LIMIT 5";
$result_selectManufacturer =
mysqli_query($con,$query_selectManufacturer);
//select last 5 products
$query_selectProducts = "SELECT * FROM products,categories,unit
WHERE products.pro_cat=categories.cat_id AND products.unit=unit.id ORDER BY pro_id
DESC LIMIT 5";
$result_selectProducts = mysqli_query($con,$query_selectProducts);
}
else {
header('Location:../index.php');
}
}
else {
header('Location:../index.php');
}
?>
<!DOCTYPE html>
<html>
<head>
<title> Admin: Home </title>

Dept. Of CSE, BGSIT Page 14

Supply chain management system 2021-22

<link rel="stylesheet" href="../includes/main_style.css" >

</head>
<body>
<?php
include("../includes/header.inc.php");
include("../includes/nav_admin.inc.php");
include("../includes/aside_admin.inc.php");
?>
<section>
<h1>Welcome Admin</h1>
<article>
<h2>Recently Added Retialers</h2>
<table class="table_displayData">
<tr>
<th>Sr. No.</th>
<th>Username</th>
<th>Area Code</th>
<th>Phone</th>
<th>Email</th>
<th>Address</th>
</tr>
<?php $i=1; while($row_selectRetailer =
mysqli_fetch_array($result_selectRetailer)) { ?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $row_selectRetailer['username'];
?></td>
<td><?php echo $row_selectRetailer['area_code'];
?></td>
<td><?php echo $row_selectRetailer['phone']; ?></td>
<td><?php echo $row_selectRetailer['email']; ?></td>
<td><?php echo $row_selectRetailer['address']; ?></td>
</tr>
<?php $i++; } ?>
</table>
</article>

<article>
<h2>Recently Added Manufacturers</h2>
<table class="table_displayData">
<tr>
<th>Sr. No.</th>
<th>Name</th>
<th>Email</th>
<th>Phone</th>
<th>Username</th>

Dept. Of CSE, BGSIT Page 15

Supply chain management system 2021-22

</tr>
<?php $i=1; while($row_selectManufacturer =
mysqli_fetch_array($result_selectManufacturer)) { ?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $row_selectManufacturer['man_name'];
?></td>
<td><?php echo $row_selectManufacturer['man_email'];
?></td>
<td><?php echo $row_selectManufacturer['man_phone'];
?></td>
<td><?php echo $row_selectManufacturer['username'];
?></td>
</tr>
<?php $i++; } ?>
</table>
</article>

<article>
<h2>Recently Added Products</h2>
<table class="table_displayData">
<tr>
<th> Code </th>
<th> Name </th>
<th> Price </th>
<th> Unit </th>
<th> Category </th>
<th> Quantity </th>
</tr>
<?php $i=1; while($row_selectProducts =
mysqli_fetch_array($result_selectProducts)) { ?>
<tr>
<td><?php echo $row_selectProducts['pro_id']; ?></td>
<td><?php echo $row_selectProducts['pro_name']; ?></td>
<td><?php echo $row_selectProducts['pro_price']; ?></td>
<td><?php echo $row_selectProducts['unit_name']; ?></td>
<td><?php echo $row_selectProducts['cat_name']; ?></td>
<td><?php if($row_selectProducts['quantity'] == NULL){ echo
"N/A";} else {echo $row_selectProducts['quantity'];} ?></td>
</tr>
<?php $i++; } ?>
</table>
</article>
</section>
<?php
include("../includes/footer.inc.php");

Dept. Of CSE, BGSIT Page 16

Supply chain management system 2021-22

?>
</body>
</html>

CODE OF LOGIN
<DOCTYPE html>
<html>
<head>!
<title> Login </title>
<link rel="stylesheet" href="includes/main_style.css" >
</head>
<body class="login-box">
<h1>LOGIN</h1>
<form action="" method="POST" class="login-form">
<ul class="form-list">
<li>
<div class="label-block"><label
for="login:username">Username</label></div>
<div class="input-box"><input type="text" id="login:username"
name="txtUsername" placeholder="Username" /></div>
</li>
<li>
<div class="label-block"><label
for="login:password">Password</label></div>
<div class="input-box"><input type="password" id="login:password"
name="txtPassword" placeholder="Password" /></div>
</li>
<li>
<div class="label-block"><label for="login:type">Login Type</label></div>
<div class="input-box">
<select name="login_type" id="login:type">
<option value="" disabled selected>-- Select Type --</option>
<option value="retailer">Retailer</option>
<option value="manufacturer">Manufacturer</option>
<option value="admin">Admin</option>
</select>
</div>
</li>
<li>
<input type="submit" value="Login" class="submit_button" /><span
class="error_message"><?php echo $loginErr; echo $reqErr; ?></span>
</li>
</ul>
</form>
</body>
</html>

Dept. Of CSE, BGSIT Page 17

Supply chain management system 2021-22

ER Diagram

Figure 5.1 ER Diagram

Dept. Of CSE, BGSIT Page 18

Supply chain management system 2021-22

Figure 5.2 Schema diagram

Dept. Of CSE, BGSIT Page 19

Supply chain management system 2021-22

CHAPTER 6
SNAPSHOTS

Figure 6.1 Login Page

Figure 6.2 Admin Page

Dept. Of CSE, BGSIT Page 20

Supply chain management system 2021-22

Page

Figure 6.3 Add Manufacturer Page

Figure 6.4 Add Retailer Page

Dept. Of CSE, BGSIT Page 21

Supply chain management system 2021-22

Figure 6.5 Add Distributor Page

Figure 6.6 View Units Page

Dept. Of CSE, BGSIT Page 22

Supply chain management system 2021-22

Figure 6.7 View Category Page

Figure 6.8 View Area Page

Dept. Of CSE, BGSIT Page 23

Supply chain management system 2021-22

Figure 6.9 Edit Profile Page

Figure 6.10 View Retailer Page

Dept. Of CSE, BGSIT Page 24

Supply chain management system 2021-22

Figure 6.11 View Manufacturer Page

Figure 6.12 View Distributor Page

Dept. Of CSE, BGSIT Page 25

Supply chain management system 2021-22

Figure 6.13 View Products Page

Figure 6.14 Order Page

Dept. Of CSE, BGSIT Page 26

Supply chain management system 2021-22

Figure 6.15 Invoices Page

Dept. Of CSE, BGSIT Page 27

Supply chain management system 2021-22

CONCLUTION AND FUTURE ENHANCEMENT

CONCLUSION
 Comparing to existing manual system, it performs at a faster pace.
 System gives better feedback.
 Timely and accurate information are available.
 The system provides greater processing speed consistency.
 Chances of errors are much low.
 Provides high security the system and hence unauthorized user can be prevented
 Time taken for overall process is reduced.
 Forms are very user friendly.
 Ease of operation.
FUTURE ENHANCEMENT

1. The feedback will be sent to candidates through their emails.

2. We are trying to do the project at best level to satisfy all the end user requirements.
3. In our future we are decided to provide more security to our website which may not
be hacked.

Dept. Of CSE, BGSIT Page 28

Supply chain management system 2021-22

REFRENSES
[1] Database Management System by Prof. Date, A Kannan, S Swaminathan
[2] Database Management System by Prof. S Nanda Gopalan
[3] www.djangodocumentation.com
[4] www.python.org/
[5] www.Bootstrap.com en.wikipedia.org/wiki/Django

Dept. Of CSE, BGSIT Page 29