GENERAL DIRECTION:

$1.$ The format for the submission folder will be $$CPE$106-$FOPI$01-$SURNAME$-$MOD$-3.$

$2.$ Source code of the WPF application below with the sub$-$folder name $$QUIZ$-$WPF$-3.$

$3.$ SQL Script of the database, tables and store procedures below with the sub$-$folder

name $$QUIZ$-$DB$-3.$

$4.$ Video presentation of the WPF application together with integrated database below with

the sub$-$folder name $$MP$-3.$

WPF APPLICATION $($STUDENT MAINTENANCE$)$:

Please locate your module $1$ exam $($WPF Application$)$ and module $2$ exam $($SQL Server Database$).$

Kindly save and retrieve records of your WPF application into SQL Server Database. The following

application must satisfy the following requirements below:

$1.$ The application must have a main menu that allows the user to choose his$/$her action.

$2.$ When the user selects $$Exit$$ menu, the application will exit or will be terminated.

$3.$ When the user selects $$Person$$ menu, the screen will display submenu for person

maintenance.

a$.$ When the user selects $$Add Person$$ submenu, the application allows the user to add

person record $($last name, given name, middle name$).$

b$.$ When the user selects $$Edit Person$$ submenu, the application allows the user to edit

person record $($last name, given name, middle name$)$ by person id$.$

c$.$ When the user selects $$Delete Person$$ submenu, the application allows the user to

delete person record $($including student record$)$ by person id$.$

$4.$ When the user selects $$Student$,$ the screen clears and will display submenu for student

maintenance.

a$.$ When the user selects $$Add Student$$ submenu, the application allows the user to

add student record to existing person $($student number, program, year$)$ by person id$.$

b$.$ When the user selects $$Edit Student$$ submenu, the application allows the user to

edit student record $($student number, program, year$)$ by person id$.$

c$.$ When the user selects $$Delete Student$$ submenu, the application allows the user to

delete student record only $($not including person record$)$ by person id$.$

$5.$ When the user selects $$View All Records$$ menu, the application allows the user to view all

person with or without student records $($last name, given name, middle name, student

number, program, year, person id$).$

$6.$ When the user selects $$View Specific Record$$ menu, the application allows the user to view

specific person record $($last name, given name, middle name, student number, program,

year, person id$)$ either by student number or person id$.$

Note $1$: All records of person and student will be saved on the database record created on your

module $2$ exam.

Note $2$: All communications and transactions from WPF application to SQL Server database

must use stored procedures $($mostly created during your module $2$ exam$).$

Note $3$: The source code and SQL script of this exam must be submitted together with the

completion of requirements. Failure to submit your source code and SQL script will result into

negative impact on your quiz portion.

Note $4$: The quiz will be graded based from the submitted functionality of the source code and

SQL script $($requirements presented$)$ of your application and database.

Note $5$: The machine problem will be graded based from the video presentation and design

$($creativity$,$ clarity and quality$)$ of your application and database