SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: Database advice

  1. #1
    SitePoint Member
    Join Date
    Jun 2003
    Location
    Michigan
    Posts
    21
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Database advice

    I am creating a web based educational testing site. Teachers can add modules to the site for different classes. Most of these modules will be custom programmed. When a student logs in they will see all of the modules that are available for the class that they are enrolled in. They then would click on a link that would take them to that module's test. What is the best way to do this? My module table right now has the following fields: moduleID, module_name, and module_num (This allows the teacher to order the modules in whatever order they wish.) Should I include another field, hyperlink, that directs the student to that module's testing page? Or is there a better way to acheive this?

    Thank you in advance,

    Ray

  2. #2
    get back to rowing khu19's Avatar
    Join Date
    Jan 2003
    Location
    New York / Boston
    Posts
    593
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You could include the hyperlink as you suggested or include the actual test in the database. What is module_num? Is that the same as moduleID?

  3. #3
    SitePoint Member
    Join Date
    Jun 2003
    Location
    Michigan
    Posts
    21
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    module_num is a way of ordering the modules.
    1.0101 would be book 1, chapter 1, section 1, that was my solution to putting the modules in a nice order.


Bookmarks

Posting Permissions

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