Comment by rajeshamara

1)Have stored procedures with parameters for all you backend transactions 2)Make sure you have foreign key constraints between tables 3)Log everything so that you can track 4)Daily backup your db so that you can restore in case something happens 5)Create primary keys for each table 6)For all you order make sure if is between transaction and roll back in case of failures 7)After successful, payment transaction, send out email notification to the end customer. You can cc yourself too. Again this if for auditing purpose. What I came up is a very quick list. Again you need to thoroughly analyze your req. and come up appropriate solutions