Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Object Relational Mapping and the fly likes Meet-in-the-middle mapping question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Meet-in-the-middle mapping question" Watch "Meet-in-the-middle mapping question" New topic
Author

Meet-in-the-middle mapping question

Tomor Pupovci
Greenhorn

Joined: Oct 18, 2009
Posts: 1
Hi,
This is my db schema which looks like this:



So a staff (which is a teacher) can teach a specific subject (curriculum) to a specific class (class_id).

As you can see 'teaches' is the table where all the tables meet. I've tried the Dali tool and it did a pretty good job, by producing something like this (The 'Staff' entity, not entirely quoted, just the parts which have to do with 'teaches'):



But this makes problem when I want to persist a new Staff object, which 'teaches' a specific subject (year, class, subject_id) to a specific class_id, because it doesn't know which class_id with which subject go together. Could you please help me with a better solution for this?

Help is appreciated

Thanks in advance,
tomor
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Meet-in-the-middle mapping question