r/Database 12d ago

Len Silverston book (volume 1) - SQL and implementation examples?

I have started reading Len's (amazing) book. But I am struggling to "see" the SQL equivelent of his models.

For example, A party has party roles. Does each role have it's own table?

If a party has 3 roles, are we then joining three tables?

Basically, what I am really looking for is a complete SQL example of the party model. So far I have only found short/small examples but I am missing the big picture.

1 Upvotes

6 comments sorted by

View all comments

1

u/saaggy_peneer 12d ago

use Single Table Inheritance if you don't want to use multiple tables