Creating an Example Web Services Project.
There are many tools and frameworks that can be used to build web services. We will follow the ASP.NET MVC framework for our project this week and future projects.
This walkthrough assumes that the .NET development environment has already been set up on your computer (what we did in Assignment 3 which is SSMS and VSC download). Now, we build a Derby database and then services needed for our Mobile apps (see script file in this folder) – you will need to execute the script in SSMS; this will create the Derby database on your computer. For this assignment:
Download/Save the script file to a known location on your computer
Start SSMS, connect to your local server (this is your local computer name), then Open a Project/Solution
Locate/open the script file provided (will see the script content in the SSMS program pane)
Highlight all of the script lines, then click;Execute
Let the script finish execution completely – after successfully executing this script
In the SSMS Object editor pane, see a new Derby database created
Expand Derby then right click Database Diagrams to create a new Database Diagram
Highlight two tables (DerbyNames and Leagues) and Add
Make two screenshots; one that shows the script completed successfully and one that shows the new Derby database diagram (which looks like the one in Figure 3-1, page 43). Submit these two screenshots as deliverables for Assignment 4.