One Resource Table

One Resource Table Using one resource table method is similar to many lookup tables. The difference is this one resource table actually combines all lookup tables by adding just one more field. Of course, this one resource table will be much larger because it combines all lookup tables. Using back the same lookup tables at Read more about One Resource Table[…]

Hardcoded Values vs Lookup Tables

Hardcoded Values You have a form, say, a registration form. In this form, you have these common fields, example Name, Age, Address, State, Country and etc. So, in your database design, how do you go about it? Create just one table to store all these fields? Something like below? ID Name Age Address State Present_Country Read more about Hardcoded Values vs Lookup Tables[…]