#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2016
    Posts
    2
    Rep Power
    0

    Help with MySQL DB Design


    I have created a learning database (which I have attached which allows a user to set up a group and attach classes to this group which will then have lessons attached to the classes. If the lesson is too difficult for a user then they will be offered prerequisite lessons to help them understand the fundamentals..

    I need to track how the user is progressing through each lesson and class that they have signed up for and I am trying to design the database around this.

    I feel I have designed this part incorrectly. Could someone have a look at the ERD and give advice on the problems with it.

    I have attached a pdf of the MySQL Workbench here
    https://drive.google.com/file/d/0B_2...ew?usp=sharing

    I have also attached the MySQL Workbench file here for anyone to have a look at.
    https://drive.google.com/file/d/0B_2...ew?usp=sharing

    Thanks in advance
    Max
  2. #2
  3. Lord of the Dance
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    Oct 2003
    Posts
    4,131
    Rep Power
    2011
    My comment for each table:
    user: I am not sure why you have the associated_* fields in that table. I think users should be part of a class.
    Lesson: If there is only one instructor, then instructor_id field is ok. I don't think lesson should know about classes, but instead let classes know which lesson it teach.
    prerequisite_lesson: This looks fine.
    classes: Maybe have some information on time schedule. instructor_id does not point anywhere?
    group: Can't really see what the purpose is for this table.
    user_details: Maybe this should be renamed to user_class_details. Where is module_id related to?

    I hope it is a help.

    Comments on this post

    • max_maggot agrees
    Last edited by MrFujin; July 27th, 2016 at 08:53 PM.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2016
    Posts
    2
    Rep Power
    0

    Thanks


    Thanks for your input. I'll implement your suggestions. This is very useful. Thanks again.

IMN logo majestic logo threadwatch logo seochat tools logo