lundi 5 janvier 2015

Is below database design good? What JPA Entity's should I create for this design?


I am trying my hands on JPA. For this I am thinking of using example of student admission process as shown in the below diagram.


Database Digram


Is this design good ?


Any suggestions for improvement are more than welcome.


I am also confused about what Entity classes should I create for this. Especially for College_Major, should there be an Entity class for this or it should only be a mapping table created for many to many mapping between College and Major? If later is a better case, how can the Admission_Form table refer to a Major in a College? In either case how Entity classes (if good to have) for College_Major and Admission_Form should look like ?





Aucun commentaire:

Enregistrer un commentaire