It looks that you already have a database design. The first thing is to decide how are you going to access this database. You have many choices here. For example you could use an ORM such as NHibernate or Linq to Entities. If you think that using an ORM for such a simple database schema would be an overkill you could also resort to plain ADO.NET and write the SQL queries yourself. Even in this case it is recommended to setup an object model that will reflect your database schema.
The next step is to write the data access layer. Usually this consists of two parts: an abstraction (interface) and implementation (concrete class) for a given data access technology you picked up in the first step.
Then you write a controller that will talk to this repository and fill a view model. This view model is then passed to the view to be displayed.