Should I write a test case for every Foreign key in the database?
Our team is conducting a large database migration project using Java APIs, for eg. inputting CustomerSales.
And we have ProductId, VendorId, StoreId, MailCarrierId, etc.
So we are writing test cases for every foreign key column, ensuring if foreign key exists or incorrect. This will lead to 8+ foreign key cases. Its like we are retesting if Microsoft SQL Server knows to enforce its database keys constraints and foreign keys.
Is that the correct methodology? If so, We will have hundreds of foreign key cases for every table we migrate, not just CustomerSales.