Across
- 3. Key: A column or set of columns in a database table that refers to the primary key of another table, establishing a link between them.
- 8. to Many Relationship: A relationship where one record in one table can be related to multiple records in another table.
- 9. Integrity: Ensures that each row in a table is uniquely identified, usually through a primary key.
- 10. Key: An index or key that is used for data retrieval but is not the primary means of identification for a record.
- 12. Also known as a record, it represents a single entry in a table, containing a set of related data.
- 15. Integrity: Ensures that data values in a database conform to defined rules or domains.
- 17. Type: A classification that specifies the type of data a column can hold, such as text, numbers, or dates.
- 18. Management System (DBMS): Software that provides an interface for interacting with databases, managing data storage, retrieval, and manipulation.
- 20. Database System: A database system that uses the relational model for organizing and managing data.
- 21. Files: A simple data storage format where data is stored in plain text with a structure that has no hierarchy.
- 22. – Structured Query Language: A domain-specific language used for managing and manipulating relational databases.
- 23. An auxiliary data structure that enhances the speed of data retrieval operations on a database table.
- 24. A vertical arrangement of data elements within a table, representing a specific attribute of the data.
- 25. number: A feature that automatically generates a unique number for each new record in a table.
Down
- 1. Integrity: Ensures that relationships between tables remain consistent and valid, typically enforced through foreign key constraints.
- 2. Key: A unique identifier for a record in a table, ensuring each row can be uniquely identified.
- 4. to One Relationship: A relationship between two tables where each record in one table is related to only one record in another table.
- 5. A request for information from a database, typically expressed in SQL.
- 6. Key: A primary key composed of multiple columns to uniquely identify a record.
- 7. A user interface component used for entering, editing, and displaying data in a database.
- 11. A structured collection of data organized for efficient retrieval, management, and updating.
- 13. A sequence of instructions that automates repetitive tasks in a database.
- 14. Model: A database model that organizes data into tables with relationships, based on mathematical set theory.
- 16. to Many Relationship: A relationship where multiple records in one table can be related to multiple records in another table.
- 19. A two-dimensional structure within a database that consists of rows and columns, used to organize and store data.