I am absolutely a newbie on database design so please help me out even though questions might seem little stupid [IMG]http://www.dbforums.com/db_images_v3/images/smilies/tongue.gif[/IMG]
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