Re: Video rental shop

In message <f0d5086.0108030247.28b2ae43_at_posting.google.com>, Joel Rees <jreesmf_at_mac.com> writes

>
>and the advantage here would be to be able to assign the genre when
>the title is entered in the database, and have an action clear the new
>title flag automatically.

That's probably undesirable. The genre code isn't really a genre, it's likely to be a physical location code. New releases will be kept on a different shelf and moved to their genre shelf after 30 days. The action needed is to send a list of titles that need to be moved, and the shelf they should be moved to. It might be useful to have the staff confirm that they have physically moved the stock.

This is an example of a code being overloaded with additional meanings. New Release is not really a genre, it's an extra code that might be stored in that field. Consider what happens in a really big video store where there might be a separate new release section within each genre.

-- 
Bernard Peek
bap_at_shrdlu.com

In search of cognoscenti