Quote:
Originally Posted by sciurius
Case two: When I select one book and change the author only in case (e.g. "unknown" to "Unknown"), all books currently having that value as author are affected.
IMHO the latter behaviour is undesired.
|
I personally think that this behavior is exactly as it is supposed to be. You make a change to the database, it propagates to all the records. I do not think it is desirable to have Unknown AND unknown authors in the authors table in database. And you can only assign a value from authors table as an author for the book, exactly as design of a relational database dictates.