Question

what is scheme definition in data independence?

Answer 1

Data independence in the context of DBMS architecture means that applications and users are offered an interface to the data that provides a logical view on their data that shields them from the way this data is actually physically organised in memory. For example, in an RDBMS the database shows you the data as relations, sets of records, but the actual storage structure might be quite different and involve additional indexes, clustering and/or sorting the data, vertical and/or horizontal decompositions of the data, et cetera. The benefit of this is that the physical organisation can be changed, for example to speed up certain queries, without having to change the queries and updates that applications send to the database


BE SMART ^_^

Answer 2

Data Independence. The ability to modify a scheme definition in one level without affecting a scheme definitionin a higher level is called data independence.