What is the CRUD model in a database?
C : Create - When the user "saves" any new transaction or information to the database.
A : Retrieve - When the action of 'Search' or 'View' the information stored in the database is carried out by the user.
U : Update - when, the operation is performed to "update" the information in the database. Usually when 'edit' or 'modify' an existing user record.
D : Delete - when the user 'deletes' or deletes a system log.
This does not matter at all that what database you are using, much less the programming language you use to connect a database or if you have performed a correct database normalization ; The end user does not have to worry about the sub-queries, whether a trigger exists or a stored procedure.
A : Retrieve - When the action of 'Search' or 'View' the information stored in the database is carried out by the user.
U : Update - when, the operation is performed to "update" the information in the database. Usually when 'edit' or 'modify' an existing user record.
D : Delete - when the user 'deletes' or deletes a system log.
This does not matter at all that what database you are using, much less the programming language you use to connect a database or if you have performed a correct database normalization ; The end user does not have to worry about the sub-queries, whether a trigger exists or a stored procedure.
Comments