Well, one thing you need to know is that Hiberante won't create the schema. You need to create the schema manually, as in through the MySQL admin console. Once created though, Hibernate will connect to it, and create all of the tables and columns as you specify in your annotations.
It's always good to quote your sources. I'm sure alot of people here on JavaRanch would love to know where you got such a fine and handsome ERD diagram. I'd be really impressed if someone had managed to properly map all of those complex relationships with JPA annotations.