Forum

What is the best wa...
 
Notifications
Clear all

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


(@elias)
Illustrious Member
Joined: 5 months ago
Posts: 4277
Topic starter  

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


   
Quote
(@elias)
Illustrious Member
Joined: 5 months ago
Posts: 4277
Topic starter  

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

   
ReplyQuote
Share: