Databases Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

What is a relational database?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Benefits of a relational database

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Entity Relationship Diagram

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Database Terminology

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Why are databases normalised?

A
  • Minimize the chances of data being duplicated.
  • Saves storage/ memory space as less data is needed to store the information.
  • Faster/ easier to query
How well did you know this?
1
Not at all
2
3
4
5
Perfectly