Design question about storing info on different schools
I'm trying to design a database that stores information about different schools, which will be used in a web app. The information (in tables) for each school I am storing include students, majors, professors, courses, and course categories. I can easily design the tables for a single school, but the problem I am having is how to design the tables so that I can store this information for more than one school. Is it better to:
-try to store all the information on all the schools in one db
-create a different instance of a db for each school, and when the user wants information on a specific school, select the specified database.