7. Database Systems Flashcards
1
Q
What is a Flat File Database
A
A flat file database is a database where all the data is stored in a single table.
+ Easy and quick to create
+ Can be made in non specialist software
- lots of data duplication
- all users see all data saved in the table (security)
2
Q
What is a relational database?
A
Relational databases split data up into smaller tables that are linked together
- more complex to create and maintain
+ removes repetition of data
3
Q
What is a primary key and a foreign key?
A
A primary key is a unique identifier for a specific record.
A foreign key is any field in a table which is the primary key in another table.
4
Q
What is database views
A
A database views allows a number of tables and records to be restricted so only certain users can see certain sets of data.