Computer Science & IT – B.Tech, BCA, BBA, MCA, M.Tech Best Online Coaching Institute

Schema, Subschema and instance

Schema

Schema is used to describe logical database and tell how the data is organized and how relation among them is associated. In other words it is the physical arrangement of the data as it appears in the DBMS. A database schema is plan for a database system and describes the relationship between the entity and attribute. It includes the definition of the database name, the record type and the component that make up the records. It is sometimes called as overall model of the data a conceptual model or conceptual schema. A database schema is a meta-data that means data about data and it describes the relations in a database. It is simply say as the “layout” of a database or the blueprint that describes the way data is organized into tables. The language used to describe the schema is Structured Query Language and CREATE statements is used (more…)

This content is restricted to site members. If you are an existing user, please log in. New users may register below.

Existing Users Log In
 Remember Me