Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2015
    Posts
    2

    Any ideas to store unknown amount of entries?

    So im making a school proyect and im almost done, but after relooking at my database structure i noticed how little i can expand it.

    Let me first explain the application: Its a curriculum managment for the school to store all student information when they graduate (what they studied where they went for there fct...) beside that the students can update their profile anytime they want, besides that the teacher/school also has a list of componies, this companies are where the student do their fct.

    The problem is that i can make a relation between the compenies where the students did their fct (becouse i have them) but i cant make a good list of companies where the user works at or where they worked meaning its hard to index the search engine for those compenies (these are stored in a varchar cell in the user table).

    Any sugestions?

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    do
    compenies have many fct and fct can have many students

    if so

    how i would do it
    table list

    compenies
    ========
    compeniesID PK
    bla
    bla
    bla

    fct
    ==
    fctid PK
    bla
    bla
    bla

    students
    ======
    studentsID PK
    bla
    bla
    bla

    how the hold the DATA

    compeniesFct
    compeniesFctID PK
    compeniesID
    FctID
    bla
    bla
    bla

    studentsFct
    studentsfctID PK
    studentsID
    FctID
    bla
    bla
    bla
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Apr 2015
    Posts
    2
    The thing your missing is that the teachers need a individual list of companies which the students do their fct but this student may have worked at a other compenie or doing the fct in a company which the school doesnt have any info or need to store in de fct company list which means i have three tables and i just dont know how to make it work:

    -school_company_list
    -student
    -worked_at

    Edit:i think your idea is right i just missed a part of it, thanks for the help
    Last edited by paulvan; 05-03-15 at 13:39.

Posting Permissions

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