Thanks francoisjacquet for your response!
Let's assume Mr. Owner has made a chain of 3 private schools: School A, School B & School C. The principals of these schools are Able, Bob & Charlie respectively.
Will all 3 schools (i.e. A, B & C) connect to one database at some central location? Mr. Owner should be able to see the data / reports etc. of ALL the schools in that chain but Able, Bob & Charlie can see the data of ONLY their relevant school/branch?
In that case, will we have 3 rows in the Schools table, i.e. one row for one school?