Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007

    Unanswered: Database design Help

    Actually i have been assigned a project in Sql server 2000 with front end in vb 6, and its an inventory control system of a computer retail company. i dont know how to make its design. it must show inventory items and new purchases and when they are made they must update the inventory and when the items in the inventory are taken to prepare orders recieved from the customers the inventory must be updated. it must also show customers back orders, daily expenditurers, monthly expenditures, staff handling the inventory, different brands ND JOURNAL AND LEDGER Accounts, journal accounts show daily expenses of a month and ledger shows monthly expenses and it must also show yearly expenses and net profit and the transactions made to the company accounts by the customers and when items are bought from the supplier it must automatically update the company's account when the comapny makes payment to the supplier.

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    Hi riz

    It sounds like you have a brief to build a system from the ground up and you so far have got out a blank piece of paper and perhaps a pencil.

    This is far too broad a question for a forum - this is more like the very first steps towards an invitation to tender.

    Have you been assigned this in house or is this an academic exercise for a hypothetical retail company?
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts