tags:

views:

16

answers:

0
Q: 

database design in MySQL and Hibernate

Hi everybody,

I am new to the all technologies just familiar with the introduction of both... I am planning to make railway reservation project, in that I want to use MySQL with Hibernate... So I have one sample design of database to make a project, I need help to combine the MySQL with Hibernaete...

Database Design... trains (ID,name,from,to,date) PK(ID)

boogies (ID,trainId,name,) CompositeKey(trainId,boogieId)...

seats (ID, trainID, boogieID, status, type ) CompositeKey(trainId,boogieId,seatId)

users (ID, name, ... personal details) PK (ID)

userBookings (ID, userId, trainId, boogieId, seatId) CompositeKey(trainId,boogieId,seatId)

Suggest me is this a good design of database to implement a web application if yes then reply me how to use hibernate in this type of table structure like mapping... one-many many-one one-one many-one

Please Help me...

related questions

Is it worth the effort to move from a hand crafted hibernate mapping file to annotaions?
Hibernate Tools and the ever changing database
What is the best way to load a Hibernate object graph before using it in a UI?
HQL querying columns in a set
Is it possible to use analytic functions in Hibernate?
Hibernate (JPA) how to do an eager query, loading all child objects
Hibernate mapping a composite key with null values
Mixing EJB 2.x BMP entity beans with Hibernate 3.x
Lazy loading property and session.get problem
Hibernate - maxElementsOnDisk from EHCache to TreeCache
Hibernate criteria _ how to use criteria to return only one element of an object instead the entire object
When can/should you go whole hog with the ORM approach?
How do you "OR" criteria together when using a criteria query with hibernate?
Looking for an HQL builder (Hibernate Query Language)
Enabling Hibernate second-level cache with JPA on JBoss 4.2
Getting hibernate to log clob parameters
Hibernate crops clob values oddly
(N)Hibernate - is it possible to dynamically map multiple tables to the one class
Querying collections of value type in the Criteria API in Hibernate
How to maintain Hibernate cache consistency running two Java applications?
Why @OneToMany does not work with inheritance in Hibernate
data 'security' with java and hibernate
Using Hibernate to work with Text Files
Giant NodeManagerLogs from hibernate in weblogic
Hibernate saveOrUpdate with another object in the session