Apply these in Visual Studio. (Methods, Decision Structures(i.e. if/switch statements), Exception Handling(i.e. try … catch), Variables, and Input Validation patterns.) SQL And Table


You are a Solutions Architect at a Software Consulting firm in Chicago, IL. Your company is interested in building a prototype of an IT Help Desk web application that will be eventually handed over to your offshore developers to complete.Your company prefers to use Microsoft technologies.Your company plans on building the iOS and Android versions of the App in the future.

Your final working PoC must exhibit the following features:

1.Ability to Register as a New User

2.Ability to Login after registering as a user

3.Ability to Create a new Help Desk ticket (for an authenticated user)

4.Ability to Search and View a list of Help Desk tickets sorted by the most recent

5.Ability to view detailed information about a Help Desk ticket on a Ticket Detail page

O The Status of the Ticket (i.e. “To Do”, “In Progress”, “Done”)

O Ticket Category(i.e. “Infrastructure”, “Application”, “Database”)

O Name of the user who entered the ticket

O A description of the issue

O The date and time when the ticket was last updated

6.Ability for a user to change the status of an existing ticket


The Proof-of-Concept (PoC) application must be

implemented using the following technology stack: ASP.NET / C#, SQL Server.

NOTE: Your SQL Server database file must reside in your “App_Data” folder in Visual Studio.

To receive full credit, your final output must exhibit knowledge of: Methods, Decision Structures(i.e. if/switch statements), Exception Handling(i.e. try …catch), Variables, and Input Validation patterns.


1.Identify and list all the User Stories described in this business scenario

2. Identify and list all the Acceptance Criteria for at least 3 of the User Stories in this scenario

3.Provide a Sequence diagram or Swim Lane diagram or Activity diagram to show all the interactions between End Users, Web Pages, and the database

4.Provide a Software Architecture diagram for this scenario (with support for future Mobile Apps)

5.Provide a complete normalized logical data model (using Crow’s Foot notation) to support this Web Application

6.Build the database. All tables in your application must have a prefix of your first name (e.g. John_Moviesfor the Moviestable). You are not required to create all the tables identified in the ERD. However, you must manually populate the database tables with enough data to test all the features in your App.

7.Using C# and ASP.NET, build all the web pages in this PoC scenario. Provide the full working prototype code and associated database files (including.aspx,.aspx.cs, .mdb, .web.config). Your PoC code must be as database-driven as possible. Provide information on how to test your App

8. Name the ideal software development life cycle necessary for completing the final implementation of this project. Justify your recommendation

9.In no more than 1 paragraph, reflect on what you learned in this class and summarize how your newfound knowledge or appreciation for applications development will support you in your future career path.

You must complete all 9 steps and provide the required artifacts to receive full credit Instructions for the Deliverables:

-The prototype must be a web site with a SQL Server database back-end

-Your zipped file must include at least 1 database file in your “App_Data” folder, as well as all the “.aspx”, “.aspx.cs” and “web.config” files.

Provide an accompanying Word or PDF document containing all the non-programming sections of the project