below is a question i saw somwhere


I am developing a personnel system which will have a master table for the employee information and a lot of lookups that describe his relegion, gender, qualification, degree, work unit, department and more ...
suppose we have the same structure for the lookups (i.e
code , desc)

please I would appreciate it very much if you provide the cons and pros for having all the lookups in one table or seperate them more than one (performance
of the reports , data entry etc...).


can somebody tell me what's master table and look up and
give me an example about it. when and how to develop it.