Databases

What types of data tables have you used?

Difficulty: unrated

Source: bregman-arie/devops-exercises by Arie Bregman

Answer

  • Primary data table: main data you care about
    • Details table: includes a foreign key and has one to many relationship
    • Lookup values table: can be one table per lookup or a table containing all the lookups and has one to many relationship
    • Multi reference table