Each site has its own set of tables. This is achieved through the use of different table prefixes.
Sites can either have their own database or share a database with other sites. The decision on which option to use depends on expected traffic. Most sites can share one database without problems, but if you expect very high traffic it may be wise to use a separate database.