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.