Database Terminology
Across
- 3. the principle of spreading large and complex tasks over a number of computers or servers.
- 5. a program specifically written to be used in a distributed processing environment
- 8. a method of creating a database using tables of related data, with relationships between the tables.
- 9. a set of attributes and tuples, modelling an entity (a table).
- 13. a set of entities that contain no redundant data.
- 16. a specialised programming language for manipulating databases
- 17. a visual method of describing relationships between entities.
- 19. a generic term for large or complex datasets that are difficult to store and analyse.
- 24. an attribute that can be used to uniquely identify every record within a table
- 25. in database modelling, it is an entity
- 26. an object, person, event or thing of interest to an organisation and about which data are recorded.
- 27. an item of data.
- 28. an attribute or set of attributes which uniquely identifies a tuple.
Down
- 1. a way of implementing a database where the database is put into a server and various users can access it from their workstations. The processing, for example, running a query, will take place on the server
- 2. a technique used to produce a normalised set of entities in a database.
- 4. the process of ensuring that a relational database is structured efficiently
- 6. an attribute in one table that is a primary key in another table.
- 7. a method for implementing an entity and attributes as a group of related data.
- 10. an association or link between two entities.
- 11. the location where values will be stored, calculated from the key
- 12. a software system that enables the definition, creation and maintenance of a database and which provides controlled access to this database.
- 14. an object about which data will be stored.
- 15. in a database graph schema, it refers to the link and relationship between two nodes.
- 18. a structured collection of data.
- 20. a combination of attributes that uniquely identifies a tuple/record.
- 21. a technique to temporarily prevent access to certain records held on a database
- 22. a method of defining a database in terms of nodes, edges and properties
- 23. a search or sort carried out on data that retrieves the answer to a question.