There should never be more tables in a database than the database design requires and there should never be less. This means that the answer to your question is "Yes" to both options and "No" to both options depending on the database design for any given application.
