Results 1 to 3 of 3
  1. #1
    Join Date
    May 2016

    Design e-r diagram for small inventory system

    Hi, i am new to databases and i want to design a small database for medicines.
    I want to store medicines info(ATC_CODE, DRASTIC, FORM, CONTENT, PRICE, NAME)
    Also i will have users(username, password) to store the medicines.
    I want the database to record the input quantity of medicines, the output quantity of medicines, the date of in/out, and the username who made the in/out.
    Also of course i want to know the stock of each medicine.
    Can you suggest an e-r model for the above?

    Thank you in advance
    Last edited by nnannos; 05-03-16 at 07:19.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    While it might not be apparent at first, you also need regulatory approval to inventory drugs. This makes "roll your own" almost prohibitively expensive.

    I would recommend using GnuCash. It handles inventory well, and it comes ready to use.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    May 2016
    Hi nnannos

    Is your thread closed or are you still looking for a advice?

Posting Permissions

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