Informatics Practices
What is data independence?
Relational Database
2 Likes
Answer
Data independence is the ability to change the schema at one level of a database system without requiring changes at a higher level. This is achieved through metadata, which follows a layered architecture, ensuring that changes to data at one layer do not affect data at another layer. A database system provides two types of data independence:
- Logical/Conceptual data independence
- Physical data independence
Answered By
2 Likes
Related Questions
What is data redundancy? How can it be controlled?
What is data abstraction? What are the different levels of abstraction?
Give the terms for each of the following:
(a) Collection of logically related records.
(b) DBMS creates a file that contains description about the data stored in the database.
(c) Attribute that can uniquely identify the tuples in a relation.
(d) Special value that is stored when actual data value is unknown for an attribute.
(e) An attribute which can uniquely identify tuples of the table but is not defined as primary key of the table.
(f) Software that is used to create, manipulate and maintain a relational database.
Why foreign keys are allowed to have NULL values? Explain with an example.