I'm trying to develop a system which will be used by admin department to key in lecturer and student data.
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.
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 :)