Bca Project Report - 054579669 4m5t3l
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 3i3n4
Overview 26281t
& View Bca Project Report - 054579669 as PDF for free.
More details 6y5l6z
- Words: 3,755
- Pages: 43
FURNITURE SHOP MANAGEMENT SYSTEM Project Report
September 2009
SCHOOL OF COMPUTER AND INFORMATION SCIENCES INDIRA GANDHI NATIONAL OPEN UNIVERSITY MAIDAN GARHI, NEW DELHI – 110 068
File Name BCA Project Report Enrolment 054579669 number
Furniture Shop management system
2009
TABLE OF CONTENTS
1. Introduction..........................................................3 2. OBJECTIVES..........................................................3 2.1 REQUIREMENTS.................................................................................................................................3
3. Tools and Environment Used................................4 4. DETAILS OF THE PROJECT.....................................4 4.1 Functional Hierarchy.............................................................................................................................5 4.2 Module Details.......................................................................................................................................5 4.3 INPUT/OUTPUT/PROCESSING LOGIC............................................................................................9 4.4 Data Flow diagram [DFD]...................................................................................................................11 4.5 ER diagram..........................................................................................................................................14 4.6 Screen Shots.........................................................................................................................................15 4.7 Data base Details..................................................................................................................................30
5. 6. 7. 8.
LIMITATIONS.......................................................42 SCOPE OF THE FUTURE APPLICATION.................43 Bibliography.......................................................43 Glossary..............................................................43
Enrolment No: 054579669
BCA-IGNOU
2 of 43
Furniture Shop management system
1.
2009
INTRODUCTION
This project is about furniture retail shop management
system. This project is aimed at developing the system for the furniture shop owners who can “efficiently” manage the business. This project is aimed at providing the required information from the available data for the shop owners to make the informed decisions and utilize the constrained resources in the best possible ways. 2.
OBJECTIVES
The objective of the project is to develop the system which is required for managing the retail furniture outlet effectively. The business requirement is described in the following section: 2.1
REQUIREMENTS
The requirements of retail furniture outlet management system are: 1)
To have the facility to track the total inventory in the shop. This acquires utmost importance since the “inventory” in the shop should neither be too low or too high. It should be managed at “optimum” level. The system should assist in this direction to maintain the “right/optimum” level of inventory. This information assists in effective “supply chain management”.
2)
To have the facility to track the purchase order and GRN [Goods Received Notes]
3)
To track the repair details of the furniture. The repair could take place either in or outside warranty period. This information will assist the shop owner to keep track of nature and number of such defects and take suitable actions for the future.
4)
To have the facility of customer order management system. This information helps to capture the repeat customers and valuable customer which will aid in arriving at discount for the furniture sale.
Enrolment No: 054579669
BCA-IGNOU
3 of 43
Furniture Shop management system
3.
2009
TOOLS AND ENVIRONMENT USED
FRONT END / GUI Tools
Visual Basic 6.0
RDBMS/BACK END
SQL Server 2005
APPLICATION BUSINESS LOGIC OPERATING SYSTEMS APPLICATIONS
Visual Basic 6.0 WINDOWS XP/VISTA, WINDOWS NT RETAIL MANAGEMENT SYSTEM
Considering the facts that 1)
This system is meant for retail outlets which are not part of any chain and exists as independent shops
2) No need to access the details across geographical locations 3) Number of s will be less This particular architecture has been chosen. Web based architecture would be ideally suited for retail outlet which are part of larger chain of stores and there is a need to centralize the data base and provide the system across geographical locations. This will also remove the dependency of application installation at all the places. This particular architecture requires installation of the application in each s computer. 4.
DETAILS OF THE PROJECT
The proposed design for the project is described in the following sections 1) Functional hierarchy 2) Module details 3) Input /Output/Processing logic 4) Data Flow Diagram [DFD] 5) ER Diagram 6) Screen Shots 7) Data base design
Enrolment No: 054579669
BCA-IGNOU
4 of 43
Furniture Shop management system
4.1
2009
Functional Hierarchy
Figure 1 The details of each of the module are explained in the subsequent sections. 4.2
Module Details
This section provides the details of the each of the module Module Name: Static Data Management Module Description: As in any standard application, this system requires set of static data for the transaction processing. The transaction could be purchase of furniture from supplier or customer purchasing the furniture from the
Enrolment No: 054579669
BCA-IGNOU
5 of 43
Furniture Shop management system
2009
shop. Customer Master: This is for the maintenance of the customer information. The details include name, address, telephone number and email id. This customer information is captured for multi purposes A) To get in touch with customer in case there is a need for communication with customer related to the orders or repair details B) Profitability analysis customer wise: This is made possible since customer id is captured along with order information. C) For using the frequent purchaser information for the purpose of providing special discounts. Add, Modify and delete operations are possible for the customer records. Product Type Master This is for the maintenance of various product types. For example: Cot, Sofa would fall into this category. Add, Modify and delete operations are possible for the product type master. Though it is very unlikely that deletion of product type will be required. Product Master This is for the maintenance of various product code for the given product type. This module helps to capture various categories of a particular product type. Add, Modify and delete operations are possible for the product master. Employee Master This is for the maintenance of the employees working in the furniture retail outlet. This will also gets translated as the s of the system.
Enrolment No: 054579669
BCA-IGNOU
6 of 43
Furniture Shop management system
2009
Currently this module design has been kept very simple. The “role” of the or employee is not captured which can be used for “permission” handling. Add, Modify and delete operations are possible on the employee data. The delete operation has been provided to take care of employees leaving the shop.
Module Name: Furniture Purchase management Module Description: This module will enable the of the system to handle the purchases of the furniture from the supplier. The with the help of the stock report can determine whether there is sufficient stock of the furniture in the shop. If there is any need, then 1) In case the supplier is new one, add the supplier details to the system. This is to update the supplier master which can be used for further communications. 2)
Based on the preferred suppliers, type of furniture available with them, place the “purchase order” with the supplier for the required type of product and quantity.
3)
Once the goods are delivered by the supplier, GRN to be generated. This would capture received quantity.
4) to the GRN with the purchase order and release the payment accordingly. In future, this module can be enhanced for handling payment related activities.
Enrolment No: 054579669
BCA-IGNOU
7 of 43
Furniture Shop management system
2009
Module Name: Customer Order management Module Description: This will be the most used module of the system. This assists the of the system to take care of the “sale” of the furniture in the business. 1)
Prospects can be provided with required details of the product and prices as a part of the customer enquiry.
2)
If the prospect decides on purchase and if the details of the prospect is not available then details of the prospects like name, address and details are captured in customer management.
3) When customer selects set of product [ranging from 1 or more], order module to be used to capture the order details like product Id and quantity. 4)
Once the order is confirmed, “invoice” is generated and which is presented to the for required payment. This invoice will have the details of product Id, quantity, price and total amount.
5)
Once the payment is made, delivery challan is produced from the system which can be used to track the delivery of the required furniture either at outlet or home delivery. The data from customer master data comes handy here.
Module Name: Repair module Module Description: This module assists the to track the furniture which comes to the outlet for the repair. It may be possible that few furniture may have some warranty period and some kind of damages can be covered within the warranty period. This module provides both the option of handling repair within and outside the warranty period.
Enrolment No: 054579669
BCA-IGNOU
8 of 43
Furniture Shop management system
2009
The details of product Id, quantity and customer details are captured here.
Module Name: Reports Module Module Description: As in any other information management system, reports forms the heart of the system. All the master data and transaction details are captured in SQL Server database. With this any direct and derived data is just one SQL away. Just as a sample, stock report is provided. With the help of table details furnished, one can customize or develop any new reports. The formatting for the report can be carried either using SQL itself or using tools like Crystal Reports
4.3
INPUT/OUTPUT/PROCESSING LOGIC
This section captures the input, output and processing logic details for few selected modules. 4.3.1 Module:
Enrolment No: 054579669
BCA-IGNOU
9 of 43
Furniture Shop management system
INPUT: id and
2009
PROCESSING LOGIC: Check if id and is correct. If validation is successful then access to the system is allowed
OUTPUT: Access to Main Menu
4.3.2 Customer Master Maintenance (Under Static Data Module)
INPUT: Customer Name Customer Address Number Email Id
PROCESSING LOGIC: Check if all the mandatory fields are filled Check if customer record already exists or not.
OUTPUT: New customer record is created
Enrolment No: 054579669
BCA-IGNOU
10 of 43
Furniture Shop management system
2009
4.3.3 Customer Order Placing
INPUT: Customer Name Order Date Product Name Product Code Order Quantity VAT %
PROCESSING LOGIC: Check if the stock is available Populate the price corresponding to the product name and quantity Calculate the total settlement Amount
OUTPUT: Create the customer order record with unique Order number.
4.4 Data Flow diagram [DFD] This section provides level 0 and level 1 DFD.
Enrolment No: 054579669
BCA-IGNOU
11 of 43
Furniture Shop management system
2009
Level 0 DFD
Enrolment No: 054579669
BCA-IGNOU
12 of 43
Furniture Shop management system
2009
Level 1 DFD
Enrolment No: 054579669
BCA-IGNOU
13 of 43
Furniture Shop management system
2009
4.5 ER diagram
Enrolment No: 054579669
BCA-IGNOU
14 of 43
Furniture Shop management system
2009
4.6 Screen Shots 4.6.1 SQL Server 2005 – tables used in the project
Enrolment No: 054579669
BCA-IGNOU
15 of 43
Furniture Shop management system
2009
4.6.2 SQL Server configuration Manager
Enrolment No: 054579669
BCA-IGNOU
16 of 43
Furniture Shop management system
2009
4.6.3 Visual Basic Project Explorer screen shot
4.6.4 Screen
4.6.5 Start up screen
Enrolment No: 054579669
BCA-IGNOU
17 of 43
Furniture Shop management system
Enrolment No: 054579669
2009
BCA-IGNOU
18 of 43
Furniture Shop management system
2009
4.6.6 Main screens from where operations will be carried out
4.6.7 Menu details
4.6.8 Sales Menu
4.6.9 Repair menu
Enrolment No: 054579669
BCA-IGNOU
19 of 43
Furniture Shop management system
2009
4.6.10Purchase Menu
4.6.11Master setup menu
4.6.12Reports menu
Enrolment No: 054579669
BCA-IGNOU
20 of 43
Furniture Shop management system
4.6.13
2009
Orders form
Enrolment No: 054579669
BCA-IGNOU
21 of 43
Furniture Shop management system
2009
4.6.14Delivery Challan
Enrolment No: 054579669
BCA-IGNOU
22 of 43
Furniture Shop management system
4.6.15
2009
Tax Invoice
Enrolment No: 054579669
BCA-IGNOU
23 of 43
Furniture Shop management system
4.6.16
2009
Repair with Warranty
Enrolment No: 054579669
BCA-IGNOU
24 of 43
Furniture Shop management system
4.6.17
2009
Repair without Warranty
Enrolment No: 054579669
BCA-IGNOU
25 of 43
Furniture Shop management system
4.6.18
2009
Purchase Order
Enrolment No: 054579669
BCA-IGNOU
26 of 43
Furniture Shop management system
4.6.19
2009
Goods Received Notes
Enrolment No: 054579669
BCA-IGNOU
27 of 43
Furniture Shop management system
4.6.20
Product Type Master
4.6.21
Product Master
Enrolment No: 054579669
2009
BCA-IGNOU
28 of 43
Furniture Shop management system
Enrolment No: 054579669
2009
BCA-IGNOU
29 of 43
Furniture Shop management system
4.6.22
2009
Employee Master
4.7 Data base Details The following section provides the details of the each of the tables used in the project. 4.7.1 Furniture data base creation details USE [master] GO /****** Object: Database [Furniture] Script Date: 09/29/2009 05:57:53 ******/ CREATE DATABASE [Furniture] ON PRIMARY
Enrolment No: 054579669
BCA-IGNOU
30 of 43
Furniture Shop management system
2009
( NAME = N'Furniture', FILENAME = N'D:\NNP\BCA\FMS\FMS\Data\Furniture.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'Furniture_log', FILENAME = N'D:\NNP\BCA\FMS\FMS\Data\Furniture_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) COLLATE SQL_Latin1_General_1_CI_AS GO EXEC dbo.sp_dbcmptlevel @dbname=N'Furniture', @new_cmptlevel=90 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [Furniture].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [Furniture] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [Furniture] SET ANSI_NULLS OFF GO ALTER DATABASE [Furniture] SET ANSI_PADDING OFF GO ALTER DATABASE [Furniture] SET ANSI_WARNINGS OFF GO ALTER DATABASE [Furniture] SET ARITHABORT OFF GO ALTER DATABASE [Furniture] SET AUTO_CLOSE OFF GO ALTER DATABASE [Furniture] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [Furniture] SET AUTO_SHRINK OFF GO ALTER DATABASE [Furniture] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [Furniture] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [Furniture] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [Furniture] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [Furniture] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [Furniture] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [Furniture] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [Furniture] SET ENABLE_BROKER GO ALTER DATABASE [Furniture] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [Furniture] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [Furniture] SET TRUSTWORTHY OFF GO ALTER DATABASE [Furniture] SET ALLOW_SNAPSHOT_ISOLATION OFF
Enrolment No: 054579669
BCA-IGNOU
31 of 43
Furniture Shop management system
2009
GO ALTER DATABASE [Furniture] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [Furniture] SET READ_WRITE GO ALTER DATABASE [Furniture] SET RECOVERY SIMPLE GO ALTER DATABASE [Furniture] SET MULTI_ GO ALTER DATABASE [Furniture] SET PAGE_ CHECKSUM GO ALTER DATABASE [Furniture] SET DB_CHAINING OFF 4.7.2 Customer
USE [Furniture] GO /****** Object: Table [dbo].[Customers] Script Date: 09/29/2009 05:58:26 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Customers]( [Cust_ID] [int] IDENTITY(1,1) NOT NULL, [CustomerName] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Address1] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Address2] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [City] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [State] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [PINCode] [int] NULL, [No] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [EmailId] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] 4.7.3 DC Items
USE [Furniture] GO
Enrolment No: 054579669
BCA-IGNOU
32 of 43
Furniture Shop management system
2009
/****** Object: Table [dbo].[DC_Items] Script Date: 09/29/2009 05:59:01 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DC_Items]( [ItemsID] [int] IDENTITY(1,1) NOT NULL, [DCNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [ItemQty] [int] NULL, [ItemPrice] [int] NULL, [Amount] [int] NULL ) ON [PRIMARY] 4.7.4 DC Master
USE [Furniture] GO /****** Object: Table [dbo].[DC_Master] Script Date: 09/29/2009 05:59:36 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DC_Master]( [DCNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [DCDate] [datetime] NULL, [Customer] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [DeliveredBy] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [SubTotal] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxPercent] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxAmount] [money] NULL, [GrandTotal] [money] NULL, [Remarks] [ntext] COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
Enrolment No: 054579669
BCA-IGNOU
33 of 43
Furniture Shop management system
2009
4.7.5 GRN Items
USE [Furniture] GO /****** Object: Table [dbo].[GRN_Items] Script Date: 09/29/2009 06:00:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[GRN_Items]( [ItemsID] [int] IDENTITY(1,1) NOT NULL, [GRNNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [OrderQty] [int] NULL, [RecQty] [int] NULL ) ON [PRIMARY] 4.7.6 GRN Master
USE [Furniture] GO /****** Object: Table [dbo].[GRN_Master] Script Date: 09/29/2009 06:01:06 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[GRN_Master]( [GRNNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [GRNDate] [datetime] NULL, [PONo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Supplier] [nvarchar](100) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Remarks] [ntext] COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
Enrolment No: 054579669
BCA-IGNOU
34 of 43
Furniture Shop management system
2009
4.7.7 Invoice Items
USE [Furniture] GO /****** Object: Table [dbo].[Invoice_Items] 09/29/2009 06:01:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Invoice_Items]( [ItemsID] [int] IDENTITY(1,1) NOT NULL, [InvoiceNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [ItemQty] [int] NULL, [ItemPrice] [int] NULL, [Amount] [int] NULL ) ON [PRIMARY]
Script Date:
4.7.8 Invoice Master
USE [Furniture] GO /****** Object: Table [dbo].[Invoice_Master] 09/29/2009 06:01:57 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Invoice_Master]( [InvoiceNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [InvoiceDate] [datetime] NULL, [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Customer] [nvarchar](100) COLLATE SQL_Latin1_General_1_CI_AS NULL,
Enrolment No: 054579669
BCA-IGNOU
Script Date:
35 of 43
Furniture Shop management system
2009
[SubTotal] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxPercent] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxAmount] [money] NULL, [GrandTotal] [money] NULL, [Remarks] [ntext] COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] 4.7.9 No Warranty Items
USE [Furniture] GO /****** Object: Table [dbo].[NoWarrenty_Items] 09/29/2009 06:03:31 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[NoWarrenty_Items]( [ItemsID] [int] IDENTITY(1,1) NOT NULL, [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [ItemQty] [int] NULL, [ItemPrice] [int] NULL, [Amount] [int] NULL ) ON [PRIMARY]
Script Date:
4.7.10No Warranty Repairs
USE [Furniture] GO /****** Object: Table [dbo].[NoWarrantyRepairs] 09/29/2009 06:02:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[NoWarrantyRepairs]( [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL,
Enrolment No: 054579669
BCA-IGNOU
Script Date:
36 of 43
Furniture Shop management system
2009
[OrderDate] [datetime] NULL, [InvoiceNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Customer] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [SubTotal] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxPercent] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxAmount] [money] NULL, [GrandTotal] [money] NULL, [Remarks] [ntext] COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
4.7.11Order Items
USE [Furniture] GO /****** Object: Table [dbo].[Order_Items] Script Date: 09/29/2009 06:03:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Order_Items]( [ItemsID] [int] IDENTITY(1,1) NOT NULL, [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [ItemQty] [int] NULL, [ItemPrice] [int] NULL, [Amount] [int] NULL ) ON [PRIMARY] 4.7.12Orders
USE [Furniture] GO /****** Object: Table [dbo].[Orders] 06:04:12 ******/
Enrolment No: 054579669
Script Date: 09/29/2009
BCA-IGNOU
37 of 43
Furniture Shop management system
2009
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Orders]( [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [OrderDate] [datetime] NULL, [Customer] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [SalesPerson] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [SubTotal] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxPercent] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxAmount] [money] NULL, [GrandTotal] [money] NULL, [Remarks] [ntext] COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] 4.7.13PO Items
USE [Furniture] GO /****** Object: Table [dbo].[PO_Items] Script Date: 09/29/2009 06:04:31 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PO_Items]( [ItemsID] [int] IDENTITY(1,1) NOT NULL, [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [ItemQty] [int] NULL, [ItemPrice] [int] NULL, [Amount] [int] NULL ) ON [PRIMARY]
Enrolment No: 054579669
BCA-IGNOU
38 of 43
Furniture Shop management system
2009
4.7.14PO Master
USE [Furniture] GO /****** Object: Table [dbo].[PO_Master] Script Date: 09/29/2009 06:04:52 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PO_Master]( [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [OrderDate] [datetime] NULL, [Supplier] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [SubTotal] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxPercent] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxAmount] [money] NULL, [GrandTotal] [money] NULL, [Remarks] [ntext] COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
4.7.15Product Master
USE [Furniture] GO /****** Object: Table [dbo].[Product_Master] 09/29/2009 06:05:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Product_Master]( [ProductID] [int] IDENTITY(1,1) NOT NULL, [Product_Name] [nvarchar](150) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product_Code] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL,
Enrolment No: 054579669
BCA-IGNOU
Script Date:
39 of 43
Furniture Shop management system
2009
[ProductType] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Material] [nvarchar](100) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Price] [money] NULL, [Stock] [int] NULL ) ON [PRIMARY] 4.7.16Product Type Master
USE [Furniture] GO /****** Object: Table [dbo].[Product_TypeMaster] Script Date: 09/29/2009 06:05:36 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Product_TypeMaster]( [ProductTypeID] [int] IDENTITY(1,1) NOT NULL, [Furniture_TypeName] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] 4.7.17Repair Order Master
USE [Furniture] GO /****** Object: Table [dbo].[RepairOrder_Master] 09/29/2009 06:06:02 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[RepairOrder_Master]( [RepairOderID] [int] IDENTITY(1,1) NOT NULL ) ON [PRIMARY]
Script Date:
4.7.18Supplier Master Table
USE [Furniture]
Enrolment No: 054579669
BCA-IGNOU
40 of 43
Furniture Shop management system
2009
GO /****** Object: Table [dbo].[Supplier_Master] Script Date: 09/29/2009 06:06:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Supplier_Master]( [Supplier_ID] [int] IDENTITY(1,1) NOT NULL, [SupplierName] [nvarchar](255) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Address1] [nvarchar](255) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Address2] [nvarchar](255) COLLATE SQL_Latin1_General_1_CI_AS NULL, [City] [nvarchar](200) COLLATE SQL_Latin1_General_1_CI_AS NULL, [State] [nvarchar](100) COLLATE SQL_Latin1_General_1_CI_AS NULL, [PINcode] [int] NULL, [No] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [EMail] [nvarchar](100) COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] 4.7.19Warranty Items
USE [Furniture] GO /****** Object: Table [dbo].[Warrenty_Items] 09/29/2009 06:07:18 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Warrenty_Items]( [ItemsID] [int] IDENTITY(1,1) NOT NULL, [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [ItemQty] [int] NULL,
Enrolment No: 054579669
BCA-IGNOU
Script Date:
41 of 43
Furniture Shop management system
2009
[ItemPrice] [int] NULL, [Amount] [int] NULL ) ON [PRIMARY]
4.7.20Warranty Repairs
USE [Furniture] GO /****** Object: Table [dbo].[WarrantyRepairs] Script Date: 09/29/2009 06:06:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[WarrantyRepairs]( [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [OrderDate] [datetime] NULL, [InvoiceNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Customer] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [SubTotal] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxPercent] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxAmount] [money] NULL, [GrandTotal] [money] NULL, [Remarks] [ntext] COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
5.
LIMITATIONS 1) There is no different profile of the s maintained in the system. 2) Permission system is not available. 3) What if analysis reports
Enrolment No: 054579669
BCA-IGNOU
42 of 43
Furniture Shop management system
6.
2009
SCOPE OF THE FUTURE APPLICATION 1) To create the profile for the s like , General etc. 2) To create the permission system which restricts or allow the specific operation as per the profiles 3) Customer profitability reports 4) Report on “The average number of days taken for the repair” 5)
Report on “Identification of regular customer” which will help in providing discount on the sales
6) Cost management system 7.
8.
BIBLIOGRAPHY 1)
http://en.wikipedia.org/wiki/Data_flow_diagram
2)
http://msdn.microsoft.com/en-us/sqlserver/default.aspx
GLOSSARY GRN: In business, goods received note [GRN] is generated whenever a delivery is made to the business. The GRN details what goods and quantities have been received and when. A copy of the GRN is sent to the s department to enable them to match it to the purchase order [That would have been raised when the goods were originally ordered from the supplier] When the invoice is received, this is matched to the purchase order and GRN. Only if the details on all the three match up, is the invoice paid. Invoice: An invoice or bill is a commercial document issued by seller to the buyer indicating the products, quantities and agreed prices for products or services the caller has provided to the buyer. An invoice indicates the buyer must pay the seller, according to the payment .
Enrolment No: 054579669
BCA-IGNOU
43 of 43
September 2009
SCHOOL OF COMPUTER AND INFORMATION SCIENCES INDIRA GANDHI NATIONAL OPEN UNIVERSITY MAIDAN GARHI, NEW DELHI – 110 068
File Name BCA Project Report Enrolment 054579669 number
Furniture Shop management system
2009
TABLE OF CONTENTS
1. Introduction..........................................................3 2. OBJECTIVES..........................................................3 2.1 REQUIREMENTS.................................................................................................................................3
3. Tools and Environment Used................................4 4. DETAILS OF THE PROJECT.....................................4 4.1 Functional Hierarchy.............................................................................................................................5 4.2 Module Details.......................................................................................................................................5 4.3 INPUT/OUTPUT/PROCESSING LOGIC............................................................................................9 4.4 Data Flow diagram [DFD]...................................................................................................................11 4.5 ER diagram..........................................................................................................................................14 4.6 Screen Shots.........................................................................................................................................15 4.7 Data base Details..................................................................................................................................30
5. 6. 7. 8.
LIMITATIONS.......................................................42 SCOPE OF THE FUTURE APPLICATION.................43 Bibliography.......................................................43 Glossary..............................................................43
Enrolment No: 054579669
BCA-IGNOU
2 of 43
Furniture Shop management system
1.
2009
INTRODUCTION
This project is about furniture retail shop management
system. This project is aimed at developing the system for the furniture shop owners who can “efficiently” manage the business. This project is aimed at providing the required information from the available data for the shop owners to make the informed decisions and utilize the constrained resources in the best possible ways. 2.
OBJECTIVES
The objective of the project is to develop the system which is required for managing the retail furniture outlet effectively. The business requirement is described in the following section: 2.1
REQUIREMENTS
The requirements of retail furniture outlet management system are: 1)
To have the facility to track the total inventory in the shop. This acquires utmost importance since the “inventory” in the shop should neither be too low or too high. It should be managed at “optimum” level. The system should assist in this direction to maintain the “right/optimum” level of inventory. This information assists in effective “supply chain management”.
2)
To have the facility to track the purchase order and GRN [Goods Received Notes]
3)
To track the repair details of the furniture. The repair could take place either in or outside warranty period. This information will assist the shop owner to keep track of nature and number of such defects and take suitable actions for the future.
4)
To have the facility of customer order management system. This information helps to capture the repeat customers and valuable customer which will aid in arriving at discount for the furniture sale.
Enrolment No: 054579669
BCA-IGNOU
3 of 43
Furniture Shop management system
3.
2009
TOOLS AND ENVIRONMENT USED
FRONT END / GUI Tools
Visual Basic 6.0
RDBMS/BACK END
SQL Server 2005
APPLICATION BUSINESS LOGIC OPERATING SYSTEMS APPLICATIONS
Visual Basic 6.0 WINDOWS XP/VISTA, WINDOWS NT RETAIL MANAGEMENT SYSTEM
Considering the facts that 1)
This system is meant for retail outlets which are not part of any chain and exists as independent shops
2) No need to access the details across geographical locations 3) Number of s will be less This particular architecture has been chosen. Web based architecture would be ideally suited for retail outlet which are part of larger chain of stores and there is a need to centralize the data base and provide the system across geographical locations. This will also remove the dependency of application installation at all the places. This particular architecture requires installation of the application in each s computer. 4.
DETAILS OF THE PROJECT
The proposed design for the project is described in the following sections 1) Functional hierarchy 2) Module details 3) Input /Output/Processing logic 4) Data Flow Diagram [DFD] 5) ER Diagram 6) Screen Shots 7) Data base design
Enrolment No: 054579669
BCA-IGNOU
4 of 43
Furniture Shop management system
4.1
2009
Functional Hierarchy
Figure 1 The details of each of the module are explained in the subsequent sections. 4.2
Module Details
This section provides the details of the each of the module Module Name: Static Data Management Module Description: As in any standard application, this system requires set of static data for the transaction processing. The transaction could be purchase of furniture from supplier or customer purchasing the furniture from the
Enrolment No: 054579669
BCA-IGNOU
5 of 43
Furniture Shop management system
2009
shop. Customer Master: This is for the maintenance of the customer information. The details include name, address, telephone number and email id. This customer information is captured for multi purposes A) To get in touch with customer in case there is a need for communication with customer related to the orders or repair details B) Profitability analysis customer wise: This is made possible since customer id is captured along with order information. C) For using the frequent purchaser information for the purpose of providing special discounts. Add, Modify and delete operations are possible for the customer records. Product Type Master This is for the maintenance of various product types. For example: Cot, Sofa would fall into this category. Add, Modify and delete operations are possible for the product type master. Though it is very unlikely that deletion of product type will be required. Product Master This is for the maintenance of various product code for the given product type. This module helps to capture various categories of a particular product type. Add, Modify and delete operations are possible for the product master. Employee Master This is for the maintenance of the employees working in the furniture retail outlet. This will also gets translated as the s of the system.
Enrolment No: 054579669
BCA-IGNOU
6 of 43
Furniture Shop management system
2009
Currently this module design has been kept very simple. The “role” of the or employee is not captured which can be used for “permission” handling. Add, Modify and delete operations are possible on the employee data. The delete operation has been provided to take care of employees leaving the shop.
Module Name: Furniture Purchase management Module Description: This module will enable the of the system to handle the purchases of the furniture from the supplier. The with the help of the stock report can determine whether there is sufficient stock of the furniture in the shop. If there is any need, then 1) In case the supplier is new one, add the supplier details to the system. This is to update the supplier master which can be used for further communications. 2)
Based on the preferred suppliers, type of furniture available with them, place the “purchase order” with the supplier for the required type of product and quantity.
3)
Once the goods are delivered by the supplier, GRN to be generated. This would capture received quantity.
4) to the GRN with the purchase order and release the payment accordingly. In future, this module can be enhanced for handling payment related activities.
Enrolment No: 054579669
BCA-IGNOU
7 of 43
Furniture Shop management system
2009
Module Name: Customer Order management Module Description: This will be the most used module of the system. This assists the of the system to take care of the “sale” of the furniture in the business. 1)
Prospects can be provided with required details of the product and prices as a part of the customer enquiry.
2)
If the prospect decides on purchase and if the details of the prospect is not available then details of the prospects like name, address and details are captured in customer management.
3) When customer selects set of product [ranging from 1 or more], order module to be used to capture the order details like product Id and quantity. 4)
Once the order is confirmed, “invoice” is generated and which is presented to the for required payment. This invoice will have the details of product Id, quantity, price and total amount.
5)
Once the payment is made, delivery challan is produced from the system which can be used to track the delivery of the required furniture either at outlet or home delivery. The data from customer master data comes handy here.
Module Name: Repair module Module Description: This module assists the to track the furniture which comes to the outlet for the repair. It may be possible that few furniture may have some warranty period and some kind of damages can be covered within the warranty period. This module provides both the option of handling repair within and outside the warranty period.
Enrolment No: 054579669
BCA-IGNOU
8 of 43
Furniture Shop management system
2009
The details of product Id, quantity and customer details are captured here.
Module Name: Reports Module Module Description: As in any other information management system, reports forms the heart of the system. All the master data and transaction details are captured in SQL Server database. With this any direct and derived data is just one SQL away. Just as a sample, stock report is provided. With the help of table details furnished, one can customize or develop any new reports. The formatting for the report can be carried either using SQL itself or using tools like Crystal Reports
4.3
INPUT/OUTPUT/PROCESSING LOGIC
This section captures the input, output and processing logic details for few selected modules. 4.3.1 Module:
Enrolment No: 054579669
BCA-IGNOU
9 of 43
Furniture Shop management system
INPUT: id and
2009
PROCESSING LOGIC: Check if id and is correct. If validation is successful then access to the system is allowed
OUTPUT: Access to Main Menu
4.3.2 Customer Master Maintenance (Under Static Data Module)
INPUT: Customer Name Customer Address Number Email Id
PROCESSING LOGIC: Check if all the mandatory fields are filled Check if customer record already exists or not.
OUTPUT: New customer record is created
Enrolment No: 054579669
BCA-IGNOU
10 of 43
Furniture Shop management system
2009
4.3.3 Customer Order Placing
INPUT: Customer Name Order Date Product Name Product Code Order Quantity VAT %
PROCESSING LOGIC: Check if the stock is available Populate the price corresponding to the product name and quantity Calculate the total settlement Amount
OUTPUT: Create the customer order record with unique Order number.
4.4 Data Flow diagram [DFD] This section provides level 0 and level 1 DFD.
Enrolment No: 054579669
BCA-IGNOU
11 of 43
Furniture Shop management system
2009
Level 0 DFD
Enrolment No: 054579669
BCA-IGNOU
12 of 43
Furniture Shop management system
2009
Level 1 DFD
Enrolment No: 054579669
BCA-IGNOU
13 of 43
Furniture Shop management system
2009
4.5 ER diagram
Enrolment No: 054579669
BCA-IGNOU
14 of 43
Furniture Shop management system
2009
4.6 Screen Shots 4.6.1 SQL Server 2005 – tables used in the project
Enrolment No: 054579669
BCA-IGNOU
15 of 43
Furniture Shop management system
2009
4.6.2 SQL Server configuration Manager
Enrolment No: 054579669
BCA-IGNOU
16 of 43
Furniture Shop management system
2009
4.6.3 Visual Basic Project Explorer screen shot
4.6.4 Screen
4.6.5 Start up screen
Enrolment No: 054579669
BCA-IGNOU
17 of 43
Furniture Shop management system
Enrolment No: 054579669
2009
BCA-IGNOU
18 of 43
Furniture Shop management system
2009
4.6.6 Main screens from where operations will be carried out
4.6.7 Menu details
4.6.8 Sales Menu
4.6.9 Repair menu
Enrolment No: 054579669
BCA-IGNOU
19 of 43
Furniture Shop management system
2009
4.6.10Purchase Menu
4.6.11Master setup menu
4.6.12Reports menu
Enrolment No: 054579669
BCA-IGNOU
20 of 43
Furniture Shop management system
4.6.13
2009
Orders form
Enrolment No: 054579669
BCA-IGNOU
21 of 43
Furniture Shop management system
2009
4.6.14Delivery Challan
Enrolment No: 054579669
BCA-IGNOU
22 of 43
Furniture Shop management system
4.6.15
2009
Tax Invoice
Enrolment No: 054579669
BCA-IGNOU
23 of 43
Furniture Shop management system
4.6.16
2009
Repair with Warranty
Enrolment No: 054579669
BCA-IGNOU
24 of 43
Furniture Shop management system
4.6.17
2009
Repair without Warranty
Enrolment No: 054579669
BCA-IGNOU
25 of 43
Furniture Shop management system
4.6.18
2009
Purchase Order
Enrolment No: 054579669
BCA-IGNOU
26 of 43
Furniture Shop management system
4.6.19
2009
Goods Received Notes
Enrolment No: 054579669
BCA-IGNOU
27 of 43
Furniture Shop management system
4.6.20
Product Type Master
4.6.21
Product Master
Enrolment No: 054579669
2009
BCA-IGNOU
28 of 43
Furniture Shop management system
Enrolment No: 054579669
2009
BCA-IGNOU
29 of 43
Furniture Shop management system
4.6.22
2009
Employee Master
4.7 Data base Details The following section provides the details of the each of the tables used in the project. 4.7.1 Furniture data base creation details USE [master] GO /****** Object: Database [Furniture] Script Date: 09/29/2009 05:57:53 ******/ CREATE DATABASE [Furniture] ON PRIMARY
Enrolment No: 054579669
BCA-IGNOU
30 of 43
Furniture Shop management system
2009
( NAME = N'Furniture', FILENAME = N'D:\NNP\BCA\FMS\FMS\Data\Furniture.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'Furniture_log', FILENAME = N'D:\NNP\BCA\FMS\FMS\Data\Furniture_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) COLLATE SQL_Latin1_General_1_CI_AS GO EXEC dbo.sp_dbcmptlevel @dbname=N'Furniture', @new_cmptlevel=90 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [Furniture].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [Furniture] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [Furniture] SET ANSI_NULLS OFF GO ALTER DATABASE [Furniture] SET ANSI_PADDING OFF GO ALTER DATABASE [Furniture] SET ANSI_WARNINGS OFF GO ALTER DATABASE [Furniture] SET ARITHABORT OFF GO ALTER DATABASE [Furniture] SET AUTO_CLOSE OFF GO ALTER DATABASE [Furniture] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [Furniture] SET AUTO_SHRINK OFF GO ALTER DATABASE [Furniture] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [Furniture] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [Furniture] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [Furniture] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [Furniture] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [Furniture] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [Furniture] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [Furniture] SET ENABLE_BROKER GO ALTER DATABASE [Furniture] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [Furniture] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [Furniture] SET TRUSTWORTHY OFF GO ALTER DATABASE [Furniture] SET ALLOW_SNAPSHOT_ISOLATION OFF
Enrolment No: 054579669
BCA-IGNOU
31 of 43
Furniture Shop management system
2009
GO ALTER DATABASE [Furniture] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [Furniture] SET READ_WRITE GO ALTER DATABASE [Furniture] SET RECOVERY SIMPLE GO ALTER DATABASE [Furniture] SET MULTI_ GO ALTER DATABASE [Furniture] SET PAGE_ CHECKSUM GO ALTER DATABASE [Furniture] SET DB_CHAINING OFF 4.7.2 Customer
USE [Furniture] GO /****** Object: Table [dbo].[Customers] Script Date: 09/29/2009 05:58:26 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Customers]( [Cust_ID] [int] IDENTITY(1,1) NOT NULL, [CustomerName] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Address1] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Address2] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [City] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [State] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [PINCode] [int] NULL, [No] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [EmailId] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] 4.7.3 DC Items
USE [Furniture] GO
Enrolment No: 054579669
BCA-IGNOU
32 of 43
Furniture Shop management system
2009
/****** Object: Table [dbo].[DC_Items] Script Date: 09/29/2009 05:59:01 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DC_Items]( [ItemsID] [int] IDENTITY(1,1) NOT NULL, [DCNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [ItemQty] [int] NULL, [ItemPrice] [int] NULL, [Amount] [int] NULL ) ON [PRIMARY] 4.7.4 DC Master
USE [Furniture] GO /****** Object: Table [dbo].[DC_Master] Script Date: 09/29/2009 05:59:36 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DC_Master]( [DCNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [DCDate] [datetime] NULL, [Customer] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [DeliveredBy] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [SubTotal] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxPercent] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxAmount] [money] NULL, [GrandTotal] [money] NULL, [Remarks] [ntext] COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
Enrolment No: 054579669
BCA-IGNOU
33 of 43
Furniture Shop management system
2009
4.7.5 GRN Items
USE [Furniture] GO /****** Object: Table [dbo].[GRN_Items] Script Date: 09/29/2009 06:00:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[GRN_Items]( [ItemsID] [int] IDENTITY(1,1) NOT NULL, [GRNNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [OrderQty] [int] NULL, [RecQty] [int] NULL ) ON [PRIMARY] 4.7.6 GRN Master
USE [Furniture] GO /****** Object: Table [dbo].[GRN_Master] Script Date: 09/29/2009 06:01:06 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[GRN_Master]( [GRNNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [GRNDate] [datetime] NULL, [PONo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Supplier] [nvarchar](100) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Remarks] [ntext] COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
Enrolment No: 054579669
BCA-IGNOU
34 of 43
Furniture Shop management system
2009
4.7.7 Invoice Items
USE [Furniture] GO /****** Object: Table [dbo].[Invoice_Items] 09/29/2009 06:01:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Invoice_Items]( [ItemsID] [int] IDENTITY(1,1) NOT NULL, [InvoiceNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [ItemQty] [int] NULL, [ItemPrice] [int] NULL, [Amount] [int] NULL ) ON [PRIMARY]
Script Date:
4.7.8 Invoice Master
USE [Furniture] GO /****** Object: Table [dbo].[Invoice_Master] 09/29/2009 06:01:57 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Invoice_Master]( [InvoiceNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [InvoiceDate] [datetime] NULL, [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Customer] [nvarchar](100) COLLATE SQL_Latin1_General_1_CI_AS NULL,
Enrolment No: 054579669
BCA-IGNOU
Script Date:
35 of 43
Furniture Shop management system
2009
[SubTotal] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxPercent] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxAmount] [money] NULL, [GrandTotal] [money] NULL, [Remarks] [ntext] COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] 4.7.9 No Warranty Items
USE [Furniture] GO /****** Object: Table [dbo].[NoWarrenty_Items] 09/29/2009 06:03:31 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[NoWarrenty_Items]( [ItemsID] [int] IDENTITY(1,1) NOT NULL, [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [ItemQty] [int] NULL, [ItemPrice] [int] NULL, [Amount] [int] NULL ) ON [PRIMARY]
Script Date:
4.7.10No Warranty Repairs
USE [Furniture] GO /****** Object: Table [dbo].[NoWarrantyRepairs] 09/29/2009 06:02:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[NoWarrantyRepairs]( [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL,
Enrolment No: 054579669
BCA-IGNOU
Script Date:
36 of 43
Furniture Shop management system
2009
[OrderDate] [datetime] NULL, [InvoiceNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Customer] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [SubTotal] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxPercent] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxAmount] [money] NULL, [GrandTotal] [money] NULL, [Remarks] [ntext] COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
4.7.11Order Items
USE [Furniture] GO /****** Object: Table [dbo].[Order_Items] Script Date: 09/29/2009 06:03:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Order_Items]( [ItemsID] [int] IDENTITY(1,1) NOT NULL, [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [ItemQty] [int] NULL, [ItemPrice] [int] NULL, [Amount] [int] NULL ) ON [PRIMARY] 4.7.12Orders
USE [Furniture] GO /****** Object: Table [dbo].[Orders] 06:04:12 ******/
Enrolment No: 054579669
Script Date: 09/29/2009
BCA-IGNOU
37 of 43
Furniture Shop management system
2009
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Orders]( [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [OrderDate] [datetime] NULL, [Customer] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [SalesPerson] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [SubTotal] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxPercent] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxAmount] [money] NULL, [GrandTotal] [money] NULL, [Remarks] [ntext] COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] 4.7.13PO Items
USE [Furniture] GO /****** Object: Table [dbo].[PO_Items] Script Date: 09/29/2009 06:04:31 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PO_Items]( [ItemsID] [int] IDENTITY(1,1) NOT NULL, [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [ItemQty] [int] NULL, [ItemPrice] [int] NULL, [Amount] [int] NULL ) ON [PRIMARY]
Enrolment No: 054579669
BCA-IGNOU
38 of 43
Furniture Shop management system
2009
4.7.14PO Master
USE [Furniture] GO /****** Object: Table [dbo].[PO_Master] Script Date: 09/29/2009 06:04:52 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PO_Master]( [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [OrderDate] [datetime] NULL, [Supplier] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [SubTotal] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxPercent] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxAmount] [money] NULL, [GrandTotal] [money] NULL, [Remarks] [ntext] COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
4.7.15Product Master
USE [Furniture] GO /****** Object: Table [dbo].[Product_Master] 09/29/2009 06:05:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Product_Master]( [ProductID] [int] IDENTITY(1,1) NOT NULL, [Product_Name] [nvarchar](150) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product_Code] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL,
Enrolment No: 054579669
BCA-IGNOU
Script Date:
39 of 43
Furniture Shop management system
2009
[ProductType] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Material] [nvarchar](100) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Price] [money] NULL, [Stock] [int] NULL ) ON [PRIMARY] 4.7.16Product Type Master
USE [Furniture] GO /****** Object: Table [dbo].[Product_TypeMaster] Script Date: 09/29/2009 06:05:36 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Product_TypeMaster]( [ProductTypeID] [int] IDENTITY(1,1) NOT NULL, [Furniture_TypeName] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] 4.7.17Repair Order Master
USE [Furniture] GO /****** Object: Table [dbo].[RepairOrder_Master] 09/29/2009 06:06:02 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[RepairOrder_Master]( [RepairOderID] [int] IDENTITY(1,1) NOT NULL ) ON [PRIMARY]
Script Date:
4.7.18Supplier Master Table
USE [Furniture]
Enrolment No: 054579669
BCA-IGNOU
40 of 43
Furniture Shop management system
2009
GO /****** Object: Table [dbo].[Supplier_Master] Script Date: 09/29/2009 06:06:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Supplier_Master]( [Supplier_ID] [int] IDENTITY(1,1) NOT NULL, [SupplierName] [nvarchar](255) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Address1] [nvarchar](255) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Address2] [nvarchar](255) COLLATE SQL_Latin1_General_1_CI_AS NULL, [City] [nvarchar](200) COLLATE SQL_Latin1_General_1_CI_AS NULL, [State] [nvarchar](100) COLLATE SQL_Latin1_General_1_CI_AS NULL, [PINcode] [int] NULL, [No] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [EMail] [nvarchar](100) COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] 4.7.19Warranty Items
USE [Furniture] GO /****** Object: Table [dbo].[Warrenty_Items] 09/29/2009 06:07:18 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Warrenty_Items]( [ItemsID] [int] IDENTITY(1,1) NOT NULL, [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Product] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [ItemQty] [int] NULL,
Enrolment No: 054579669
BCA-IGNOU
Script Date:
41 of 43
Furniture Shop management system
2009
[ItemPrice] [int] NULL, [Amount] [int] NULL ) ON [PRIMARY]
4.7.20Warranty Repairs
USE [Furniture] GO /****** Object: Table [dbo].[WarrantyRepairs] Script Date: 09/29/2009 06:06:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[WarrantyRepairs]( [OrderNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [OrderDate] [datetime] NULL, [InvoiceNo] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [Customer] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [SubTotal] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxPercent] [nvarchar](50) COLLATE SQL_Latin1_General_1_CI_AS NULL, [TaxAmount] [money] NULL, [GrandTotal] [money] NULL, [Remarks] [ntext] COLLATE SQL_Latin1_General_1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
5.
LIMITATIONS 1) There is no different profile of the s maintained in the system. 2) Permission system is not available. 3) What if analysis reports
Enrolment No: 054579669
BCA-IGNOU
42 of 43
Furniture Shop management system
6.
2009
SCOPE OF THE FUTURE APPLICATION 1) To create the profile for the s like , General etc. 2) To create the permission system which restricts or allow the specific operation as per the profiles 3) Customer profitability reports 4) Report on “The average number of days taken for the repair” 5)
Report on “Identification of regular customer” which will help in providing discount on the sales
6) Cost management system 7.
8.
BIBLIOGRAPHY 1)
http://en.wikipedia.org/wiki/Data_flow_diagram
2)
http://msdn.microsoft.com/en-us/sqlserver/default.aspx
GLOSSARY GRN: In business, goods received note [GRN] is generated whenever a delivery is made to the business. The GRN details what goods and quantities have been received and when. A copy of the GRN is sent to the s department to enable them to match it to the purchase order [That would have been raised when the goods were originally ordered from the supplier] When the invoice is received, this is matched to the purchase order and GRN. Only if the details on all the three match up, is the invoice paid. Invoice: An invoice or bill is a commercial document issued by seller to the buyer indicating the products, quantities and agreed prices for products or services the caller has provided to the buyer. An invoice indicates the buyer must pay the seller, according to the payment .
Enrolment No: 054579669
BCA-IGNOU
43 of 43
Related Documents 3h463d
Bca Project Report - 054579669 4m5t3l
December 2021 0
Bca Project y696n
August 2021 0
Bca Project y696n
November 2019 20
New Synopsis Bca Project 646538
October 2019 37
Bca-1st Year Project 5e4g62
December 2019 45
Bca d2x53
November 2019 38More Documents from "Shree Ananth" 592y54
Bca Project Report - 054579669 4m5t3l
December 2021 0
Sas_di_developer_-_fast_track.pdf 53181f
December 2019 49
Fact And Opinion Climbing Blindly 5o5s60
December 2021 0
Reliance Mutual Fund Final Project m1it
December 2021 0
Agricultural-microbiology.pdf 356d1i
December 2019 51