Q:

Which opensource database satisfies all these requirements? 

Supports C API for reading and writing into the DB. 
Support ACID transaction feature. 
Support sending notifications if any change happens to DB state. 

Finally it should be an open source. 
Could someone suggest a open source database which supports all these above features. 

A:

Postgres supports those features.