4
votes
3answers
161 views

What is a good rule-of-thumb for naming link-tables?

In the same way that a publication table might relate to a person table via subscriptions, or a company table might relate to a person table via employee, I'm wondering if there is a descriptive way ...
1
vote
1answer
820 views

How to begin writing a relational SQL database [closed]

I was wondering about how databases like MySQL and SQLite are developed to run as quickly and as well as they do. I'm looking for answers to questions like: How is SQL token-ized? Do you build an ...