Week 8 Topic – Working with Data – Lookup Tables

Topic – Working with Data – Lookup Tables

Look-up tables are something you can never escape in real database design. This week we will look at 2 different methods to handle lookup tables. The required reading demonstrates that the debate over methods to handle the lookup table is still ongoing.

Reading

This is a forum posting – you can see some of the debate of different ways to handle lookup tables – http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67090

Lectures

Lecture – Lookup Tables Part 1

Assignments

Week 8 Assignment