ITAP3010 Developing Data Access Solutions Project

Learning Outcomes

LO 1	Describe advanced features and concepts of database design and data access solution development
LO 2	Model data using standard framework and use advanced queries across different data types
LO 3	Identify and implement data services and data access techniques over the web
LO 4	Perform data synchronisations and manage transactions
LO 5	Deploy and monitor data access applications to help increase reliability

Marking guide:

Note: This Marking Scheme is used as a guide only to the final grade, and rubric will be created upon.

Criteria (used as a guide only)	Level of Performance
Criteria (used as a guide only)	0	1	2	3	4	5
Created database with the mentioned tables
All 5 forms created and shown “On Load”
Screenshots of forms
Buttons are used to involve some business functions / validation and data access
Used Entity Data Model, ADO.NET or Lambda to implement the data access functions representing various button clicks

Resources:

Create a Windows Forms app in Visual Studio with C#

Developing Data Access Solutions Project

This project is developed to check the coding skills of the students. Use Dafesty script to create the database required for this project. Explain the key features of the Dafesty database design.

Create forms as listed below. Use “tabbed form” (see Figure 1) or “Menu” to develop all the forms.

Figure 1 Customer registration form using tabbed form.

Modify the Customer Registration form that allows the admin to add, update, delete and search customer records from the database. Also provide the first, last, next and previous buttons to see all the data that is already present in the database as shown in Figure 1.

Create a form as shown in Figure 2 which allows the admin to find customer details by Customer ID. Note the output below is a sample output.

Figure 2 Find a record.

Create the form for Issue Transaction like the form shown below. The form should display Issue Transaction details in a grid view. The admin should be able to sort the data by Transaction ID. The admin should be able to order the data in ascending or descending order.

Figure 3 Issue transaction form.

Modify Country form to include have a combo box for Country (see Figure 8). The combo box should have a list of countries. The admin should be able to select a country from the combo box and click on the update button to update the country of that particular Customer. Also provide a next and previous button to go through the data.
Your “On Load” program should look like the form below (see Figure 4).