Is new table required?

[Anand Vaidya]

There's a Prospects table which stores the details of all the prospects in
US.(US operations).Now my senior wants me to design similar form for Indian
operations.Almost all the fields for US operations and Indian operations are
same except 5-6 fields.Do I need to take another table for Indian operations
or should I add these 5-6 fields to the same table which is used for US
operations?

 

[Allen Browne]

Use one table.

If records belong to one or the other (Prospects or Indians), you can add an
extra field to keep track of which is which.