Structural dependence vs Structural independence in Database

Structural dependence vs Structural independence in Database

 

Structural dependence  vs Structural independence  in Database

Structural Independence

Structural independence exist when changes in the database structure do not affect DBMS ability to access data.

Structural Dependence 

 Structural dependence exist when changes in the database structure affect DBMS ability to access data.

File System exhibit Structural Dependence   

A file system exhibit structural dependence because a change in any file structure such as(addition or deletion of a field) require modifications of all programs using that file.

File System exhibit Data Dependence

A file system is said to exhibit data dependence because a change in any file's data characteristic such as changing the field from integer to decimal requires changes in all data access programs. That means access to a file data is dependent on it's data characteristics.

 

Hierarchical Database Model does not support Structural Independence.

Hierarchical Database Model does not support structural independence.