DBMS PROJECT REPORT
SUPPLY CHAIN
MANAGEMENT SYSTEM
Indian Institute of Information
Technology Allahabad
Semester IV,
B.Tech(IT)
SECTION-C
Group members:-
GROUP-20
IIT2019193 CHETAN PATIDAR
IIT2019206 AAMIN
CHOUDHARY IIB2019031
DEBASHISH DAS
INTRODUCTION
“SUPPLY CHAIN MANAGEMENT SYSTEM” is the management of
a network of interconnected businesses involved in the ultimate provision of product and
service packages required by end customers. It spans all movement and storage of raw
materials, work-in-process inventory, and finished goods from point-of-origin to
point-of-consumption. It is mainly designed for the production sector, which gives
information related to client and dealers of the company with respect to product
launches.
SYSTEM REQUIREMENTS AND TECHNOLOGY USED
❖ Operating System: Any
❖ Xampp control panel
❖ HTML / CSS
❖ JAVASCRIPT
❖ MySQL
❖ PHP
SIGNIFICANCE OF TECHNOLOGIES USED
HTML : Provides structure to the page
CSS: Beautify the page layout by adding
styles JAVASCRIPT : To add functions in
the code
MySQL : Language used to insert, update data in
database.They store data and provide facilities (tools) to
search for specific records in a given set of data.
PHP:a very good backend language for making dynamic websites
SETTING UP PROJECT
Make sure that all the system requirements are available.
In “xampp” folder open “htdocs” and paste the project folder
having the source code there.
Open “local host/phpmyadmin” server in your
pc . Create a database named “scms”.
If you have any other database then change the details in file
“config.php” Import the mysql database file “scm_new.sql” in
the database “scms”
Now start the proje ct on host server as local host.
Credentials for admin : username:: admin
Password :: admin123
MODULES
This application is divided into following modules:
● Admin
● manufacturer
● retailer
Module
Description
Admin
Admin maintains manufacturer and retailer details.admin can-
■ 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
Admin Username: admin
Admin Password: admin123
Manufacturer
Manufacturer is the head of our easy foods factory he can
■ Manage Products
■ View Retailers
■ View Distributors
■ Manage Unit of Measure
■ Manage Categories
■ Manage Orders
■ Create Invoice
■ Print Invoice
■ Manage Profile
■
Retailer
Retailer can-
■ View Products
■ Manage Orders
■ View Invoice
■ Print Invoice
■ Manage Profile
USE CASES
Use cases used for our project
Register - admin can create account for manufacturers and retailers.
Only the admin is allowed to register the employees.
Login - Admin,manufacturer and retailer can login into the system.
Logout - Admin,manufacturer and retailer can logout
from the system.
ADMIN
Add retailer- admin can add retailer and or update his details
Add manufacturer- admin can add manufacturer and or update his
details
Manage unit - manage unit for transaction
Change Password- admin can change his password
Manage Orders -admin can edit orders
Print Invoice- print final invoice for the products
MANUFACTURER
Manage Products
View Reetailers
View Distributors
Manage Unit of
Measure Manage
Orders
Print Invoice
RETAILER
View
Products
Manage
Orders View
Invoice
Print Invoice
NORMALIZATION TECHNIQUES USED
1. In the database we store the details of the
manufacturer(manufacturer table) as well as the retailer
(retailer table) and all the products(product table).
2. Every field has only one value in each row.
3. Each username as well as email that is entered at the
time of sign of manufacturer and developer is
unique .
4. As the Email, username and phoneNumber are the non prime
attributes, they
shouldn’t determine each other for the table to be in its 3rd normal form.
5. So, to achieve this objective we’ve created a function through
which only unique usernames are allowed. This way our table will
be in 3rd normal form
. 6. Also, there shouldn’t be partial dependency in the email and phone
number.
7. To make sure that there are no partial dependencies we’ve
created a function in which if there’s an existing email then it won’t
have the same phone number with it.
ER-DIAGRAM
ADVANTAGES
The product designed is the web-based system, mainly for production
sector, which gives information related to the clients and dealers of
the company with respect to its product launches. This product
develops a system that can be used by the company management to
keep track of the sales, dealers and its clients. It spans all movement
and storage of raw materials, work-in-process inventory, and finished
goods from point-of-origin to point-of-consumption.
CONCLUSION
Ø This project has more scope in future and it can be integrated
further
Ø This project is successfully implemented with all the features
mentioned earlier.
Ø This project is designed keeping in view the needs of the
common user and satisfying the user upto the maximum extent
possible.
Ø Deployment of our application will help the user to reduce the
unnecessary wastage of time in going and ordering the product
manually.
Ø Therefore we are successfully able to reach the goals and target
of the project.
