Relational Model

Question 1

A relational database consists of

Answer 1

a collection of tables each with a unique name

Question 2

Terminology: Relation

Answer 2

same as table

Question 3

Terminology: Tuple (or Record)

Answer 3

same as row or record
a record is a group of related attributes
identifiable by its primary key (or candidate key)

Question 4

Terminology: Attribute (fields or columns)

Answer 4

same as column or field, a field is used to store an individual item of data

Question 5

In relational database, no two rows with same values in all ________ positions

Answer 5

column

Question 6

All values within a column in a relation have the _______ type

Answer 6

same;
simple type only
no complex values such as sets or other rows

Question 7

Candidate Key

Answer 7

candidate key is an attribute or combination of attributes that uniquely identifies rows in a table

Question 8

Primary Key

Answer 8

there can be more than one candidate from which the primary key is chosen

Question 9

foreign key

Answer 9

an attribute or combination of attributes that match attribute(s) in another table