-1

I'm trying to develop a system which will be used by admin department to key in lecturer and student data.example

There will by many changes on the columns, the student might register other subjects such as Subject 10, Subject 11 and so on. And the lecturer could be Lecturer B, Lecturer C and so on.

Can you please suggest how should I create the database so that the user can change the columns' title and key in data according to their needs.

Lorek Bryanson
  • 195
  • 1
  • 7
  • 22
  • if the column values are dynamic, wouldnt it be better to have a table alone for the subjects and then map it to the students? – c0dem0nkey Feb 26 '13 at 02:30
  • @c0dem0nkey What if the column could be anything? The user might add new subjects after years. – Lorek Bryanson Feb 26 '13 at 02:34
  • Construct a table for subjects alone and give them id's. The relationship between the student id and subject id will be one-to-many. – c0dem0nkey Feb 26 '13 at 02:35
  • I'm thinking to add a hidden column with auto increment number for each record so that while calling data, I can select data by using the number. – Lorek Bryanson Feb 26 '13 at 02:37

1 Answers1

0

http://www.codeproject.com/Articles/177388/Best-Practices-for-Database-Schema-Design You can download a sample here. Also , the thing about auto inrement id is mentioned here. take a look :)

c0dem0nkey
  • 616
  • 4
  • 13