What do the colours mean in this diagram? Something looks "fishy" to me, but as I'm not sure what the primary keys are I may be incorrect. If red indicates a primary key, then you have 2 relations with the same primary key and Client No appears as a non-key attribute 2 relations with different keys!
BTW, it would help if you named each relation so that we could refer to them by name. R1, R2, R3 would do.
clients contracts are based at a office. so many clients can be based at the same office. and only one client can have many contract numbers and many job id's . where do you think i should go from here then?
I don't know. What does R3 mean now? Each Office can have only 1 contract?
The trouble is (I think) you are reacting to each feedback comment from me in a piecemeal way, reposting your modified solution here within seconds almost. You need to slow down and review your full set of relations against the original relations and FDs, and verify them.
A primary key means: every other attribute in this relation is functionally dependent on this key. So it is easy to compare FDs and relations to see if they agree:
r3 is needed to show which clients are based at which office. i have now changed that to this. i have also changed relation 2. i got a little confused there as i though this was the offices details but it's not it should be the clients details. it looks alot better now and i think it's in 3NF and BCNF. please can you check this for me. p.s i am very greatful for your help- i do feel i am learning