Re: Inserting data into related tables
The only data that should "go" from User to Order is the userID.
Leave everything else (like the user's Name) in the User table and join to the Users table, using the userID, as and when you need that extra data.
Duplicating data from one table to another is a big "No-No" in Relational Databases. You ideally want a single source of Truth for each piece of data.
Regards, Phill W.
Subject
Written By
Posted
September 06, 2022 11:02PM
Re: Inserting data into related tables
September 07, 2022 05:03AM
September 07, 2022 11:13AM
September 07, 2022 11:22AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.