ITAP3010 Developing Data Access Solutions Project

Student ID:

Full name:

ITAP3010 Developing Data Access Solutions Project

Weightage: 25%

Due date: Fri Lesson 12 5:00 PM

Late penalty applies on late submission, 10% per day would be deducted

0 mark for LATE Submission more than one week

0 mark for DUPLICATED Submission or Shared Work

You will be marked based on your submitted WORD DOCUMENT file on Moodle. You are most welcome to check your file with your lab tutor before your submission. No excuses will be accepted due to absence from lecture or lab classes where details of lab requirements may be given. Please make sure that you attend Lec/Tut EVERY WEEK as low attendance may result in academic penalty or failure of this unit.

ITAP3010 Developing Data Access Solutions Project

The purpose of assignment is to assess students on the following 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
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

Total: /25 marks

READ THE FOLLOWING GUIDELINES CAREFULLY AND UNDERSTAND ALL REQUIREMENTS BEFORE STARTING THIS PROJECT

Project Submission

Your submission will contain a zip folder which should include:

1. A word document (PDF will not be accepted) outlining the steps you used to create your VS project as well as the outputs by taking screenshots.
2. Your full MS Visual Studio project folder.

Put (1) and (2) together in one zipped file called ID_Fname.

Please be clear that the unit coordinator will not be responsible for a student who is unable to submit successfully working copies of files in their submission. The student will have no further chance to submit files or receive any remarking, if this is the case. Make sure you have fully tested your application before zipping and submitting. Your submission will be unzipped and placed into the marker’s folder directory for marking, so keep this in mind.

If there is any exceptional case where a student’s project is unable to be marked, which should not occur, the project will be marked out 10 and the student will receive this mark out 10 as the final mark.

You will submit the zipped file at the “Project folder on Moodle”. This form is shown to you when you click on “Project” from the Assessment area. The form page contains the terms and conditions of the project such as declaring that you have not plagiarised, have kept a copy of your work, etc. In uploading and submitting your zip file, you are agreeing to these terms and conditions, which you are being bound by in submitting work for the project and receiving a mark for it.

Resources:

Create a Windows Forms app in Visual Studio with C#

Developing Data Access Solutions Project

1. 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.

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

1. Customer registration (Figure 1)
2. Issue Transaction (Figure 3)
3. Find by customer ID (Figure 5)
4. Update country (Figure 6)
5. Movies (Figure 7)

Figure 1 Customer registration form using tabbed form.

3. 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.

4. 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.

5. 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.

6. 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.
7. Your “On Load” program should look like the form below (see Figure 4).

Figure 4 On load program.

Figure 5 Find details by customer ID form.

Figure 6 Update country form.

Figure 7 Movies form.

Figure 8 Updated country form with a combo box.