Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2007
    Posts
    3

    Database Design feedback (absolute beginner here :)

    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!!!!

  2. #2
    Join Date
    Feb 2007
    Posts
    3

    diagram in gif format

    diagram in gif format....
    Attached Thumbnails Attached Thumbnails db_elearning_diagram.gif  

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    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.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Feb 2007
    Posts
    3
    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

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by blindman
    ... which serves no purpose other than to annoy.
    quote of the week

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Feb 2007
    Posts
    1
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •