This question is related to subtype of Entities…
I have One Table has two fields – Field1 & Filed2…
Now Data will be entered in this table which will be like this…
Field1 Field2
Data_key1 Data1
Data_key2 Data2
Data_key3 Data3
Data_key4 Data4
Data_key5 Data5
Now User will select one of them, n I have to maintain detailed record of each Data which will have different fields of different data types…
e.g.
Data1_Table
Field11 Char
Field12 Number
Field13 Date
Field14 Currency
Data2_Table
Field21 Boolean
Field22 Char
Field23 Date
Field24 char
Field25 Currency
Field26 Byte
Field27 Number
Filed28 Number
etc…
So I have to maintain record of data fields which will be a data of Master table….
So how should i design tables n maintain a relationship between this…? n i have to consider a normalisation also which should not create a updation/insertion or deletion anamalies while manipulating with a data in future…
If anyone have solution abt this, plz reply me soon on yogesh@sadhanwebworks.com
Thanks in Advance…
Yogee.