Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/forums/database-forum/)
-   -   Setting up one too many tables???help (http://www.go4expert.com/forums/setting-tableshelp-t21445/)

amg182 22Mar2010 01:09

Setting up one too many tables???help
 
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

shabbir 22Mar2010 09:28

Re: Setting up one too many tables???help
 
Student will be a table and task will be a table which have a foreign key of student id.


All times are GMT +5.5. The time now is 23:45.