Click here to Skip to main content
15,112,199 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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,
Posted
Updated 21-Nov-13 7:53am
v4
Comments
Nicholas Marty 21-Nov-13 7:54am
   
Are you sure you need a generic database? Often those who use the db or change the configuration isn't the developer who implemented it and they might make mistakes causing lots of work for them and for you troubleshooting the problems. I'd recommend to avoid generic databases if it isn't really necessary...
R. Giskard Reventlov 21-Nov-13 9:47am
   
Are you Henry Chao? :-)
Maciej Los 21-Nov-13 12:57pm
   
Who is Henry Chao[^]? ;)
Maciej Los 21-Nov-13 13:28pm
   
USA and Poland have got the same problems. Our healthcare system is dying because of bad money distribution ;( and bad investment into IT systems (corruption).

1 solution

Have a look at this book for some ideas ... earlier editions had good reviews
database+design+for+mere+mortals[^]
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900