Sample Header Ad - 728x90

3NF normalized table design

0 votes
2 answers
165 views
I am struggling with how to normalize a database where there is multiple addresses pr. user. The situation is that a user can have both a regular address and a delivery address. When a user make an order, one of the addresses should be connected to the order. I am trying to achive a 3NF normalization. So i will store the addresses in a junction table, should i add an primary key to user_addresses table and use that in fk_address_id column in orders table? or would that be breaking the 3NF? What i am basically trying to do is to make it possible to make an order with a diffrent address. enter image description here
Asked by Soma Juice (111 rep)
Jan 31, 2024, 09:12 PM
Last activity: Jan 31, 2024, 11:41 PM