Few years back we had a discussion in Quora regarding NOSQL and SQL. The Question that was put up was: SQL give us the advantage structured approach and ACID(atomicity, consistency, isolation, durability) while noSQL give us the advantage of more FASTER operations, Scalability, no SQL required and data can be put over in any manner you want. But how to decide over on what to choose at what time? Does SQL is like Read More ...
Let’s start with structured data, which is really data that is organized in a structure so that it is identifiable. The most universal form of structured data is a database like SQL or Access. For example, SQL (Structured Query Language) allows you to select specific pieces of information based on columns and rows in a field. You might look for all the rows containing a particular date or ZIP code Read More ...
In simple terms: Database anomalies are the problems in relations that occur due to redundancy in the relations. These anomalies affect the process of inserting, deleting and modifying data in the relations. Some important data may be lost if a relation is updated that contains database anomalies. It is important to remove these anomalies in order to perform different processing on the relations without any problem.
