Just the fact that the question involves "Dorms" says this must be a homework assignment. Coupled with the fact that you think something this simple is "intricate", that moves it to a near certainty that it's homework. So, maybe you should read whatever book or other materials you have, so far.

But in any case, it would indeed help to know what DB software you have access to and/or what you are supposed to use.