Hello, every body:

I have a urgent situation. Now we are setting up the production database. I have 50 tables in the schema. Now somebody suggest adding primary keys and foreign keys to almost every table. That mean there will be about 40 primary keys and 40 foreign keys. I also created indexes on most of the tables based on queries.

I do not think we should add all the foreign keys. We are OLPT system. I think the foreign keys can help us a little and they are expensive. For example, the foreign key on Customer.customerId just make sure whenever the user add the entries to other tables his cutomerId should be found in customer table. We use codes to add entries, get information.

I think the disadvantage with the foreign key is more than
advantage. How about it?

Could you tell me your consideration?

We must make decision by today' noon.

Thanks.