Hi everyone!!!

I am absolutely a newbie on database design so please help me out even though questions might seem little stupid

I m trying to build a database design for an e-learning project; below is the database schema i ve got so far. In the current setup there are lessons which can be taken and information that has to be recorded for the lessons is that whether they are completed or not (i guess what i mean here is how can i represent the yes/no type of data entries)

Also if there will be practices (quizzes) to be completed. The completetion and the grades for the quizzes has to be also stored in the database. i have attached the diagram as gif and also in visio format.

Thank you and waiting for your responses

cheers!!!!

diagram in gif format....

You can start by dropping the 'tbl_' prefix from your object names, which serves no purpose other than to annoy.
What kind of data are you storing in the package_courses column? I suspect that should be spun off as a subtable.

hey thanks alot

Actually there two types of courses one interactive courses (with live tutor) and the other one is the self paced one which consists of lessons and quizzes(practices). The reason i put the package is for the users who might sign up for both interactive and self paced courses (you can choose either one or both of them). Hope it is clear enough. i m open to any suggestions

quote of the week

You might want to reconsider using the user email address as the primary key. If the user changes his email address, you will need to cascade the changes to other tables that refer to it.