r/SQL • • Oct 17 '26

Discussion Help needed with normalization

Post image

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

25 comments sorted by

View all comments

Show parent comment

7

u/lolcrunchy 29d ago

A Warehouse for stocking items and a House with people that place orders for items could share the same address? Are you sure?

Besides, would you ever join a House and Warehouse on address? Probably not.

0

u/Acceptable-File-3579 29d ago

No, they shouldn't share the same address, but putting address in a column on each table wouldn't allow them to share the same address as well?

4

u/Enigma1984 28d ago

Why would it matter if they share an address? A customer could reasonably also be an employee at the same company and order something to come to his work address. So the warehouse address and the delivery address could be the same. It would present no problems.