Section 10 Flashcards
What is a Relational Database?
A method of creating a database using tables of related data, with relationships between the tables.
What is a Table?
A method for implementing an entity and attributes as a group of related data.
What is an Entity?
An object about which data will be stored.
What is an Attribute?
A characteristics or piece of information about an entity, which would be stored as a field in a relational database.
What is an Entity relationship diagram?
A visual method of describing relationships between entities.
What is a Primary key?
An attribute that can be used to uniquely identify every record within a table.
What is an Entity identifier?
An attribute which can uniquely identify each instance of an entity.
What is a Foreign key?
An attribute in a table that is a primary key in another table and us used to link tables together.
What is Normalisation?
The process of ensuring that a relational database is structured efficiently.
What is Structured query language (SQL)?
A specialised programming language for manipulating databases.
What is Syntax?
The rules of how words are used within a given language.
What is a Query?
A search or sort carried out on data that retrieves the answer to a question.
What is a Client-server database?
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.
What is a Database management system?
Software that enables the management of all aspects of a database including adding, updating and querying data.
What is Record locks?
A technique to temporarily prevent access to certain records held on a database.
What is Sterialisation?
A technique to ensure that only one transaction at a time is executed from multiple users on a database.
What is Timestamp ordering?
A technique to ensure multiple users can execute commands on a shared database based on the timestamp of when the data was last written to or read from.
What is Commitment ordering?
A technique to ensure concurrent transactions on a shared database are executed based on a the timestamp of when the request is made and also the precedence the request takes over other simultaneous requests.
What is Big data?
A generic term for large or complex datasets that are difficult to store and analyse.
What is Modelling?
Recreating a real life situation on a computer.
Graph Schema (database)?
A method of defining a database in terms of nodes, edges and properties.
What is a Node (database)?
In database modelling, it is an entity.
What are properties (database)?
In database modelling, it is items of information stored within each each entity.
What is an Edge (database)?
In a database graph schema, it refers to the link and relationship between two nodes.
