Showing posts from December, 2021Show all
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
inSUBJECTS
DATA INDEPENDENCE IN DBMS
DATA INDEPENDENCE · Data independence is described by the three-tier schema architecture. · When we modify the schema at one level then other level schemas are not modify or change. · Helps to keep data separated from all programs which used it. · Stored data is used for calculating and presentation. Levels of Datab…
Read more
Social Plugin