Developing By Me

Project Development and Design


    Creating a new database schema is very easy to do. But creating a schema is only the start. The syntax to create a schema is “CREATE DATABASE new_database”. The database schema is a container that will hold a listing of tables. The schema also records all of the relationships and constraints between the different tables. Depending on the RDBMS there may be a limit to the number of database schemas available. There are typically two to five schemas in any database system. In a three schema configuration, the schemas are typically main which holds most of the data, logs which handles error and activity tracking, and temp which holds temporary tables. This is not the only configuration since some systems house all of this information in one schema and others may use separate schemas for each aspect of the system.