Database Design And Development

Class: GCH0906
ASSIGNMENT 1 – Database Design
and Development

Class: GCH0906
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 Truong Quoc Bao Student ID GCH200633
Class GCH0906 Assessor name Vuong Thi 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 Bao
Grading grid
P1 M1 D1

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

I. Introduction
The paper will describe the answer to an issue that the FPT university encountered. The author works for a big IT
consulting firm as a database developer. The FPT university has approached a firm that is expanding due to the
increase in student numbers. The university administration at FPT is currently having issues. The business was asked
by FPT University to fix the problem. Working with the university, determining current needs for the entire system,
analyzing, producing, and designing a fully functioning and technical database system based on an existing system
design that can address the FPT university's problem are the author's responsibilities.
1. Scenario of the chosen system
The University of Greenwich Vietnam is experiencing difficulties with their attendance system.
The schedule manager will organize the study schedule by subjects at the start of each semester. The timetable for each
class will be different. Due to unforeseen problems, the class schedule may be modified during the weekend. Teachers
will take attendance for their pupils in each class, and the teacher will provide the attendance list to the schedule
management staffs at the end of each class. Based on the overall number of class sessions and the total number of
absences. Student absences will be a significant factor in determining a student's success. If a student miss more than
20% of their classes, the academic department will call their parents and tell them of their children's academic
performance. If a student miss more than 25% of the total sessions, the student will no longer be graded and will have to
retake the test or the class. He (or she) can, however, nonetheless take part. This attendance system is operated by
hand.
Without a database, students will have a difficult time determining whether their attendance is valid and requesting that
their professors amend it. When teachers face unanticipated issues that force them to modify their teaching schedule, it is
extremely difficult for the university to tell students in a timely manner about the unexpected change. It was also difficult to
take attendance because all of the attendance procedures are done on paper. Deviation and data loss are unavoidable
when teachers (schedule managers) take attendance for a large number of pupils.
Greenwich University Vietnam has engaged database designers for its attendance system to address the aforementioned
issues. The database designer must figure out how many students are in the class. The designer must also identify each
student's specific details as well as the teacher's personal information. A list of classes available for the current semester,
as well as a list of students for each class, should be identified by the database designer. Each semester, the school
needs to know the teaching timetable. The teaching schedule can be changed; however, it must be communicated 12
hours prior to the scheduled session for that day) and an attendance record for each instructor will be generated. The