0 Replies Latest reply on Feb 10, 2015 5:10 AM by brian47933

    Help in Planning Database

    brian47933

      Title

      Help in Planning Database

      Post

      Hello everyone. I'm new to FileMaker and am looking for guidance in database design. We are a school moving from multiple Excel worksheets to a small database.

      I want to track student progress through our system. I need to see student information including current and past classes, exam results, academic advisor, and current and past teachers.

      I have some understanding of the one-to-many relationship, but I'm not clear on how to do the setup.

      I've come up with the attached diagram.

             
      1. One School Year to Many Modules.
      2.      
      3. One Module to Many Levels.
      4.      
      5. One Level to Many Sections (individual classes)
      6.      
      7. Many Teachers to Many Sections (I created a Link Table called Registers - Many Teachers to One Register)
      8.      
      9. One Section (or Register) to Many Students
      10.      
      11. One Register to Many Exams (I want to track Students Exam results by Section here)
      12.      
      13. One Dean to Many Students

      We use a unique StudentID number generated by the Student office. I would like to use this number to do searches. I have been watching the training videos on Lynda.com.

      Any guidance on how to get this design organized and what I need to look out for would be greatly appreciated.

      Screen_Shot_2015-02-10_at_2.58.45_PM.png