8 Databases

Question 1

Entity

Answer 1

Anything that can have data stored about it, for example a person, place, event or thing.

Question 2

Table

Answer 2

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

Question 3

Record

Answer 3

A row in a table in a database

Question 4

Field

Answer 4

A column in a table in a database

Question 5

Tuple

Answer 5

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

Question 6

Attribute

Answer 6

An individual data item stored for an entity. For a person, it could be name or date of birth.

Question 7

Primary Key

Answer 7

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

Question 8

Candidate Key

Answer 8

An attribute in a table where no tuple has the same value

Question 9

Secondary Key

Answer 9

Candidate key that is an alternative to the primary key.

Question 10

Foreign Key

Answer 10

A set of attributes in a table that refer to the primary key in another table.

Question 11

Referential Integrity

Answer 11

Property of a database that does not contain any value of a foreign key that is not matched to the corresponding primary key.

Question 12

Indexing

Answer 12

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

Question 13

DBMS

Answer 13

Database Management System. A system software for the definition, creation and manipulation of a database.

Question 14

SQL

Answer 14

Structured Query Language. The standard query language used with relational database for data definition and modification.