Iowa State Programming Language Written In C and SQL Server 2012 Discussion
Question Description
Problem statement:
In Iowa, you can only register your vehicle in your county of residence. A proposed change to the
law would allow you to register your vehicle in any county adjacent to your county of residence.
For example, Story County is adjacent to Hamilton, Hardin, Boone, Marshall, Polk and Jasper
counties, therefore Story County residents would be able to register in these adjacent counties.
Each of the 99 counties is assigned a number used as part of the National Atlas of the United States.
Details regarding the number assigned to a county and adjacency can be found at:
https://en.wikipedia.org/wiki/List_of_counties_in_Iowa.
Objective:
A) Implement a method which takes as parameters two integers and returns a Boolean result
which is true if the counties are adjacent to one-another.
B) Implement one of the following:
1) A Windows Form which prompts the user for the input parameters and displays the results
of the adjacency method.
2) A WPF which prompts the user for the input parameters and displays the results of the
adjacency method.
3) A classic ASP (.asmx) web service which executes the adjacency method.
4) A WCF (.svc) web service which executes the adjacency method.
C) The program should use a relational data store. The data store should use stored procedures to
access any data. Design the data store and any stored procedures needed.
Objectives “A” and “B” should be written in C#, targeting the most recent release of the .Net
Framework. Objective “C” should be written in SQL Server 2012 or a more recent release. There will be
no impact on score with regard to which option is chosen for objective “B”.
Deliverables:
1) A Visual Studio solution file containing a project or projects which implement objective “A” and
“B” above.
a. The solution file should be formatted for Visual Studio 2012, 2013, or 2015.
2) One of the following for objective “C”:
a. A collection of SQL files (.sql) for each SQL schema object designed.
b. A SQL Server Data Tools database project (.sqlproj) for Visual Studio.
3) Data import scripts describing the scenario specified in the problem statement. For the sake of
brevity of the exercise, Story, Greene and Tama counties are required to return accurate results.
There will be no impact on score with regard to which option is chosen for deliverables “1” and “2”.
State any other assumptions you have in your documentation.
“Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results.”
