Databases Flashcards
What is a relational database?
A relational databases is where data is stored in multiple linked tables.
In a relational database, each of the relations contains data about one particular entity.
Any duplicated data in a database is known as redundancy.
A flat-file database is where data is stored in a single table.
Benefits of a relational database
Same data isn’t included multiple times, lead to fewer inconsistencies and so less chance of mistakes being made.
Less space is required when storing similar data to what is already being stored.
Entity Relationship Diagram
An entity is a single object or thing of interest to an organisation and about which data are recorded.
Every record in a relation needs to have a unique identifier.
Database Terminology
Table- a collection of data that relates to an entity (students).
Record- A collection of data about a single entity (student).
Field- a unique piece of data about an entity (student surnames).
Field Name- an identifier for the single piece of data. (“surnames”).
Primary Key- a unique field to identify a record.
Why are databases normalised?
- Minimize the chances of data being duplicated.
- Saves storage/ memory space as less data is needed to store the information.
- Faster/ easier to query