Andreas Ntaflos wrote: > > Naturally a room cannot be identified without a building so it is a weak > entity (this seems to be the canonical example in all database books I've > seen). >
That is only true if you allow the same roomID to be used in multiple buildings (i.e. there exists a room 101 in building A, and a room 101 in building B). In this case, you do *not* want to auto increment the roomID values. Now you require the combination of the roomID and the buildingID to identify a particular room. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
