DB Design Question RRS feed

  • Question

  • Hi,

    Below is my table design with the various relationships. Any suggestions on improving this or does it all look good?

    Here is sample data. Will is in Analyst role so has ApprovalRoleID of 1.

    I have a scenario, where if Result = 100, then the Approvals Table automatically gets populated with both Analyst and Supervisor approvals (entered as 'Automated').
    What would be the best way of doing this? Rather than multiple insert statements.


    • Edited by obrienkev Wednesday, April 17, 2013 4:19 PM
    Wednesday, April 17, 2013 4:12 PM


  • Can you define the purpose of each table? Are you giving a user (detail?) certain roles to approve things? And which table will be used as foreign keys in other tables? Plus, is the values in ApprovedBy a user (detail?) too?

    Perhaps a few requiremnets could help clarify what you are trying to  do.


    Without good requirements, my advice is only guesses. Please don't hold it against me if my answer answers my interpretation of your questions.

    Wednesday, April 17, 2013 7:22 PM