Insert more than one data in a table/entity

[Lia Brand]

I am writing a database program in netbeans with GUI, but I have some problems. It's a crime database and as you know there are several entities like victims, suspects, witness, etc. Each of these entities have their own tables in the database (I am using Oracle). But as you also know, a crime can be committed by one or more person. I don't have a problem if the crime is committed by a person, I can easily input the data, but if it's two or more, I have no idea. How do I add a whole new data for the same entity for the second suspect? Where will the data be stored? And how do I do that? I really have no idea.

Thanks in advance.

[K. Tsang]

Welcome to the Ranch.

Crime database ... cool. First you need to understand the database structure and relationship. Making a entity-relationship (ER) diagram for the DB is a good starting point.