It has to do with database design. Determines the structure of how data will be stored.
Copy of the actual data. It's easy when it comes to data recovery. However, it has disadvantages such as difficulty in consistent data processing, waste of storage space, and reduced data efficiency.
It means maintaining accuracy and consistency throughout the lifecycle of data. In other words, it is not polluted data. This means you can use the data as it is entered.
This error occurs when there is no logical consistency.
If there are two ID values of 519, Then change the 519 address, you don't know what to change.
Occurs when inserting data fails. Because of when a specific value as NULL.
When specific data is deleted, other data also deleted together.
Includes the CREATE command used to create a table, and the DROP command used to drop a table.
The language used to store data in the database. Includes INSERT, DELETE, and UPDATE.
Includes commands related to database access rights. There are GRANT and REVOKE.
It is a command that can be query. for example SELECT.
Commits the work to the database(COMMIT), or there is a rollback function such as ROLLBACK.