Thank you so much for your response. But i could hardly understand ur first paragraph.
I have even discarded my first plan and came up wit a better plan. At this stage all i need to do is to put up an UML model to submit. and my prospect is im looking at a Police database e.g a small county that has OFFICERS TABLE, UNITS, CRIMAINALS, CRIMES, COURT TABLE. It would be like each officer belongs to a unit, i.e bike patrol, traffic warden, narcotics etc.
Each criminal will have a procecuting officer, crime ID, etc, COURT will have juristiction, etc,
Hope you understand what i mean.
Now i need a complete table with attributes as well as their relationships.
Hope its much clearer now.