What do you mean by "Schema" in Database management system?
What is schema?
The schema is basically
the structure of the database to show in a logical and physical type of
database structure in database management system. The schema is necessary to
use in the database technology to understand the structure of database. Where
in the logical level the schema express their logical terms in the structure of
schema and in the physical level show their connectivity of the database and
other network or conjunction of the computer system in the physical level. So,
there are two types of level of schema to define the structure of the database
in a different level or categories.
Schema in database
In this post I have to discuss about the introduction of Schema of database. Here are the points about schema in database given below.
- The schema is a skeleton structure of database.
- Schema shows overall structure of data items.
- It also shows overall data and records and their relations in the form of skeleton structure which are stored in a database.
- The schema describes the structure of the whole database.
- It is also defines the characteristics of all records.
- It also describes the future required fields and characteristics of the records.
- It is a time consuming structure to create for database.
- It is better for design a database structure and at the starting it is very careful to create the structure of database.
- When creating the structure you can necessary to neglect the modification of future fields or attributes. The modification of fields or attributes in the database takes it later to create.
Comments
Post a Comment