Ask a question from expert

Ask now

The assignment submission is entirely my own work and I understand the consequences of plagiarism

75 Pages6901 Words487 Views
   

Added on  2022-01-21

About This Document

7 Figure 3: All User's Menu interface 8 Figure 4: Admin Student interface 9 Figure 5: Add Student interface10 Figure 6: Edit student interface 11 Figure 7: Delete student . Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student interface: Student

The assignment submission is entirely my own work and I understand the consequences of plagiarism

   Added on 2022-01-21

BookmarkShareRelated Documents
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 GCH200035
Class
GCH0903 Assessor name Vươ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 false declaration is a form of malpractice.

Student’s signature

Grading grid

P2
P3 P4 P5 M2 M3 M4 M4 D2 D3
The assignment submission is entirely my own work and I understand the consequences of plagiarism_1
Summative Feedback:Resubmission Feedback:
Grade:
AssessorSignature: Date:
InternalVerifier’sComments:

Signature&Date:
The assignment submission is entirely my own work and I understand the consequences of plagiarism_2
Table of Contents
I. Introduction
.........................................................................................................................6
II. User interfaces, data validation & query
.........................................................................................6
III. Test plan .....................................................................................................................................50

IV. Documentation .......................................................................................................................51
The assignment submission is entirely my own work and I understand the consequences of plagiarism_3
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
The assignment submission is entirely my own work and I understand the consequences of plagiarism_4
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
The assignment submission is entirely my own work and I understand the consequences of plagiarism_5
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
The assignment submission is entirely my own work and I understand the consequences of plagiarism_6
1. All user Login interface:
Figure 2: Login interface

Code:

Insert Data:

Query:
The assignment submission is entirely my own work and I understand the consequences of plagiarism_7
2. All user Menu interface:
Figure 3: All User’s Menu interface
The assignment submission is entirely my own work and I understand the consequences of plagiarism_8

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Design & Development Assignment 2
|75
|6962
|200

TEC Level 5 HND Diploma in Computing Unit number and title Unit 04: Database Design & Development Submission Date Date Received 1st submission Re-submission 2nd submission Assessor name Dinh Thi Minh
|36
|2784
|21

Home Inventory Database: Software Tool Description, SQL Section, Security Measures, Testing and Validation Strategies
|7
|800
|134

Unit 9: Software Development Life Cycle
|46
|9041
|1314

Assignment on Web Application Development
|11
|880
|32