I cannot help you with analyzing the data in your database. You need to read on integrity constraints to understand them. This will allow you to research your problem and fix it effectively. This is the link to the documentation on integrity constraints and how they work: http://download.oracle.com/docs/cd/B..._int.htm#i6686

Please, fix your shift key & stop using phone text message style when asking questions.

Sergey