Results 1 to 2 of 2
  1. #1
    kumud is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    1

    Relationships issue in school database

    I am NB to access, I know enough to create forms and tables. But could not wrap my head around creating a relationships between tables.
    I am in the process of creating a database for a school in remote place in India (for free of-course)
    Once a student enters school he/she spends about 10 years advancing each year.
    I created


    1. table for student info
    2. table for various subjects
    3. table with teacher info
    4. table with academic year.
    4. table for class

    each student would be advancing into a new class every year. I could not come up with a relationship to capture this without duplicating the data.
    I would appreciate your help in this regard
    Kumud

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    A school is in fact requires quite advanced skills. You want to fill the discrete tables so as to not free form type things. You rely on look up field types typically.
    Students
    Subject
    Teachers
    Semesters (this may be Year in some cases)
    Locations
    Class Times
    Class
    Enrollment

    One must appreciate then that it is the intersection of these discrete tables.
    Class is an intersection of several fields with a unique ID = E101A i.e. English 101, Teacher Fred, Class Times, Location, Semester
    unique ID = E101B i.e. English 101, Teacher Alfred, Class Times, Location, Semester

    Then Enrollment is an intersection of Class with Student: E101A - Mary Smith
    E101A - John Doe

Please reply to this thread with any new information or opinions.

Similar Threads

  1. school grades database
    By lockstock in forum Database Design
    Replies: 3
    Last Post: 09-18-2015, 10:17 AM
  2. School Gradebook relationships
    By larrywang in forum Database Design
    Replies: 7
    Last Post: 06-16-2015, 07:44 AM
  3. Replies: 6
    Last Post: 06-06-2014, 12:52 PM
  4. School Enrollment Database
    By jpepin in forum Database Design
    Replies: 1
    Last Post: 04-08-2010, 05:23 PM
  5. Database Design for a School
    By FallingToaster in forum Database Design
    Replies: 2
    Last Post: 08-12-2009, 10:47 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums