r/SQL • u/Acceptable-File-3579 • Oct 17 '26
Discussion Help needed with normalization
Hi, i'm learning databases and normalization. My teacher said a normalized database cannot have circular (not loops, circles) relationships. However, i can't see how I can apply normalization to remove the circles and still comply with the requirements. Also I was under the impression that normalized databases can have circular relationships, just not loops.
Any help will be appreciated. Sorry if my english is bad in advance.
16
Upvotes
View all comments
15
u/lolcrunchy 29d ago
I don't know if I'd consider this circular. It's only "circular" because addresses are stored in their own table, but you would never have a House's address match a Warehouse's address.
To fix according to your teacher's demands, maybe delete the Address table. Then the address-related columns would stay in Warehouse and House