7. Database Systems Flashcards

You may prefer our related Brainscape-certified 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)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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.

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