One rule of thumb about good database design is one fact,
Chapter 5, Problem 26(choose chapter or problem)
One rule of thumb about good database design is one fact, one place. Suppose you try to combine the Book and Writes tables over ISBN into a single relation as was done with the PetName and Owns relation. This table would have a heading of the form ISBN Title Publisher Subject Name How would the resulting table violate the one fact, one place rule? How many tuples have to be updated if the publisher Bellman changes its name to Bellman-Boyd?
Unfortunately, we don't have that question answered yet. But you can get it answered in just 5 hours by Logging in or Becoming a subscriber.
Becoming a subscriber
Or look for another answer