‘Describe the four actions involved in data management?
The four actions, often abbreviated as CRUD, are the creation of data, the retrieval of data, the modification or updating of data, and the deletion of data. We use DBMS tools like DDL and DML to create data. In a database system, it is important that data retrieval be fast and efficient. This can be achieved through efficient query design and through optimized DBMS query execution. Updates to data must not leave the database in an inconsistent state; the DBMS must provide facilities to check constraints that follow business rules. Care must be exercised when deleting data. The DBMS needs to allow for the possibility of preventing a deletion if there are dependent data in the database in order to preserve database consistency.