Hello all,
I Need Your opinion on my first DataBase Design
I want to design a Generic database in which all fields will be controlled by database values.
for example:= i need to insert
hospital detail : Hospital Name,Adress,zipCode etc.
Insurance Detail: Company name, PhoneNo etc.
.
.
.
for that i am taking one table Name Provider which will Be Some Thing Like This:
ID ProviderName FieldName
1 Hospital Name
2 Hospital zipCode
3 Insurance Companyname
4 Insurance PhoneNo
Second Table Will Take the valued Related To Upper Table:
ProviderId Value
1 Hospital1
2 111111
1 Hospital2
2 222222
and with the help of Pivot it will display some thing like this
Hospital1 111111
Hospital2 222222
Am i Write ?? or there is any better approach Or if there is any Tutorial related to this that will be appreciate
Thanks and Regards,