Database Design & Development Assignment 2
75 Pages6962 Words200 Views
Added on 2021-12-14
About This Document
This assignment showcases the skills learned in Database Design & Development. It includes user interfaces, data validation, and queries for various aspects such as students, teachers, classes, subjects, courses, and marks. The ERD, test plan, and documentation are also provided.
Database Design & Development Assignment 2
Added on 2021-12-14
ShareRelated 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
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
Summative Feedback:Resubmission Feedback:
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 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 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
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
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:
Figure 2: Login interface
Code:
Insert Data:
Query:
2. All user Menu interface:
Figure 3: All User’s Menu interface
Figure 3: All User’s Menu interface
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
The assignment submission is entirely my own work and I understand the consequences of plagiarismlg...
|75
|6901
|487
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 Minhlg...
|36
|2784
|21
Home Inventory Database: Software Tool Description, SQL Section, Security Measures, Testing and Validation Strategieslg...
|7
|800
|134
Unit 9: Software Development Life Cyclelg...
|46
|9041
|1314
Assignment on Web Application Developmentlg...
|11
|880
|32