programming language written in c and sql server 2012

/in /by

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.

 
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"