Database Design Problem

Discussion in 'Databases' started by merianos, Aug 8, 2007.

  1. #1
    I need some help in my database design.

    The following chart showing the current stracture of a small part of my database.

    [​IMG]

    What my problem is now ? ? ?

    The table SYSTEMATIC_RASH_EPISODES must have from one to three sub records depents on what drugs(medicens) the doctor must give to patient for each column starting from the SYRE_SKIN_PALM_ITCH. All the columns after SYRE_SKIN_PALM_ITCH are storing only boolean values.

    The question is :

    How can i do that ? ? ?

    Thanks a lot . . . :D
     
    merianos, Aug 8, 2007 IP