• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Bear Bibeault
  • Knute Snortum
  • paul wheaton
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Ganesh Patekar
  • Tim Holloway
  • Carey Brown
  • salvin francis

Meet-in-the-middle mapping question

Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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,
Without subsidies, chem-ag food costs four times more than organic. Or this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!