8 Databases Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

Database

A

A structured collection of items that can be addressed by different applications programmes

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

Relational database

A

A database where the data base items are inclined by internal data pointers

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

Table

A

A group of similar data , in a database, with rows from each instance of an entity and columns for each attribute

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

Record

A

A row in a table in a database

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

Field

A

A column in a table in a database

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

Tuple

A

One instance of an entity, which is represented by a row in a table

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

Entity

A

Anything that can have data stored about it e.g and event, thing, person

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

Attribute

A

An individual item stored for an entity, for example a person could include attributes like name, date of brith

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

Candidate key

A

An attribute or smallest set of attributes in a table where no tuple has the same value

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

Primary key

A

A unique identifier for a table. It is a special case of a candidate key

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

Secondary key

A

A candidate key that is an alternative to the primary key

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

Foreign key

A

A set of attributes in one table that refers to the primary key in another table

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

Relationship

A

Situation in which one table in a database has a foreign key that refers to a primary key in another table in the database

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

Referential integrity

A

Property of a database that does not contain any values of a foreign key that are not matched to the corresponding primary key

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

Index

A

A data structure built from one or more columns in a database table to speed up searching for data

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

Entity-relationship diagram (E-R)

A

A graphical representation of