Results 1 to 10 of 10
  1. #1
    Join Date
    Nov 2011
    Posts
    15

    Unanswered: tables design and relationship

    hi,

    i need help in my tables design and their relationship, i dont know if am doing it right or not......am trying to develop a learning repository for learning materials, and the way i have to represent the repository content is by categories or in a tree structure. i have attached jpg showing how the tables will be displayed, and based on user selection the next category content will becomes visible, materials are also categorized by materials type like (tutorial, example, exercise, case study)....

    please are there any suggestion how to design my tables and their relationship...your help will be very much appreciated...
    thanks alot

    regards
    zellal
    Attached Thumbnails Attached Thumbnails table categories.jpg  

  2. #2
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250
    with a very quick look at the image this is wat i have comeup with. Please have a look and let know if you find anything missing in this.


    CourseMaster
    ------------
    CourseID
    CourseName


    Subject
    -------
    SubjectID
    SubjectName


    Topic (changed name of learning object to Topic)
    ---------------
    Topic_ID
    TopicName


    SubjectTopic
    -------------
    SubjectID
    TopicID

    Material
    -----------
    MaterialID
    Name


    InstructionMaterial
    -------------------
    InstructionMaterialID
    MaterialID
    Name
    Cheers....

    baburajv

  3. #3
    Join Date
    Nov 2011
    Posts
    15
    hi baburajv

    thanks for your feedback, i guess you have missed the relationship between course and subject..should it be

    subjects
    ---------
    subjectID
    courseID
    subjectName

    or should i make it


    courseSubject
    --------------
    courseID
    subjectID


    thanks in advance
    regards

    zellal

  4. #4
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250
    thanks for update.

    Please consider using the below schema for the course-subject mapping

    courseSubject
    --------------
    courseID
    subjectID
    Cheers....

    baburajv

  5. #5
    Join Date
    Nov 2011
    Posts
    15
    thanks alot for your help
    best of regards

  6. #6
    Join Date
    Nov 2011
    Posts
    15
    Hi,

    I would like to ask for something, now i have designed my tables and i need to populate data into tables. for the learning materials i have to collect and populate into the database, what is the best way to find and collect reliable learning materials for C++ topics without searching in google and going through lengthy results list.

    thanks in advance

    with regards
    zellal

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by zbath81 View Post
    ...without searching in google
    whoa, that's unusual

    well, you can search in bing.com or duckduckgo.com instead
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  8. #8
    Join Date
    Nov 2011
    Posts
    15
    what i mean is there any program that i can use to extract learning materials from learning repositories through their APIs...
    is that possible and can be done...
    that what my supervisor asked me to do..and am not sure how to do that...

  9. #9
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    ?
    the mechanism in which your learning matrerials are stored / encoded tends to dictate the how you extract learning materials fromtheir repository

    ferinstance
    if the learning material is stored in Acrobat PDF then acrobat PDF reader is a probably the best program
    if its as a JPEG slideshow or film/movie then some form of media player.
    if its a document... then whatever the local host uses to display docuemtns
    if its a web page...... and so on.....

    what actually is the brief for this homework?
    I'd rather be riding on the Tiger 800 or the Norton

  10. #10
    Join Date
    Nov 2011
    Posts
    15
    hi healdem

    well actually am trying to apply new searching mechanism by providing visualization on learning repository content.
    all the learning materials will be links of web pages....
    so i need to develop my own repository that consist learning materials which will be stored using metadata like (title, creator, date, url, resource type)
    then i have to connect the database to the program developed to run the visualization....

    so i have to collect huge number of learning materials which has the metadata i have mentioned above and populate it into my database to run the project and the visualization test.....

    and i dont know the best way to do that
    Last edited by zbath81; 11-06-11 at 18:32.

Posting Permissions

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