|< < 23 > >|

The Relational Model of Data

• A table represents an entity type or relationship.
• Each column represents an attribute or relationship.
• Each column type is simple.
• Each row represents an instance of an entity type or relationship.

That's all.

Example: Movie

Let's use the previous definition:

• title: string
• year: integer
• mpaa_rating: string
• running_time_minutes: integer
• release_date: date
• rating: fixed(3, 1)
• rating_votes: integer
• main_image_link: string
• main_trailer_link: string

|< < 23 > >|