The Relational Data Model

 

 

Columns corresponds to fields or attributes of entities

Each row represents an entity with a record

Information is not duplicated in other tables

Notice that the ORDER and the PART table both contain a "PART-NUMBER" field

Notice that the PART and the SUPPLIER table both contain a "SUPPLIER-NUMBER" field

These common fields can be used to easily combine information from different tables