I have created for an e-Learning Web Application. I am not sure if the concept I have chosen is correct and would appreciate any sort of guidance or assistance to improve the design.

Please see attached screenshot of database design.

Edited by saras1031: n/a

Attachments erd.jpg 21.39 KB
5 Years
Discussion Span
Last Post by MartinPlatt


I think what you have there is almost like Object Relational Modelling rather than ERD. With ERD you need to be modelling things like if a relationship is mandatory or not, and how many relationships might exist (cardinality). You can use crows feet notation to indicate this (google it, it's quite a big subject)

I think using that sort of a notation will help you think through your real world relationships. You aren't far away though. I'd also start to sketch out the sorts of data that you might find in those entities, as this will also help you think things through and test your assumptions.

Things like, are there relationships between modules and programs? Can a student also be a staff member, and does this complicate the realationship, or does it mean that things can be consolidated, and therefore be simpler?

You may also like to draw boxes around the higher level concepts, so you have something that is a person, or user, something to do with the course definitions (the course) and descriptions, and something that is the intersect of those two things, probably conceptually something along the lines of a 'study' (essentially a user 'studies' a course).

I'm being very high level, but I hope that this helps to get you thinking?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.