Trusted by 2+ million users,
1000+ happy students everyday
1000+ happy students everyday
Showing pages 1 to 8 of 75 pages
ASSIGNMENT2FRONT SHEET
QualificationTEC Level 5 HND Diploma in Computing
Unit number and titleUnit 04: Database Design & Development
Submission dateDateReceived1stsubmission
Re-submissionDateDateReceived2ndsubmission
StudentNameNguyễn Việt HàStudent IDGCH200035
ClassGCH0903Assessor nameVương Thị Nhung
Student declaration
I certify that the assignment submission is entirely my own work and I fully understand the consequences of plagiarism.I understand that
making a falsedeclaration is a form of malpractice.
Student’s signature
Grading grid
P2P3P4P5M2M3M4M4D2D3
QualificationTEC Level 5 HND Diploma in Computing
Unit number and titleUnit 04: Database Design & Development
Submission dateDateReceived1stsubmission
Re-submissionDateDateReceived2ndsubmission
StudentNameNguyễn Việt HàStudent IDGCH200035
ClassGCH0903Assessor nameVương Thị Nhung
Student declaration
I certify that the assignment submission is entirely my own work and I fully understand the consequences of plagiarism.I understand that
making a falsedeclaration is a form of malpractice.
Student’s signature
Grading grid
P2P3P4P5M2M3M4M4D2D3
SummativeFeedback:ResubmissionFeedback:
Grade:AssessorSignature:Date:
InternalVerifier’sComments:
Signature&Date:
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
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 Subjectinterface............................................................................................................................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: AddCourse 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 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 Subjectinterface............................................................................................................................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: AddCourse 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
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 learnedthrough the past few weeks
and presented the code that I have been working along with theinterfaces and data validation that I have
done in the first assignment down below.
II.User interfaces, data validation & query
ERD:
Figure1: ERD
In this assignment, I going to demonstrate all of the skill that I have learnedthrough the past few weeks
and presented the code that I have been working along with theinterfaces and data validation that I have
done in the first assignment down below.
II.User interfaces, data validation & query
ERD:
Figure1: ERD
1.All userLogin interface:
Figure2: Logininterface
Code:
Insert Data:
Query:
Figure2: Logininterface
Code:
Insert Data:
Query:
2.All userMenu interface:
Figure3:All User’sMenu interface
Figure3:All User’sMenu interface
You’re reading a preview
To View Complete Document
Click the button to download
Subscribe to our plans