Can you create more than one table in the same database?

Each entity within your business would be represented using a table inside your database which would be your common repository to store all business data. Each table based on its purpose will have a key defined ideally to act as a unique identifier for the row and also columns to represent various attributes within your entity.

A table is created by using CREATE TABLE statement and exact syntax may vary lightly based on the type of database used i.e like Oracle, SQLServer, MySQL etc