Relational Databases (SQL) Flashcards
What is a primary key?
A unique identifier for each record
What is a record?
A row (sideways)
What is a field?
A column (horizontal)
What is a field name?
The name of the field/column at the top of the table
Why are fields used?
To store a specific piece of information - name or address
What does a record do?
Uses fields to store details about a specific item
What a foreign key?
A field that references the primary key of another table
What is a flat-file database?
A database which stores all the data in one table - easy to set up and understand
What are relational databases?
Databases made up of multiple tables linked together using primary and foreign keys
What is data redundancy?
Having the same piece of data stored in multiple places
What is data inconsistency?
When the same data exists in different formats in multiple tables - typo or incorrect format
