Schema and Instances
Schema and Instances Definition of schema : · Schema is the overall design ( structural view (design) ) of the entire database. · Not show the data of relation (tables). · Not changed frequently. · Schema is three types: Physical schema, logical schema, and view schema. · For example: In this diagram schema sh…
Read more
DATA INDEPENDENCE IN DBMS
DATA INDEPENDENCE IN DBMS · Data independence is described by the three-tier schema architecture. · When we modify the schema at one level then other level schemas are not modified or changed. · Helps to keep data separated from all programs which used it. · Stored data is used for calculating and presentation. Levels …
Read more
The comparison among the record based data models in dbms
The comparison among the record based data models in DBMS HIERARCHICAL MODEL NETWORK MODEL RELATIONAL MODEL It organizes records in form of the tree structure. It organizes records in form of directed graphs. It organizes records in form of tables. Only one to one (1:1) and one t…
Read more
Social Plugin