1 | 12 | ||||||||||||||||||||||||
17 | |||||||||||||||||||||||||
2 | |||||||||||||||||||||||||
3 | |||||||||||||||||||||||||
10 | 4 | 18 | |||||||||||||||||||||||
5 | |||||||||||||||||||||||||
11 | |||||||||||||||||||||||||
6 | 15 | ||||||||||||||||||||||||
14 | 16 | ||||||||||||||||||||||||
7/13 | |||||||||||||||||||||||||
8 | |||||||||||||||||||||||||
9 | |||||||||||||||||||||||||
1. A relationship where a single entity can be associated with multiple entities.
2. The process of selecting a course of action or making a choice based on available data and information.
3. A technique used in distributed databases to divide the data into smaller subsets or partitions, which are then stored on different nodes in the network.
4. Values that are substituted into the SQL parameter query at runtime.
5. The accuracy and consistency of data throughout its lifecycle.
6. Verifying the integrity of data by checking its calculated checksum.
7. A detailed diagram that includes attributes and primary keys for each entity in a database
8. A set of rules and symbols used for communication and expression.
9. The integrity constraints that enforce valid data entry for a given column, ensuring that values meet specified criteria.
10. A type of data validation that verifies if the value is in the correct format or follows a specific pattern.
11. A DDL query used to change the name of an existing table.
12. A set of properties that ensure database transactions are processed reliably in a relational database system.
13. A type of data validation that confirms if a value meets a specified length requirement.
14. A clause in SQL that allows you to retrieve only rows from a table that meet specified criteria.
15. The property that ensures transactions are executed in a way that they are unaware of each other.
16. A DDL query used to add a new column to an existing table.
17. The process of organizing data in a database to reduce redundancy and improve data integrity.
18. The structure that defines the organization of data within a database.