Scribd Logo
Upload

Welcome to Scribd!

  • 6 views

    Presentation 5

    Uploaded by

    surajsinghlodhi2311
    ngng

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Presentation 5

    Uploaded by

    surajsinghlodhi2311
    6 views8 pages
    ngng

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    ngng

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    6 views8 pages

    Presentation 5

    Uploaded by

    surajsinghlodhi2311
    ngng

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 8

    LPG Gas Billing System

    Description
    The project entitled “Gas Agency” is done to make the
    manual process easier by making it a computerized
    system for billing and maintaining stock. The Gas
    Agencies get the order request through phone calls or by
    personal from their customers and deliver the gas
    cylinders to their address based on their demand and
    previous delivery date. This process is made
    computerized and the customer’s name, address and
    stock details are stored in a database.
    This process is made computerized and the
    customer’s name, address and stock
    details are stored in a database. Based on this the
    billing for a customer is made simple and easier,
    since a customer order for gas can be accepted
    only after completing a certain period from the
    previous delivery. This can be calculated and
    billed easily through this. There are two types of
    delivery like domestic purpose use delivery and
    commercial purpose use delivery.
    and billed easily through this. There are two types
    of delivery like domestic purpose use delivery and
    commercial purpose use delivery. The bill rate and
    capacity differs for both. This can be easily
    maintained and charged accordingly. The stock of
    gas and all its details are processed swiftly. The
    stock of gas and all its details are processed
    swiftly. The following are involved in this project
    The following are involved in this project

    1. Customer Details
    2. Delivery Details
    3.Stock Details
    4. Billing Details
    5.Booking Details
    6.Price Details

    gh
    Structure of SQL Table
    Billing Details
    Column Name Data Type Description
    sl no., int Serial no.
    Consno. int Consumer No
    cylintype Char(10) Cylinder Type
    bddate datetime Booked Date
    deldate datetime Delivery Date
    amt float Amount
    Customer Details
    Column Name Data Type Description
    Consno. int Consumer No
    cltype Char(10) Cylinder Type
    noofcl int No of Cylinder
    dtofconn datetime Date of Connection
    consname Char(20) Consumer Name
    addr Varchar(50) Address
    pin int Pincode
    phone int Phone Number
    mobile int Mobile Number
    cdate datetime Connection Date
    Price Details
    Column Name Data Type Description
    cylty Varchar(20) Cylinder Type
    price float Price

    Transaction Stock Details


    Column Name Data Type Description

    commstk int Commercial Stock


    domestk int Domestic Stock

    You might also like