Task Management System

Greetings, I have read initial requirements and let me assure you that our .NET team is VERY strong, as we have done few very bigger and complex Applications, so technically you won't have any issues. Here's answer to all your questions, even though they are very basic questions we ask employees in their interview to hire :), I cannot answer in detail, because there are character limitations in this initial message board: 1) How would you establish a many-to-many relationship in a database. LEADconcept: A many-to-many relationship refers to a relationship between tables in a database when a parent row in one table contains several child rows in the second table, and vice versa. 2) What are indexes,? what is the diff between clustered-index and non-clustered index. LEADconcept: An index can be created in a table to find data more quickly and efficiently. A clustered index actually describes the order in which records are physically stored on the disk, hence the reason you can only have one. A Non-Clustered Index defines a logical order that does not match the physical order on disk. 3) How can you improve query performance? LEADconcept: There are many ways to improve the query performance, i.e .Re-writing SQL Query, Avoid Multiple Joins in a Single Query, Eliminate Cursors from the Query, Avoid Use of Non-correlated Scalar Sub Query, Drop Unused Indexes, using joins instead of subqueries etc.

Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the very first instance. After seeing our quality of work and the cooperation offered to you even after the work has been delivered to you, you’ll come to us again and again to avail our services. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I can achieve the results that you are asking for within your timeframe and budget. I am confident I can exceed your expectations and I would love to work on your project. Thanks, Priyanka

Hi, I have gone through your descriptions,I am 5+ years experienced Visual Basic,VB.NET,ASP.NET,C#,Telerik,SQL,MSSQL Server(2005 to On wards) developer at CMMI-5 level company.I can do your job easily before your deadline . I can give you the proper steps which will be followed by the Application Development stage. I am very much Interested to do your work,Please revert me if you have any concern.

A proposal has not yet been provided

A proposal has not yet been provided

Hi, I am a professional with 12+ years of experience in design and development of web and enterprise applications for distributed Client/Server Real Time Systems. Strong knowledge of Object Oriented Analysis/ Design and Development, Database Concepts, mainly Enterprise Web Applications using ASP.Net,C# & SQL Server. The answer to your questions are as follows: 1) How would you establish a many-to-many relationship in a database. A: By using a third table to maintain the relationship data. Lets say of a user can have multiple roles then we use a new table called user role to store the user & role mapping. 2) What are indexes,? what is the diff between clustered-index and non-clustered index. A: Index are addresses to the data rows & values. clustered index is the one which is created upon creation of primary key and it contains the actual node address. Non clustered index are the one which we can create using commands. 3) How can you improve query performance? A: There are many ways to do this. By checking the cost of query and identify its weak points (the one which are using more resources) and rectify them. By creating indexes on frequently used fields etc I look forward to hearing from you. Thank you for your consideration. Regards S Ravi Kumar

A proposal has not yet been provided

Hello, I am very much interested in this project. Following are some of the reasons to hire me: 1. 15+ years of software development experience. 2. 10+ years of experience in .NET/ASP.NET. 3. Solid understanding of programming principles. 4. Good written/verbal communication skills. 5. Excellent track record (5/5 ratings). 6. Can work independently without any supervison. To answer your questions: 1) Many-to-many relationship can be acheived by adding another table. If there is a User and Courses table, if an User can signup to multiple Courses and a Course could consist of mutliple Users, then we need to introduce another table User_Course, which will have primary key of both the tables. 2) Indexes are data structures used to speed up data retreival from a table. Clustered index works by sorting and storing the rows in the table based on the index key. There can be only one clustered index per table as it is not physically possible to store a table based on sorting of mutliple columns. Non-clustered index just stores the index key in another structure that is not physically linked to the table. So there can be multiple non-clustered indexes per table. 3) Query performance can be imporved by using indexes. Thanks for your time and looking forward for your reply!! Regards, Bala

Hi, I have more than 10 years of experience in developing .net applications and around 7 years in web development. I have very good experience in asp.net MVC 4.0 and its related technologies like, JQuery, JQuery UI, CSS, Entity Framework. Also, well versed in pl/sql and T-sql. worked in all technologies mentioned except Telerik controls. Regarding your questions, 1. Many-to-Many Relationship- Assume that we have Task and employee entities. And each task can be worked by many employees. Similarly, an each employee can be part of multiple tasks. So relationship between employee and task is Many-to-Many. It will be represent in following tables a. Employee- employee id will be primary key b. Task-Task id will be primary key c.employee_task- primary key is composite of employee_id and task_id columns. 2. Index- indices are used to retrieve the results quickly. Clustered Index- DBMS uses b-tree to implement index. In Clustered index, the structure is physically ordered. So, A table can have only one clustered index. Leaf Node of clustered index will have actual record. Non-Clustered Index- A table can any number of non-clustered indices and leaf node has a pointer to actual record. 3. we can follow these suggestions to improve the query. 1. Select statement should have only required columns. Avoid using * 2. Should not have table scan in the execution. Amend the query to use index. 3. Partitioning the high volume table 4. Parallelize the query thank you, ramesh kumar c

I have used all the technology you are required for this project and i already done same type of project and user login details.

Hello my name is Dennis Valverde, I have a work team with experience in web and mobile development, native applications in Android and iOS, hybrid apps using PhoneGap. On web side, we have experiencie both frontend and backend development, including technologies like HTML5, CSS3, Javascript, Responsive Design, ASP.NET, PHP frameworks, Wordpress etc. My initial proposal is 20 dollars per hour. We need to check the requirements of your app and your budget to consider a official price. We are a group of developers with 3 years of experience in different companies and now we are founding our own company, Go-Labs. We are very interested in your project. Don't hesitate in contact me if you have a question. Thank you, Dennis Valverde

A proposal has not yet been provided