answersLogoWhite

0


Want this question answered?

Be notified when an answer is posted

Add your answer:

Earn +20 pts
Q: What is structural dependence in a database?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Does the network model has structural level dependence?

yes it is


What is the difference between data dependency and structural dependency?

Structural dependence-Access to a file depends on its structure i.e. adding customer date-of-birth field to customer file require the five steps described in slide 29. the reason for this is that the file structure is coded within the programData dependence-Changes in database structure affect program's ability to access data i.e. changing field from integer to decimal required changes in all the files. the reason for this is that the file data characteristics are coded within the program.


What are roles and structural constraints in DBMS?

so it role is basically to manage the database


What is a structural dependence?

A file system exhibits structural dependence, which means that access to a file is dependent on its structure. For example, adding a customer date-of-birth field to the CUSTOMER, Given this change, none of the previous programs will work with the new CUSTOMER file structure. Therefore, all of the file system programs must be modified to conform to the new file structure. In short, because the file system application programs are affected by change in the file structure, they exhibit structural dependence. Conversely, structural independence exists when it is possible to make changes in the file structure without affecting the application program’s ability to access the data.


What is structural dependence?

A file system exhibits structural dependence, which means that access to a file is dependent on its structure. For example, adding a customer date-of-birth field to the CUSTOMER, Given this change, none of the previous programs will work with the new CUSTOMER file structure. Therefore, all of the file system programs must be modified to conform to the new file structure. In short, because the file system application programs are affected by change in the file structure, they exhibit structural dependence. Conversely, structural independence exists when it is possible to make changes in the file structure without affecting the application program’s ability to access the data.


What is design view used for?

Its used when actually building or editing the operational, visual or structural content of the database being used/built


What tasks are included in database maintenance?

Back Up Database Task Performs different types of SQL Server database backups. Check Database Integrity Task Checks the allocation and structural integrity of database objects and indexes. Execute SQL Server Agent Job Task Runs SQL Server Agent jobs. Execute T- SQL Statement Task Runs Transact-SQL statements and more


Is dependence the base word for codependence?

Yes dependence is the base word for co-dependence.


Can you give example sentences for the word dependence?

His dependence on his mother handicapped him in a relationship. She regretted her dependence upon his advice.


What is Possession of a drug of dependence?

Having a drug dependence is an addiction.


Is there a physical dependence of LSD?

No, there is no physical dependence associated with LSD.


When was Legg's Dependence created?

Legg's Dependence was created in 1760.