Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Online textile management system, Lab Reports of Database Management Systems (DBMS)

The Textile management system application is developed for managing the textile shop. Lack of immediate retrievals the information is very difficult to retrieve and to find particular information. For example to find out garment history user has to go through various registers. This results in inconvenience and wastage of time. The information generated by various transactions takes time and effort to be stored at right place. Various changes to the information like cost of garments and other i

Typology: Lab Reports

2019/2020

Uploaded on 04/11/2020

ranjith-j
ranjith-j 🇮🇳

5

(3)

1 document

1 / 21

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
ONLINE TEXTILE SHOP MANAGEMENT SYSTEM
Abstract:
The Textile management system application is developed for managing the textile shop. Lack of
immediate retrievals the information is very difficult to retrieve and to find particular
information. For example to find out garment history user has to go through various registers.
This results in inconvenience and wastage of time. The information generated by various
transactions takes time and effort to be stored at right place. Various changes to the information
like cost of garments and other information is difficult to make as paperwork is involved. Error
prone manual calculations are error prone and take a lot of time. This may result in incorrect
information. Preparation of accurate and prompt reports, this becomes a difficult job to collect
information from various registers. The Proposed approach towards working in the organization
will be planned well and organized. The data will store properly in the database which will help
in retrieval of information as well as storage. The level of accuracy in the proposed system will
be higher.
.
Existing System:
The existing system is a manual or semi automated system, i.e. The Textile Management
System is the system that can directly sent to the shop and will purchase clothes whatever you
wanted. The users are purchase dresses for festivals or by their need. They can spend time to
purchase this by their choice like color, size, and designs, rate and so on.
Proposed System:
Our Textile Management System provides a easy way to purchase the clothes through the
on line. It’s the simplest way to purchase dresses in the network.
Because the user just join with our community and can purchase a latest designs and
colors with low rates. And then provides the discount on selected clothes. It’s based on the
materials quality. It’s the easy way to shopping at your home. So you don’t need a whole day to
purchase your dress. We just deliver it to your home. The users of our sites just create your
account to shopping with us. There in our site we uploads the latest designs, lower rate materials,
whole sale clothes for men’s, women’s and for also kids. But now in the world everyone is busy.
They don’t need time to spend for this. Because of they can spend whole the day to purchase for
their whole family. But in the network, it provides a facility to purchase whatever u wanted and
deliver that to your home. So everyone likes to purchase in online shopping. It have a all
facilities like easy shopping, simple money credit methods from credit/master cards, can choose
by your choice based on the rates, all branded and designed materials available and most
important thing is door delivery.
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15

Partial preview of the text

Download Online textile management system and more Lab Reports Database Management Systems (DBMS) in PDF only on Docsity!

ONLINE TEXTILE SHOP MANAGEMENT SYSTEM

Abstract: The Textile management system application is developed for managing the textile shop. Lack of immediate retrievals the information is very difficult to retrieve and to find particular information. For example to find out garment history user has to go through various registers. This results in inconvenience and wastage of time. The information generated by various transactions takes time and effort to be stored at right place. Various changes to the information like cost of garments and other information is difficult to make as paperwork is involved. Error prone manual calculations are error prone and take a lot of time. This may result in incorrect information. Preparation of accurate and prompt reports, this becomes a difficult job to collect information from various registers. The Proposed approach towards working in the organization will be planned well and organized. The data will store properly in the database which will help in retrieval of information as well as storage. The level of accuracy in the proposed system will be higher. . Existing System: The existing system is a manual or semi automated system, i.e. The Textile Management System is the system that can directly sent to the shop and will purchase clothes whatever you wanted. The users are purchase dresses for festivals or by their need. They can spend time to purchase this by their choice like color, size, and designs, rate and so on. Proposed System: Our Textile Management System provides a easy way to purchase the clothes through the on line. It’s the simplest way to purchase dresses in the network. Because the user just join with our community and can purchase a latest designs and colors with low rates. And then provides the discount on selected clothes. It’s based on the materials quality. It’s the easy way to shopping at your home. So you don’t need a whole day to purchase your dress. We just deliver it to your home. The users of our sites just create your account to shopping with us. There in our site we uploads the latest designs, lower rate materials, whole sale clothes for men’s, women’s and for also kids. But now in the world everyone is busy. They don’t need time to spend for this. Because of they can spend whole the day to purchase for their whole family. But in the network, it provides a facility to purchase whatever u wanted and deliver that to your home. So everyone likes to purchase in online shopping. It have a all facilities like easy shopping, simple money credit methods from credit/master cards, can choose by your choice based on the rates, all branded and designed materials available and most important thing is door delivery.

PROJECT DESCRIPTION:

This system is for the automation of the Online Textile Shop Management System. It maintains two levels of user:

  • Administrator Level
  • Customer Level The Module includes:  Maintaining Customer Details.  Maintaining Garment Details.  Maintaining Item Details.  Billing and Report Generation.
  1. Customer Details: This modules contains add the new dealer details. It Includes are User id, name, date of birth, address, mobile number, e-mail id, password and so on.
  2. Garment Details: This modules contains Add the new item it includes item name, id, date, unit price, manufacturing date details maintained. And view the item details, edit the item details, delete the unwanted item details maintained. 3. Item Details: This modules contains are user purchase the item details maintained. It includes are item name, purchasing date, no of quantity, rate details and so on.
  3. Report Generation: This Module Contains two sub Modules. They are a. User Report- user can view their past purchase history and b. Admin Report- Admin can view the user history and purchase history. SYSTEM CONFIGURATION: HARDWARE CONFIGURATION:
  1. Adding customer details Request for adding Customer Recording customer details in database Customer details added successfully Admin
  2. Adding Employee details Request for adding Employee Recording Employee details in database Employee details added successfully Admin
  3. Adding Supplier details Request for adding Supplier Recording Supplier details in database Supplier details added successfully Admin
  4. Generate bill for garments Request for bill generation Supplier Generate bill Bill generated successfully Admin
  5. Generate bill for garments Request for bill generation Employee Generate bill Bill generated successfully Customer
  6. Update customer details Request for Updation Customer Updation of customer details Customer details updated successfully Admin
  7. Update Employee details Request for Updation Employee Updation of Employee details Employee details updated successfully Admin
  8. Update Supplier details Request for Updation Supplier Updation of Supplier details Supplier details updated successfully Admin
  9. Adding garments details Request for adding Recording garments details Garments details added successfully Admin
  10. Delete customer details Request for deletion Admin Deletion of Supplier details Customer details deleted successfully Admin
  11. Delete Supplier details Request for deletion Admin Deletion of Supplier details Supplier details deleted successfully Admin
  12. Delete Employee details Request for deletion Admin Deletion of Employee details Employee details deleted successfully Admin

Searching Employee Request for search Admin Search Employee details Search completed successfully Admin

details

Searching Supplier details Request for search Admin Search Supplier details Search completed successfully Admin

Searching Customer details Request for search Admin Search Customer details Search completed successfully Admin

Searching Garments details Request for search Admin Search Garments details Search completed successfully Admin USE CASE DIAGRAM , SCENARIOS AND USE CASE DESCRIPTION i. EMPLOYEE  Give information about garments.  enerate bill and give it to the customer. Employee ii. CUSTOMER  Enquire about garments.  Purchase the garments.  Request for the bill.  Pay the bill. Give information about garments Generate bill and give it to the customer Equire about garments

Admin Online Textile Management System Use Case Diagram: Maintain garment details Give order to supplier Request for bill Pay the bill Offer discounts on purchase Purchase the garments Maintain employee details

ER Diagram: ER Diagram for Online Textile Management System ACTIVITY DIAGRAM

CLASS DIAGRAM

1 1 * 1 1


1,*

(i) Sequence Diagram / Collaboration Diagram Customer -Id : C -Name : Ramya -Address : Thane -Contct No :

  • payment : cash +bill() Garments -GId: G -Type : Western -Quantity : 5 -Price : -Company : Sakhi Creations +add() +delete() Order -OrderNo : -Details :Exports of -Fabric Material -Quantity : 5 +order() Bill -BillNo : 0812 -Quantity : 5 -BillAmount : 1590 -Tax : 550 +reports() +calculation() Local User -UserName: - Soham Password : soham +login() Suppliers -SId: S -SName : Sakhi Creations -Address : Andheri(w) Ph. No: 27987989 -Garments type : Fabric material. +supply() Purchase Details -PId: P -Price: 1500 -Quantity: 5 -Payment mode : - Cash +add() +delete() +update() Admin -User_name: Amit -Password : amitp +login() Employee -Emp_id :E -Emp_name :Ram -Address :Kalwa -Age: 32 -Date of joining : - 1/3/ -Salary : +add() +delete() +update()

 Login :  Check availability of stock :

(ii) State Diagram name Product selection payment Selected product bill admin user name Shows product to customer Salary Product info admin employee name Product list Products Order Payment admin Supplier

I. SYSTEM DESIGN

1. COMPONENT DIAGRAM

System

3. Deployment Diagram User Products Staff Supplier System

4. System flow chart Bill Report Employee details analysis program Supplier details analysis program Customer details analysis program Maintain Employee Details Program Order details analysis program Maintain Supplier Details Program Maintain Customer Details Program Maintain Order Details Program Employee Order Supplier Customer Bill details analysis program Maintain Bill Details Program Bill Management

2. Customer Table Field name Datatyp e Field size Desc cust_id Number 10 Maximum 10 digits can be stored cust_fname Text 25 Maximum 25 letters can be stored cust_lname Text 25 Maximum 25 letters can be stored cust_gender Text 6 Maximum 6 letters can be stored cust_address Text 25 Maximum 25 letters can be stored cust_contact Number 10 Maximum 10 digits can be stored cust_email Text 25 Maximum 25 letters can be stored 3. Supplier Table Field name Datatyp e Field size Desc sup_id Number 10 Maximum 10 digits can be stored sup _fname Text 25 Maximum 25 letters can be stored sup _lname Text 25 Maximum 25 letters can be stored sup _gender Text 6 Maximum 6 letters can be stored sup _address Text 25 Maximum 25 letters can be stored sup_pincode Number 8 Maximum 8digits can be stored sup_company Text 25 Maximum 25 letters can be stored sup_contact Number 10 Maximum 10 digits can be stored sup_email Text 25 Maximum 25 letters can be stored 4. Products Table

Field name Datatyp e Field size Desc prod_id Number 10 Maximum 10 digits can be stored prod_size Text 5 Maximum 5 letters can be stored prod_quantity Number 2 Maximum 2 digits can be stored prod_rate Number 6 Maximum 6 digits can be stored prod_avail Text 25 Maximum 25 letters can be stored prod_type Text 8 Maximum 8 letters can be stored prod_descriptio n Text 25 Maximum 25 letters can be stored prod_brand Text 10 Maximum 10 letters can be stored prod_shades Text 25 Maximum 25 letters can be stored

5. Bill Table Field name Datatyp e Field size Desc bill_no Number 10 Maximum 10 digits can be stored bill_date Text 5 Maximum 5 letters can be stored cname Text 2 Maximum 2 letters can be stored ccontact Text 6 Maximum 6 letters can be stored cemail Text 25 Maximum 25 letters can be stored desc1 Number 10 Maximum 10 digits can be stored desc2 Number 10 Maximum 10 digits can be stored desc2 Number 10 Maximum 10 digits can be stored price1 Number 5 Maximum 5 digits can be stored price2 Number 5 Maximum 5 digits can be stored price2 Number 5 Maximum 5 digits can be stored qty1 Number 2 Maximum 2 digits can be stored