Assigned: April $23,2024$

Due: May $23,2023$ Thursday @ $23$:$00($System will be closed for upload after the deadline$)$

DO NOT REQUEST TO UPLOAD OR EMAIL AFTER THE DEADLINE,

WHATEVER YOUR EXCUSE IS$.$

Remark $1$: The project can be done individually or as a group. A team can be at most $3$

students $($students can be in different sections of IE$218).$

Remark $2$: Projects will be uploaded to the moodle page of the course. You will upload your C#

codes and back up of your SQL database in a rar file. The name of the rar file will be students

name like the following:

If the project is done by more than one student, EACH student will upload the file.

Remark $3$: All team members will be penalized if the student whose name is on the file is

understood not to have contributed to the project.

$$ You are entirely responsible for uploading your homework correctly.

$$ Please note that making a mistake during the upload process will have negative

consequences for you.

$$ For this reason, it is highly recommended to check your homework by downloading the

file you uploaded.

DETAILS OF THE PROJECT

You are expected to create a student registration system by using C# form

application and SQL Server.

Project may contain at least the following data by obeying the normalization

rules:

$$ Data about student$$s personal information $($like adress, phone number,

blood type, etc...$)$

$$ Academic information of the students,

$$ Course information,

$$ Data about the academic personnel.

$....$

Program may have an answer at least for the following situations:

$$ Course list registered by a student.

$$ The student list of a searched course.

$$ List of students advised by an instructor.

$$ The course list that is given by an instructor.

$$ The course list that is taken by a student.

$$ The instructor$($s$)$ that is$/$are giving a searched course.

$$ The age of the male students whose ages are greater than $30($maybe for

military service$).$

$$ List of students who have previously taken the selected course and are now

re$-$enrolled

$$ The most succesful student in the department and at a specific course.

$$ Give opportunity to delete the students, courses and instructor according

to the constraint that you define.

$$ Give opportunity to update any data.

$$ Give opportunity to enter data about a new student, a new course and a

new instructor.

$....$

You are expected to apply everything that you have learned at the course. But

this should be your lower limit$.$ You should search and find more than the things

that is taught.

Dead$-$line of the project is Thursday, May $23$rd $2024$ @ $23$:$00.$ Late submission

is not allowed.

In case of necessity, instructor has the right to update this file.

Original and creative works will be more valuable. Your program must be user

friendly.