SQL databases
NoSQL
SQL databases are good if you need a warehouse with organization and structure, and heck, if you need more room, you can build another wharehouse next to your exsisting warehouse.
NoSQL is like a light speed rail, a lot of traffic and sometime seems chaotic but it handle all the taffic.
a row in table A can have many matching rows in table B. But a row in table B can have only one matching row in table A. https://learn.microsoft.com/en-us/office/troubleshoot/access/define-table-relationships
A primary key generally focuses on the uniqueness of the table. It assures the value in the specific column is unique. A foreign key is generally used to build a relationship between the two tables. The table allows only one primary key. https://byjus.com/gate/difference-between-primary-key-and-foreign-key/
In normalization, columns are assigned to tables in such a way that each business fact is stored only once, or in other words, a table should not contain duplicate data. https://www.sciencedirect.com/topics/computer-science/normalized-schema#:~:text=In%20normalization%2C%20columns%20are%20assigned,should%20not%20contain%20duplicate%20data.