Advantages Anomalies in Relational Model
- Data Integrity: Relational databases enforce data integrity through various constraints such as primary keys, foreign keys, and referential integrity rules, ensuring that the data is accurate and consistent.
- Scalability: Relational databases are highly scalable and can handle large amounts of data without sacrificing performance.
- Flexibility: The relational model allows for flexible querying of data, making it easier to retrieve specific information and generate reports.
- Security: Relational databases provide robust security features to protect data from unauthorized access.
Anomalies in Relational Model
Anomalies in the relational model refer to inconsistencies or errors that can arise when working with relational databases, specifically in the context of data insertion, deletion, and modification. There are different types of anomalies that can occur in referencing and referenced relations which can be discussed as:
These anomalies can be categorized into three types:
- Insertion Anomalies
- Deletion Anomalies
- Update Anomalies.