locked
how to Design database for applicaion with ever increasing input forms ? RRS feed

  • Question

  • we have an application where user fills up checklists , these are different for different tasks. As new task are added these checklist forms also increase. However general formato of the checklist remains intact.

    In the sense we will have structure of the form intact like input for

    task details (collection of fields) , documentation - checks avaialability of task level documents etc.

    As these fields will keep on increasing . what is the best database design ?


    Guneet Kalra

    Monday, June 18, 2012 4:04 AM

Answers

  • >>>we want the checklist form also to be generated dynamically

    It is OK, you have one Window Form in .NET application and generate dynamically fields that relate to the task. You need a table like Task_Fields with at least two columns (TaskID and FieldName), such as each task has its fields to be display on the form.


    Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

    Monday, June 18, 2012 5:49 AM

All replies

  • I would have main tables named Tasks (Name, CreateDate ,CreatedBy and etc.) and TasksDetails....

    Your fields do not increase, but rows in the Tasks and TasksDetails will be increased as new tasks will be adding...


    Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

    Monday, June 18, 2012 5:16 AM
  • Hi uri ,

    As the checklist for forms are different for different task , the checklist for task1 may have 10 fields to check 10 different docs and for task 2 fields may be 15 for 15 documents to be verified.

    so the req is such that fields are different for different tasks.


    Guneet Kalra

    Monday, June 18, 2012 5:26 AM
  • OK, you need to have a table which has all those fields and display them according to the tasks. How many fields it could be? 

    Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

    Monday, June 18, 2012 5:34 AM
  • we want the checklist form also to be generated dynamically , in the form the number of fields will be 50-60 of differnet types.

    Guneet Kalra

    Monday, June 18, 2012 5:43 AM
  • >>>we want the checklist form also to be generated dynamically

    It is OK, you have one Window Form in .NET application and generate dynamically fields that relate to the task. You need a table like Task_Fields with at least two columns (TaskID and FieldName), such as each task has its fields to be display on the form.


    Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

    Monday, June 18, 2012 5:49 AM