I am quite new to this and am in the process of developing a student database at department level (e.g.) Chemistry.
I have student table/staff table/module table etc, and things are working fine.
Now I would like to enlarge the database to cover other schools, e.g. Physics and Biology, so different students, modules, staff etc and, on the main form, to be able to switch between schools via buttons.
What is the best way of incorporating the additional schools/students/staff data – is it best add additional data to my existing tables and structure and define by ‘school’ or would it be recommended to set up additional tables/relationships etc for the additional departments.