Is there a book for software design problems? [closed]

Question

Searched through net and couldn't find some book that presents some design problems to solve. Has anybody came across such (or similar) book? There are, of course, many design problems found on internet, for example, simple game design problems, airport design, parking lot design etc. But is there a collection?

Answer 1

http://homepage.mac.com/s_lott/books/oodesign.html

I liked it.

Answer 2

"Patterns of Enterprise Application Architecture" and "Analysis Patterns: Reusable Object Models" by Martin Fowler come to mind?

Links: http://martinfowler.com/books.html#eaa and http://martinfowler.com/books.html#ap

Answer 3

Most software development textbooks have problems in them, and some "how-to" books.. but they're usually single exercise sort of problems.

There are also books on "anti-patterns" and "How not to write software", but I don't know of anything that is just a collection of problems. Sounds like it would have a very limited audience.

Answer 4

Specific to SQL but Joe Celko's, the author of the excellent SQL for Smarties has a book Joe Celko's SQL Puzzles and Answers.

I own earlier versions of both and when I bought them the puzzle book was presented as something of a companion to SQL for Smarties, though I don't think you need to have read one to enjoy the other (though the stuff you'll learn from it would undoubtedly help you solve the problems).

Between them great for getting your head round a SQL mindset - that is say thinking in datasets rather than procedurally.

Answer 5

"Patterns of Enterprise Application Architecture" is the seminal tome, but for something similar but a bit easier "Head First Design Patterns" is pretty good.