ASP.NET Project. Long term relationship

Upload test project [general] The purpose of this example project is to choose right candidate for the longer term relationship. You should know basic concepts of technology we are using and web development in general but it is not necessary that you know each and every detail nor have a solution for each and every problem. That's what the team and experience is for. What is important is that you're open-minded for learning and cooperation. At the moment we have one biggerproject that we want to extend with some features. Technology we use is: - ASP.NET MVC 4 project type - C# programming language & .NET v 4.5 - MS SQL 2012 Server for DB (with stored procedures, thus Transact SQL) - C# programming language - jQuery/html5 for UI logic Application is developed as multi-layered application. Perfect candidate is a junior programmer willing to correspond with the team on daily basis. There will always be someone to ask a question if you have any problem during development. That part is crucial. It is required that you are able to commit fulltime to this project. Test project [specs] Test project involves creating small documents upload module. There are 2 tables in DB: Projects table and Users table. There are many columns but important ones are: Projects table columns: Id (int, autoincrement) ProjectName (nvarchar(200)) Users table columns: Id (int, autoincrement) Username (nvarchar(20)) What needs to be done is: Enable users to upload files to the system Users should be able to upload files to the system. Since every uploaded file will be related to project, users should be able to select the project from projects list (on upload form). Also, users should be able to write the comment with each uploaded file. System should also save what user uploaded the file and at what time. This maens that we need one more tables in DB: Documents (where uploaded files detailes will be saved). You should propose solution for that also. Enable users to list all uploaded documents per project When browsing projects (that screen already exists), user should be able to list all documents for selected project. At the moment, we want to distinguish between word, excel and pdf files so we would like to show an icon for each document based on file type. For all operations you should use stored procedures. In your first response give us your general idea how would you do it. Describe each step: - DB tables stucture - Stored procedures for create/list uploaded documents records - Application code No code is required for this step. After that we will ask you to give us some code examples of particular solution for your idea and discuss it. Chosen candidate will then get the new private project assigned, bid on it and implement the full-blown solution.