FPT University Student Grading System Database Design & Development

This assignment details the design and development of a student grading system database for FPT University. It covers the entire process from initial requirements gathering to implementation and testing. The project includes the creation of user interfaces for various functionalities like student, teacher, class, subject, and course management, along with interfaces for managing marks (Pass, Merit, Distinction). The solution provides Entity-Relationship Diagrams (ERDs), SQL code for database creation, data insertion, and various queries to demonstrate the database's functionality. Data validation is also addressed within the interfaces. Furthermore, a comprehensive test plan is included to validate the implemented functionalities. The documentation provides a clear overview of the database structure, interface designs, and code implementations, aiming to provide a robust and efficient student grading system solution.

ASSIGNMENT 2 FRONT SHEET
Qualification TEC Level 5 HND Diploma in Computing
Unit number and title Unit 04: Database Design & Development
Submission date DateReceived1stsubmission
Re-submissionDate DateReceived2ndsubmission
Student Name Nguyễn Việt Hà Student ID GCH20003
Class GCH0903 Assessor name Vương Thị
Student declaration
I certify that the assignment submission is entirely my own work and I fully understand the consequences of plag
making a false declaration is a form of malpractice.
Student’s signature
Grading grid
P2 P3 P4 P5 M2 M3 M4 M4

 Summative Feedback: Resubmission Feedback:
Grade: AssessorSignature: Date:
InternalVerifier’sComments:
Signature&Date:

Table of Contents
I. Introduction ......................................................................................................................... 6
II. User interfaces, data validation & query ......................................................................................... 6
III. Test plan ..................................................................................................................................... 50
IV. Documentation ....................................................................................................................... 51

Table of Figures
Figure 1: ERD ................................................................................................................................................................. 6
Figure 2: Login interface ............................................................................................................................................... 7
Figure 3: All User’s Menu interface .............................................................................................................................. 8
Figure 4: Admin Student interface ................................................................................................................................ 9
Figure 5: Add Student interface .................................................................................................................................. 10
Figure 6: Edit student interface .................................................................................................................................. 11
Figure 7: Delete student ............................................................................................................................................. 12
Figure 8:User Student interface ................................................................................................................................. 13
Figure 9: Admin Teacher interface ............................................................................................................................. 14
Figure 10: Add Teacher interface................................................................................................................................ 15
Figure 11: Edit teacher interface ................................................................................................................................ 16
Figure 12: Delete Teacher ........................................................................................................................................... 17
Figure 13: User Teacher interface............................................................................................................................... 18
Figure 14: Admin Class interface ................................................................................................................................ 19
Figure 15: Add class interface ..................................................................................................................................... 20
Figure 16: Edit class interface ..................................................................................................................................... 21
Figure 17: Delete Class ................................................................................................................................................ 22
Figure 18: User Classes interface ................................................................................................................................ 23
Figure 19: Admin Subject interface ............................................................................................................................ 24
Figure 20: Add Subject interface................................................................................................................................. 25
Figure 21: Edit Subject interface ................................................................................................................................. 26
Figure 22: Delete subject ............................................................................................................................................ 27
Figure 23: User Subject interface................................................................................................................................ 28
Figure 24: Admin Course interface ............................................................................................................................. 29
Figure 25: Add Course interface ................................................................................................................................. 30
Figure 26: Edit Course interface ................................................................................................................................. 31
Figure 27: Delete Course............................................................................................................................................. 32
Figure 28: User Course interface ................................................................................................................................ 33
Figure 29:All User’s Mark interface ........................................................................................................................... 34
Figure 30: Admin Pass interface ................................................................................................................................. 35
Figure 31: Add Pass interface ..................................................................................................................................... 36
Figure 32: Edit Pass interface ...................................................................................................................................... 37
Figure 33: Delete Pass ................................................................................................................................................. 38
Figure 34: User Pass interface .................................................................................................................................... 39
Figure 35: Admin Merit interface ............................................................................................................................... 40
Figure 36: Add Merit interface ................................................................................................................................... 41
Figure 37: Edit Merit interface .................................................................................................................................... 42
Figure 38: Delete Merit ............................................................................................................................................... 43
Figure 39: User Merit interface .................................................................................................................................. 44
Figure 40: Admin Distinction interface ....................................................................................................................... 45

Figure 41: Add Distinction interface ........................................................................................................................... 46
Figure 42: Edit Distinction interface ........................................................................................................................... 47
Figure 43: Delete Distinction ...................................................................................................................................... 48
Figure 44: User Distinction interface .......................................................................................................................... 49
Figure 45: Diagram ...................................................................................................................................................... 53
Figure 46: ERD ............................................................................................................................................................. 54

I. Introduction
In this assignment, I going to demonstrate all of the skill that I have learned through the past few weeks
and presented the code that I have been working along with the interfaces and data validation that I have
done in the first assignment down below.
II. User interfaces, data validation & query
ERD:
Figure 1: ERD

1. All user Login interface:
Figure 2: Login interface
Code:
Insert Data:
Query:

2. All user Menu interface:
Figure 3: All User’s Menu interface

3. Student interface
a. Admin interface:
Admin’s Student interfaces
Figure 4: Admin Student interface
Code:

Add student interface:
Figure 5: Add Student interface
Code:
insert into student values ('GCH1444','Ha','2002/6/24','0123555559','hanguyen');
insert into student values ('GCH2407','Nguyen','2012/7/24','0444456789','vietha');
insert into student values ('GCH1554','Viet','2022/7/24','0133356789','haviet');

Edit student interface:
Figure 6: Edit student interface
Code:
update student set Username='haviet' where student_Name='Viet';

Delete student:
Figure 7: Delete student
Code:
delete from student where Student_Name='Ha';