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

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. 4. 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: details 14. Searching Supplier details Request for search Admin Search Supplier details Search completed successfully Admin 15. Searching Customer details Request for search Admin Search Customer details Search completed successfully Admin 16. 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 Customer iii. SUPPLIER  Give details about the garments.  Accept the order.  Offer discounts on purchase.  Generate bill and give it. Supplier iv. ADMIN  Maintaing employee details.  Maintaing Garments details.  Give order to the supplier.  Request for the bill.  Pay the bill.  Offer discounts on purchase.  Purchase the garments. Purchase the garments Request for the bill Payment of Bill Accept the order Offer discounts on purchase Generate bill and give it Give details 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 CLASS DIAGRAM 1 1 * 1 1 * * * 1,* * * * (i) Sequence Diagram / Collaboration Diagram Customer -Id : C001 -Name : Ramya -Address : Thane -Contct No :233345 - payment : cash +bill() Garments -GId: G008 -Type : Western -Quantity : 5 -Price :4000 -Company : Sakhi Creations +add() +delete() Order -OrderNo :101 -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: S001 -SName : Sakhi Creations -Address : Andheri(w) Ph. No: 27987989 -Garments type : Fabric material. +supply() Purchase Details -PId: P001 -Price: 1500 -Quantity: 5 -Payment mode : - Cash +add() +delete() +update() Admin -User_name: Amit -Password : amitp +login() Employee -Emp_id :E001 -Emp_name :Ram -Address :Kalwa -Age: 32 -Date of joining : - 1/3/2005 -Salary :5800 +add() +delete() +update() Admin Security System User Operations System T T T T | | | I I 1 | 1 | 2 1 I i | loginO) ! ' } verify userQ, r user verified add userO Successfully added <<$_— $$ Delete user() : Successfully deleted | | 1 1 1 1 | 1 I 1 Check availability of stock : User Garments Garments stock I T I 1 | | 1 I ! Do check() Get garments () ! I 1 ! ! Garments availability () 1 | 1 | Garments () Update stock) | | 1 | ' Bill generation : Customer Employee Gives Bill to) Admin Supplier ‘+ Maintaining Details Collect 0) Details System | | | | | | | — Generate confirmation messages() | | | | | 2. Package Diagram Online Textile Management System Admin Supplier Customer Employee Bill Products Name Password Supplier id Supplier name Supplier contactno Supplier address customer id customer name customer contactno customer address Emp id Emp name Emp contactno Emp address Bill no Cust id Prod rateProd desc prod id Prod type Prod rateProd desc 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 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 qty2 Number 2 Maximum 2 digits can be stored qty2 Number 2 Maximum 2 digits can be stored tot_items Number 2 Maximum 2 digits can be stored tot_amt Number 6 Maximum 6 digits can be stored discount Number 2 Maximum 2 digits can be stored pay_mode Text 10 Maximum 10 letters can be stored net_amt Number 6 Maximum 6 digits can be stored CONCLUSION: The current system is designed for a Online Textile Management System further can be expanded to more than one cloth shop by centralization thereby making records of various branches available at central path .The system developed may have the chance for adding some more features in the future. The following can be some of the features that can be introduced in the system later on:  More information can be added to the database by making use of new tables and the information for those tables.  The system developed has the possibility of making online purchasing of goods and also payment of bill through online by mentioning the credit card details.  The system can be made to auto-collect the information through the specified websites, once it is converted to an online system.  Generation of reports can be made on monthly basis without the updating made manually every time at the end of each month.  More menus can be added to the main menu tree of the system such as the one to generate salary reports, monthly profit & loss reports, etc.