I have a fairly limited understanding of databases, this is causing problems!!
I need to store some records, which when queried return results...
Within the DB i need to store (as an example) School(s), class(es), pupil(s), pupil age, and an ID number that relates to an image.
Fairly simple so far, but i dont know how the database design would work, it needs to be searchable by pretty much all of the fields above, and display the appropriate results, (pupilds in class or whatever - with their images from the server) however we dont want someone to be able to search for pupil name from the start because we dont want it to search 60,000 records in full looking for one child.
So - any suggestions or help would be appreciated.
I need to store some records, which when queried return results...
Within the DB i need to store (as an example) School(s), class(es), pupil(s), pupil age, and an ID number that relates to an image.
Fairly simple so far, but i dont know how the database design would work, it needs to be searchable by pretty much all of the fields above, and display the appropriate results, (pupilds in class or whatever - with their images from the server) however we dont want someone to be able to search for pupil name from the start because we dont want it to search 60,000 records in full looking for one child.
So - any suggestions or help would be appreciated.
.