Hi that’s fine, as I say I’m completely new to database design so looking for any advice.
So we have 30-40 courses online with extensive information such as course summary, entry requirements, fees, modules, student case studies, how to apply etc…
However, what I want is to strip this content down to the bare minimum and use it to populate a table which has course name, entry requirements and fees only. This way your can see all courses on one page at one time which allows staff to see the basic information at a glance without the need to click through each individual course.
Is there a logical way to do this?