DavJes wrote:
Please just guide me to learn how to do DB design and webservice architecture
Can't give more pointers on webservices than the book I mentioned. I've listed some resources on database-normalization, which would be the preferred design IMHO.
MSDN[^], explains up to rule #6
MSDN[^], tips
Wikipedia[^], with examples and explanation. (Links halfway details on every step)
SqlMag[^] has a nice introduction on the topic, as well as a link that explains when normalization should be skipped.
Personally, I don't go all the way, just upto BCNF. It's boring and tedious stuff to learn and apply, but I wouldn't recommend it if the advantages don't outweigh the disadvantages; the result will be more confidence in the model used, fewer design-errors, and within a few tables you'll be normalizing your structures without effort. The reason I recommended Mannings' SOA patterns[^] is because it focuses on the most-used patterns; a pattern is a proven and reusable solution, and that's always a nice thing to have in any architecture. I also recommend it because I read and enjoyed it myself :)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]