1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Setting up one too many tables???help

Discussion in 'Database' started by amg182, Mar 21, 2010.

  1. amg182

    amg182 New Member

    Joined:
    Mar 21, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Need help guys. No expert on Databases.

    I want to set up a student assessment database where i can track students progress.
    Students can take several units of work and each unit has a number of tasks.
    I would like to set up tables that allow students to enrol on more than one unit of work and track what tasks they have done for each unit.

    Any ideas how i would do this?

    Cheers
    Amg
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,276
    Likes Received:
    364
    Trophy Points:
    83
    Student will be a table and task will be a table which have a foreign key of student id.
     

Share This Page