Last edited by rawkas; 11-15-2012 at 07:37 PM.
Last edited by Fou-Lu; 11-15-2012 at 07:39 PM.
Okay, I feel the need to chip in and help my associate present this question more clearly.
This is how the question is supposed to look.
We really do appreciate any help you can provide as we're both stumped. Thanks for your time.
And that's fine, but where is the current SQL in use and the problem you are having with it?
You can't just present us with a homework assignment and expect that we should do it for you. That would be called cheating; however we can help you fix existing code (or in this case queries) by walking through the problem and guiding you to the proper solution.
And on top of that, if the database is PROPERLY DESIGNED and uses correct RELATIONAL INTEGRITY, then task 3.3.4 is impossible. For that matter, the data as presented there is impossible. So somebody is teaching you bad database design.
Specifically, propid in the PERSONS table should be a foreign key to propid in the PROPERTIES table. And so the propid of 4 in the PERSONS table would be impossible in a correctly designed and implemented database.
Be yourself. No one else is as qualified.