From: James Newsome (jnewsome@ece.cmu.edu)
Date: 01/30/03
I'm not sure how to put the database schema together. Using the parking
space finder as a model, the only way seems to be to put the static
information about each person under each location, and have a 'present'
field that the SA sets to yes or no.
However, this seems wrong from a database perspective. i.e. the fact that
Justin Case is a 43 year old faculty should only be in the database once.
The way that makes more sense to me is to have an entry for each person at
the global level, (or maybe the CMU level), and have the SA dynamically
insert and delete entries at their local levels that are just keys
pointing to the rest of the information about that person. Is there a way
to do this in the current infrastructure, or am I heading in the wrong
direction?
Thanks,
Jim
This archive was generated by hypermail 2.1.5 : 06/10/04 EDT