1 Reply Latest reply on Dec 21, 2010 1:22 PM by philmodjunk

    How to make a Relational Database for teaching ideas



      How to make a Relational Database for teaching ideas


      I'm looking for some ideas on the best way to organize a database for teaching tools, ideas and quotes. I want to enter ideas and information that I observe from other teachers, ideas that I read in books, and quotes on different topics and then be able to search ideas that apply to certain subjects. 

      I have made a few attempts but I am having a hard time with ideas or practices that fit into multiple categories (for example: a quote that talks about "Motivation", "Lesson Planning" and "Classroom Management"). How can I create a field that will allow me to put in categories and even add categories if I find something that needs a totally new category?

      The broad categories I have come up with are "Teaching Ideas or Concepts" and "Sources." Under "Teaching Ideas" would be "categories" (like Lesson Planning, Classroom Management, Motivation, etc.), "subjects" (like rhythm, harmony, form, etc.) and "information" (the quote, or the idea on how to teach better). Under "Sources" would be "authors" (another area where I don't know how to make multiple people a possibility), "reference or title", "page numbers" and possibly "publication date". 

      Any suggestions on how to organize this would be very much appreciated. I am a beginner with databases but I have a rudimentary knowledge of how individual tables work. The relational part is more difficult for me. 


        • 1. Re: How to make a Relational Database for teaching ideas

          Use a separate table for a given "idea" record's list of applicable categories.


          You can place a portal to Categories on your Ideas layout and use a drop down of Category names to control/manage what possible categories you can choose to assign an idea to.

          You can see an example of this in my Known Bugs List where I assign a given Bug Report record to multiple categories. The drop down list of category names draws it's list of names from the Categories table so I can add a new category just by typing it's name into a blank portal row. Just click the "Bug Reports" button and check out the Category portal on the layout that appears.