Modeling Object Relationships

Summary of Video

This video shows an example of modeling relationships similar to that used on object oriented programming. It also demonstrates the modeling of a many to many relationship and how using on object oriented relationship hierarchy can reduce the complexity of the object relationships.

Prerequisites

You should have a good knowledge of relational databases and use of SQL.

Video Link

Support Materials

Mapping Objects

This is an excellent article on how to map different types of data with various structures into database tables. The article covers multiple approaches with easy to follow examples.