how to manually add a node in drupal 7 in the database
Because you are trying to understand Drupal database concept, you are checking every insert you made in the Drupal admin section, and by doing so Drupal is caching your data.    

So you are not missing anything. You only need to clear Drupal cache, try to truncate each cache table one by one.