I'm currently trying to design a database for a website I'm creating but im running into a few problems. Hopefully someone can help!
I have a "Lecturers" table which contains all their details, email ,name etc and a "Modules" table which contains Module Codes and Title's etc. The core problem i'm having in trying to include different features for different modules.
Lets say I have one module that will have a news, a labs and a project feature(each of these features have their own separate tables aswell).
Do I create a table called "Module" with the fields, moduleCode,newsID,labID,projectID ?
I dont see how I can create a table of features, if each feature itself is a table with different fields to the next?
Any idea's of how I should approach this are much appreciated !