Hi all,
I’ve been programming using PHP, VB, C#, Java, MySql etc for years now.
Most of the thing I’ve make is just a small tools.
But when it comes to making a complete system, I’m kinda… stucked. 
The recent project I’m developing is a Reservation system. When implement in OO, layered(GUI, Biz Layer, DB) and Object Relation Mapping system way, I’m paralyzed. I’m confused and failed to see the whole picture of how my own program runs. Not to mention making changes. And I always get confused between designing ERD table and Class object.
I know I’m weak in this area, so, I was wondering any good books/resources on these topic? I’m looking a pratical guide on designing a complete system, using proper Class Diagram, ERD and OO-to-RDBMS design. Anyone has experience on that?
p/s: I don’t really like UML btw. The diagrams confused me…