1
Q
Flat File Database
A
- Info is held in a single table.
- Column = Attiribute.
- Row = Record.
- Only useful for small amounts of data.
- Larger tables = more chance of data redundancy.
- Easier to create, maintain.
2
Q
Relational Database
A
- Most commonly used.
- Allows efficient processing.
- Data seperated into tables; each one stores data related to one entity.
- No multiple record changes needed.
- All records have a link to that entry that will show the change.
- Better security/ Confidentiality.
3
Q
An entity
A
- Represents a real world object.
4
Q
Primary Key
A
- A field that is a unique identifier for a record.
5
Q
Foreign Key
A
- A PK from another table that links the tables together.
6
Q
Index
A
- Data structure that shortens the length of time it takes to search a database.
7
Q
Entity Relationship Diagram
A
- Defines the relationship between tables in a relational database.
8
Q
Authorisation Levels in Databases
A
- Usernames/passwords allow for the system to limit their view of the records.
- Data protection.
- Simplifies access.
- Improves performance.
- Prevents unauthorised edits.
- Users restricted from running queries, deleting records, altering the structure.
