Databases i - Introduction Flashcards
1
Q
Database
A
Organised collection of data.
2
Q
Flat File Database
A
Single table database
3
Q
Relational Database
A
Collection of data items with pre-defined relationships between them; organized in columns and rows.
4
Q
Primary key
A
Attribute(s) make each row unique.
5
Q
Foreign key
A
Used to link tables
6
Q
Entity
A
Object, person, event, thing etc.
7
Q
Atrribute
A
Describes the characteristics of an entity.
8
Q
Entity Relational Diagrams
A
Graphically showing the relationships between entities.
One-to-One
One-to-Many
Many-to-Many
9
Q
Flat File positives?
A
Simple to design
Requires little design knowledge
All records stored in one place.
10
Q
Flat File negatives?
A
Duplicate Data - each instance must be updated
