Foreign key in sql with real project Examples | Referential Integrity | Why use Foreign keys
Foreign keys are used to join parents and child tables , the keyword references and foreign key are used to define it.
It ensures that data which is not present in parent table is not allowed in child as well
1. It can lead to performance issues in specific cases
2. What happens if we try to delete records from parent table which are present in child
3. What are table locking issues because of foreign keys
4. what is on delete cascade and on delete set null
5. What are late arriving dimensions
and much more is discussed in this video
#techcoach #SQL #ForeignKeys