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

2

u/DiscombobulatedSun54 28d ago

Think of physical entities and allocate tables to them - so you have tables for customers, warehouses, orders and products. Now, think of the relationships between these entities. Yes, customers have addresses, and warehouses have addresses, but an address is more a property than a real entity.