what is database schema?

what is database schema?

A database schema is the skeleton structure that represents the logical view of the entire database.

The term "database schema" can refer to a visual representation of a database, a set of rules that govern a database, or to the entire set of objects belonging to a particular user.

The database schema of a database system is its structure described in a formal language supported by the database management system (DBMS).

database schema is skeleton structure which describes about the visual view of structure table like the table creation with column name and its tuple.

Agreed completely.

Originally Posted by yatishkumar

The term "database schema" can refer to a visual representation of a database, a set of rules that govern a database, or to the entire set of objects belonging to a particular user.

Database schema represents the logical structure of the entire database..it defines how the data is organized and how the relations are among them are associated..

A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of aschema as a container of objects. You can assign a user login permissions to a single schema so that the user can only access the objects they are authorized to access.

The term "schema" refers to the organization of data as a blueprint of how the database is constructed (divided into database tables in the case of relational databases). The formal definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a database.

A database schema is the skeleton structure that represents the logical view of the entire database.A database schema defines its entities and the relationship among them. It contains a descriptive detail of the database, which can be depicted by means of schema diagrams.....

Nice explanation.

Originally Posted by Ashley234

The term "schema" refers to the organization of data as a blueprint of how the database is constructed (divided into database tables in the case of relational databases). The formal definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a database.

Thanks For Your Information.

Very well described. Thanks For Your Information.