Relational database design tutorial (on kirupa)

great new tutorial on relational database design. something i need to get a handle on.

after initially reading through it, i had one question. Once you have a relational database system like the one in the tute, how do you pull everything (SQL) that relates in one easy query? i imagine you must have to string a bunch of queries together to get everything together from the different tables? Or do the ‘joining’ SQL queries in the tute make it so that it all works harmoniously?

i feel stupid.

thanks for any input y’all.