I realize I am a little late to the game on this one, but since no one has answered you, I figured I may as well give it a shot!

My advice to you would be to use the NorthWind DB as a template. It does everything you are describing and more and you can tailor it to your needs.