How am I supposed to link a database to the site?

I’m given a year end project to design a dynamic site. I’ve worked with Visual studio and dreamweaver before. Can you help me in making sure that my site is effective and user friendly?