Database Tutorial

Course Tutorial Site

Site Admin

Articles

without comments

Week 4: Articles

The articles for this week focus on mandatory and optional relationships between rows in two tables or two copies of the same table. The shore version of mandatory and optional relationships are:

  • A mandatory relationship requires that you provide a valid foreign key value before inserting a row in a table with a dependency on a parent table.
  • An optional relationship lets you insert a row in a dependent table without associating it with a row in the parent table. This type of relationship is possible because there are generally other foreign keys that prevent the row from becoming an orphan in the data model.

Articles

Written by michaelmclaughlin

August 11th, 2018 at 3:18 pm

Posted in