In this post I will determine how many DB tables does each option you choose make.
Lets start with NODE, make a basic node, with just title and body, when we enter data for it, it will populare 6 tables.
1. node
2. node_revision
3. node__body
4. node_revision__body
5. node_field_data
6. node_field_revision