SLR 10 Databases Flashcards
What is a database?
Organized collection of data that allows for easy:
- Adding
- Modification
- Deletion
- Searching
What makes up a database?
Tables
Records
Fields
What is a flat file database?
A simple database with a single table. Suitable for small amount of details.
What is a relationship?
A relationship is a link between two tables
What is a relational database?
A relational database is a database that has multiple tables. For example, a student table and a tutor group table.
What are the pros of a relational database?
They remove repeating data, therefore making it quicker to query.
What is a primary key?
A primary key is a field that makes each record uniquely identifiable. For example, a student ID.
What is a foreign key?
A foreign key is only needed when a table has a relational link to another table. The foreign key is the field that connects the two tables. For example a students tutor group field is the foreign key as it connects it to the tutor group table.
