Mid SQL

Lookup Table Pattern:?

  • This pattern helps to normalize the data when you have a set of static values

used repeatedly across the database.

  • Example: A Country table that contains a list of country names, which is

then referenced by other tables like Customers or Employees.

More from SQL Server Tutorial

All questions for this course