Search code examples
sqlpostgresqlforeign-keysdatabase-normalization

foreign keys and normalization

Can a table have multiple foreign keys and each foreign key have a different parent table? Does it violate any design or normalization rule?

Solution

  • A table can most certainly have several foreign keys. This does not violate any normalization rule.