We have a school database for a charity organization event. Schools are entered into the an administration panel of our system and then teachers are sent a code to login the portion of our site where they are able to register students, pick a lunch for each student and add the amount of wristbands they would like to have shipped to their school for fundraising purposes. At this present time having multiple schools registered under the same email causes an administrator with multiple schools to only be able to login to one school account.
The database structure has a flaw: non-unique IDs are used in places where unique IDs are required. This seems to have effects in various places of the application. We need someone with database expertise to look at the database, give an estimate and do the work.
We are effectively looking for a second opinion for what it would take to solve this problem from someone with many years experience with sql