Across
- 1. In computer data processing, it is a collection of data items arranged for processing by a program.
- 3. It is used to describe physical or social aspects of the world in an abstract way. For example, in the realm of software development, a conceptual model may be used to represent the relationships of entities within a database.
- 5. It is a data storage format that can contain a specific type or range of values.
- 6. It is another word for question. One type of query, which many people perform multiple times a day, is a search query. Each time you search for something using a search engine, you perform a search query.
- 7. A property or characteristic of an entity.
- 8. Short for character. Any letter, number, space, punctuation mark, or symbol that can be typed on a computer.
- 9. It refers to a floating-point number that contains floating decimal points. For example, 0,001.
- 10. It stands for “Binary Large Object” . It is used for storing information in databases.
- 12. In mathematical sets, it is also called the empty set, is the set that does not contain anything.
- 14. To say officially that a place or thing has a particular character or purpose.
- 16. It is a unique identifier for a database record. When a table is created, one of the fields is typically assigned as the primary key. While the primary key is often a number, it may also be a text field or other data type.
- 18. In database systems, an IDX is a data structure defined on columns in a database table to significantly speed up data retrieval operations.
- 19. It is a data structure that organizes information into rows and columns. It can be used to both store and display data in a structured format.
- 21. It is a specific date and time “stamped” on a digital record or file. While most often used as a noun, the word “timestamp” can also be a verb.
- 23. It is a column or columns of data in one table that connects to the primary key data in the original table.
- 24. It is a design pattern in computer science, used with languages that provide a run-time type information about objects.
Down
- 1. It is a database model that stores data in tables. Most of databases used in modern applications are relational, so the terms “database” and “relational database” are often used synonymously.
- 2. It is a horizontal group of values within a table. It contains values for multiple fields, which are defined by columns. Because rows contain data from multiple columns, in databases, each table row may be considered a record.
- 4. It is a whole number (not a fraction) that can be positive, negative, or zero.
- 8. It is a vertical group of values within a table. It contains values from a single field in multiple rows.
- 11. A Boolean variable, one whose value is either true or false.
- 13. Also known as logical data model. It identifies entities, attributes, relationships, domains and defines what each instance means. The logical data model is the architect or designer view of the data.
- 14. It is a data structure that stores organized information.
- 15. It is a field, or combination of fields, in a database table used to retrieve and sort rows in the table based on certain requirements.
- 17. The logical data model is used as the blueprint of what data is involved while this data model details how that data will be implemented.
- 20. In relation to a database, it is a single person, place, or thing about which data can be stored.
- 22. This term in database design has to do with counting tables and values. Cardinality between tables can be one-to-one, many-to-one or many-to-many.