DEV Community

Discussion on: Is it possible to reference one column as multiple foreign keys? ( PostgreSQL )

Collapse
 
joelbonetr profile image
JoelBonetR 🥇

To understand properly what @aarone4 said (which is correct) you may be interested in learning about Database Normalization, 1NF + 2NF + 3NF + Boyce-Codd is enough for the major part of targets if not every one you will use.

Those are a set of rules to use when designing DB models and relations and as you get skilled with them you'll define models that are directly compliant with those NFs, meanwhile just start with UNF (Unformalized Form) and proceed adding NFs one after another in this order (1NF, 2NF, 3NF, BCNF).

Best regards

Collapse
 
jacksonkasi profile image
Jackson Kasi • Edited

thanks 😊