Limited-time offer! Save up to 50% Off | Solutions starting at $6 each  

Unit 04: Database Design & Development

Added on - 21 Jan 2022

Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 8 of 75 pages
ASSIGNMENT2FRONT SHEET
Qualification
TEC Level 5 HND Diploma in Computing
Unit number and title
Unit 04: Database Design & Development
Submission date
DateReceived1stsubmission
Re-submissionDate
DateReceived2ndsubmission
StudentName
Nguyễn Việt HàStudent IDGCH200035
Class
GCH0903Assessor 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

P2
P3P4P5M2M3M4M4D2D3
SummativeFeedback:ResubmissionFeedback:
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 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
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
1.All userLogin interface:
Figure2: Logininterface

Code:

Insert Data:

Query:
2.All userMenu interface:
Figure3:All User’sMenu interface
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document