Atomicity and Aggregation in Database

Question

Hi!!

Can someone tell me what exactly do these two terms mean?

Answer 1

Atomicity is the condition where either all the actions of the transaction are performed or none. So, this means that, when there is an incomplete transaction, the database management system itself will undo the effects done by the incomplete transaction.

Aggregation is the concept of expressing the relationship with the collection of entities and their relationships.

Comments

I have trouble understanding aggregation.

Could you please explain it through example

---

Hello @Mansoor,

You can refer this to understand aggregation with example:https://swcarpentry.github.io/sql-novice-survey/06-agg/index.html