I am developing a small to medium size e-commerce web site for which I need to create a network structure. I don't have much experience creating network structure even though I know fairly enough about configuring routers and firewalls.
How should I create the network structure? I was thinking of having my web server behind a firewall with port 80 open. Then, route any database request to a second firewall/router on the network through the port on which the database would be working. This way, the business tier server would be at a higher level in the network than the data tier server. Would this be a reasonable network configuration approach to implement and protect the data?
I will be using microsoft product such as small business web server, sql server express and visual studio.
Please, I would appreciate any inputs and thoughts. Thanks.