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

ASSIGNMENT 1 FRONT SHEET
Qualification TEC Level 5 HND Diploma in Computing
Unit number and title Unit 04: Database Design & Development
Submission date Date Received 1st submission
Re-submission Date Date Received 2nd submission
Student Name Tran Ba Manh Student ID BHAF200071
Class PBIT17102 Assessor name Dinh Thi Minh Nguyet
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
P1 M1 D1
1

❒ Summative Feedback: ❒ Resubmission Feedback:
Grade: Assessor Signature: Date:
Signature & Date:
2

INTRODUCTION................................................................................................................................................................................................................................................... 5
I. Implementation.............................................................................................................................................................................................................................................. 5
The students table is the table that stores student information........................................................................................................................................................................... 5
majors table is a table that stores information about majors....................................................................................................................................................5
The course table is a table that stores information about students' courses.......................................................................................................................................................6
students_course table is a table that stores information about students' scores in courses...................................................................................................6
The Account table is the table that stores the student's login information..........................................................................................................................................................6
................................................................................................................................................................................................................................................................................ 6
add data to the students table.............................................................................................................................................................................................................................. 7
Add data to the majors table................................................................................................................................................................................................................................. 7
Add data to the course table.................................................................................................................................................................................................................................. 7
Add data to the student_course table................................................................................................................................................................................................................... 7
add data to the Account table................................................................................................................................................................................................................................ 8
When we want to edit data in a certain table, we use the following statement..................................................................................................................................................8
edit and add data to the majors . table.................................................................................................................................................................................................................. 8
Edit and data to the students table........................................................................................................................................................................................................................ 8
Edit and data to the student_course table............................................................................................................................................................................................................ 8
................................................................................................................................................................................................................................................................................ 8
To delete data in the table, we use the following statement..................................................................................................................................................................................9
Delete data in the student_course table.................................................................................................................................................................9
Delete data in the course table.............................................................................................................................................................................................................................. 9
................................................................................................................................................................................................................................................................................ 9
Delete data in the majors table.............................................................................................................................................................................................................................. 9
in ASM1, include the following tables: Students,course,majors and Student_course.in ASM2 I added the Account table, each student needs an account to log in to the
system and view their information. In the majors table, I added a Specialized column to help the viewer know which industry it is. in the studets table i will remove the
majorid . column................................................................................................................................................................................................................................................... 10
.............................................................................................................................................................................................................................................................................. 10
II. User Interfaces & Querries........................................................................................................................................................................................................................... 11
To display the student's login information and form, the system will display an interface as follows for the user..............................................................................................11
Here are some queries to perform the function in the above interface as follows............................................................................................................................................11
code to display student data...........................................................................................................................................................19
code to add student data to the database .....................................................................................................................................19
Code to update student data..................................................................................................................................................................... 20
code to delete student data............................................................................................................................................................................ 20
code so that users can log out when logged into the system.........................................................................................................................21
code to convert from student form to course,transcript and account tables...................................................................................................................21
The code to display the data in the dropdownlist when the user clicks on the data lines.................................................................................................................................22
Here is the code that displays the course data.................................................................................................................................................................................................... 22
This is the code that shows up in the dropdownlist when the user clicks on the data table................................................................................................23
Here is the code for the user to add the course information to the database....................................................................................................................................................23
Here is the code for the user to edit the course data ..............................................................................................................................24
Here is the code for the user to delete the student's course information ..................................................................................................24
Here is the code to help the user to return to the Student form............................................................................................................................25
the code that displays the student's score data.................................................................................................................................................................................................. 25
The code shows the data on the dropdownlist when the user clicks on the data table...................................................................................................26
.............................................................................................................................................................................................................................................................................. 26
code to help users add new student scores......................................................................................................................................................................................................... 26
This code allows the user to edit the student's score data...........................................................................................................................................27
This code allows users to delete student's grades.......................................................................................................................................................27
III.Testing.............................................................................................................................................................................................................................................................. 28
IV. Technical Document................................................................................................................................................................................................................................. 30
Introduction.......................................................................................................................................................................................................................................................... 30
ERD........................................................................................................................................................................................................................................................................ 30
Possible and realistic improvements.................................................................................................................................................................................................................... 30
Current version number....................................................................................................................................................................................................................................... 30
Date last changed and implemented................................................................................................................................................................................................................... 34
3

VII. User Document............................................................................................................................................................................................................................................... 34
Summary............................................................................................................................................................................................................................................................... 36
4

INTRODUCTION
In Assignment 1, I presented the definition of database design, SRS, Logical design, Physical design and demo database.
in this Assignment 2 lesson. I will continue to develop and evaluate the database
I. Implementation
To create the database we have the following command
in the grading database, including the following tables
The students table is the table that stores student information
majors table is a table that stores information about majors
5

The course table is a table that stores information about students' courses
students_course table is a table that stores information about students' scores in courses
The Account table is the table that stores the student's login information
6

To add data to the table, we use the following statement
add data to the students table
Add data to the majors table
Add data to the course table
Add data to the student_course table
7

add data to the Account table
When we want to edit data in a certain table, we use the following statement
edit and add data to the majors . table
Edit and data to the students table
Edit and data to the student_course table
8