There are four types of schemas in databases. So, the task of creating a schema is different, depending on which type of schema you have been asked to create. The diagram that shows the plan of all of the objects that will go into a database is called a schema. You create that with a drawing tool – this is the Logical Schema. The space that contains all of those objects is also called a schema – this is an industry term that describes the workspace that holds a database. Different DBMSs offer different methods to create that type of schema.
The mapping between the database and the physical storage is called the Physical Schema and that is usually generated by the DBMS when it sets up a schema for holding tables.
The mapping between a front-end that gives access to the database to users and how that relies on the logical objects in the database is called the View Schema. That is usually created by a systems analyst as part of the spec to pass to a programmer.