Relational Database Model

Relational Database Model composed of ?

• Rows

• Lines

• Columns

• Poles

• Attributes

Two-dimensional structure composed of rows and columns

• Tuple

• Attribute

• Table

• Row

• Column

What is table ?

• Two-dimensional structure

• An entity set

• Persistent relation

Creator of Relational Model

• Codd

• Vodd

• Rodd

• Todd

Each row/column _____ represents a single data value

All values in a/an _____ must conform to the same data format

• Table

• Column

• Row

• Attribute

_____ key is an attribute (or a combination of attributes) that uniquely identifies any given entity (row)

Types of keys

• Primary Key

• Composite Key

• Super Key

• Candidate Key

• Foreign Key

A Super Key without redundancies

• Primary Key

• Composite Key

• Super Key

• Candidate Key

• Foreign Key

Composed of more than one attributes

• Primary Key

• Composite Key

• Super Key

• Candidate Key

• Foreign Key