Home Forums Database Design Relational Theory Add allowance to employee table is wrong or true RE: Add allowance to employee table is wrong or true

  • February 13, 2015 at 3:50 pm

    #1777630

    Use a separate table as those are different entities.

    You should have an entity allowance with attributes type and amount. You might need to have dates to define time periods but that is something you don't mention how would you handle that.

    How will you manage history?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2