I was reading the concept of normalization of database structure. I got confused with the following situation in my project.
- I have two tables "
- Both tables are independent of each other and have no realtionship at all
- They represent completely different data
- Both the tables will have different parameters. However
Parameteritself as an object has same properties.
So my concern is should I have single
Parameter table which is serving
I should have separate
Parameter Table for both
Table A and
Structure look likes this
TableA ID Name Description TableB ID Name SomeFlag Parameter ID TableA_ID TableB_ID Name Description Type
TableA ID Name Description Parameter_A ID TableA_ID Name Description Type TableB ID Name SomeFlag Parameter_B ID TableB_ID Name Description Type
I personally prefer Case I, as it does make sense to create another table representing same type of data.
As per normalization's concept we should have a table that represents only one thing. So i guess i should have only one parameter table. But what if that table mean something completely different when viewed from TableA and different when viewed from TableB?