|
|
Posted by Ed Murphy on 11/30/06 20:01
--CELKO-- wrote:
> 1) You never use "-key" as a suffix. That tells us HOW the data
> element is used and not WHAT the data element is.
I work with an established package that uses "-key" as a suffix
regularly, but always for artificial keys (so "what the data element
is" is established across the board by convention as "nothing the
end user has any business seeing").
> 5) Notice that you do most of your work with DRI actions, not in code.
> The idea of a RDBMS is that it keeps data integrity for you.
[snip]
> The DRI makes < 1 redundant, but it preserves what you posted. The DRI
> actions will re-arrange the Attendance as people or appointments drop
> out.
If they drop out completely. If a person drops one appointment but
retains others, then the system should directly delete the Attendance
row corresponding to the dropped person+appointment pair.
Navigation:
[Reply to this message]
|