databases 1 Flashcards

1
Q

whats a database

A

persistant organised store of related data

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

entity

A

a real world thing we store data on

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

attribute

A

characteristic of an entity

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

types of relational databases

A

one to one , one to many , many to many

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

primary keys

A

A primary key is a unique identifier for each record in the table

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

secondary key

A

an attribute normally given to fields in which indexing is useful

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

foreign key

A

a primary key in another table.

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