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

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

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

thanks for update.

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

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

thanks alot for your help
best of regards

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

whoa, that's unusual

well, you can search in bing.com or duckduckgo.com instead

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

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

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