What is the best way to store relationships in a database?

Question

1 Answer

Most popular tags

Dear All, These are my answers from Quora and primarily Google; please check the answer and from others sites; the answers are free and without any liability.To make a decision, write down all of the positives and negatives on a piece of paper.Thank you, Elias Katsaniotis, MSc.

EKatsaniotis · Answer 1 · 2022-08-05T16:09:28+0000

You must perfom anslysis and have some results, one set of results is the LDS (Logical Data Structures) or Tables.

You have

to normalized the db in 3rd normal form
to create master - detail tables, like orders - orders details
to create keys primary and foreigns
to create linker tables

What is the best way to store relationships in a database?

Your answer

1 Answer

Categories