ma5ect Posted October 20, 2008 Share Posted October 20, 2008 Hi all, i am setting up a database using sql to store details for students modules results, i have 3 tables students modules results the issue is i cant understand how to store data in the results table, as students have completed many modules, how would i store this? Quote Link to comment Share on other sites More sharing options...
Barand Posted October 20, 2008 Share Posted October 20, 2008 It would help greatly if you gave us some idea about the data you want to store in these tables Quote Link to comment Share on other sites More sharing options...
ma5ect Posted October 21, 2008 Author Share Posted October 21, 2008 students table... student ID surname forename course year module table(subject)... module ID module name results table.. student ID (FK) module ID (FK) completed attempts in the results table i want to store data of many student who has taken many modules and store there results... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.