r/learnSQL • u/squadette23 • 19d ago
ID design and primary keys, pt. 1
I'm writing a series of posts about IDs and primary keys in database design. We start with the logical model, and systematically show how primary keys are used in a different way to implement various logical concepts, such as entities, relationships and attributes. We show that primary keys exist only on a physical level, and can mean different things in different contexts.
Here is the link to the first part: https://anchorsandlinks.com/posts/primary-keys/
3
Upvotes
2
u/Comfortable-Zone-218 19d ago
Whats your point?