Sql-Server DataBase Design

See more:

SQL-Server

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,