ASSIGNMENT 1 FRONT SHEET

Qualification TEC Level 5 HND Diploma in Computing

Unit number and title Unit 04: Database Design & Development

Submission date 19-8-2020 Date Received 1st submission

Re-submission Date Date Received 2nd submission

Student Name Nguyen Tat Trung Student ID GCS190231

Class GCS0804A Assessor name ThuyLNL

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

Page 1
Page 2
 Summative Feedback:  Resubmission Feedback:

Grade: Assessor Signature: Date:

Signature & Date:

Page 3
 ASSIGNMENT 1 BRIEF
Qualification BTEC Level 5 HND Diploma in Computing

Unit number Unit 04: Database Design & Development

Assignment title

Academic Year 2020-2021

Unit Tutor ThuyLNL

Page 4
Issue date Submission date 19-8-2020

IV name and date

Submission Format:

Format: This assignment is an Individual assignment and specifically including 1 document:

You must use font Calibri size 12, set number of the pages and use multiple line spacing at
1.3. Margins must be: left: 1.25 cm; right: 1 cm; top: 1 cm and bottom: 1 cm. The reference
follows Harvard referencing system. The recommended word limit is 2.000-2.500 words. You
will not be penalized for exceeding the total word limit. The cover page of the report has to
be the Assignment front sheet 1.
Submission Students are compulsory to submit the assignment in due date and in a way requested by
the Tutors. The form of submission will be a soft copy posted on
http://cms.greenwich.edu.vn/
Note: The Assignment must be your own work, and not copied by or from another student or from
books etc. If you use ideas, quotes or data (such as diagrams) from books, journals or other sources, you
must reference your sources, using the Harvard style. Make sure that you know how to reference properly,
and that understand the guidelines on plagiarism. If you do not, you definitely get fail

Unit Learning Outcomes:

LO1 Use an appropriate design tool to design a relational database system for a substantial problem.
LO2 Develop a fully functional relational database system, based on an existing system design.

Page 5
LO3 Test the system against user and system requirements.
LO4 Produce technical and user documentation

Assignment Brief and Guidance:

You are employed as a Database Developer for a large IT consultancy company. The company has been
approached by FPT university which is expanding due to the growth of the number of students. FPT is
currently facing difficulties in dealing with managing the university. It decided to develop several academic
systems to manage the university easier including: Online Library system, Student Grading System,
Attendance System, CMS System, Scheduling System, Enrolment Systems, and so on.
You are tasked to select one of those systems to develop database for FPT university. Your tasks are to:
Work with FPT to find out about current requirements for each system
Analyze the requirements and produce clear statements of user and system requirements.
Design a relational database system using appropriate design tools and techniques
Develop a fully functional relational database system, based on an existing system design.
Test the system against user and system requirements.
Produce technical and user documentation

Part 1 (Assignment 1)
Before you start the development process, your manager has asked you to produce a report for the CEO
of FPT, containing:
1. Clear statements of user and system requirements. The system must have at least 2 user roles, including
business processes and statistical reports for FPT university managers.

Page 6
2. The design of the relational database system using appropriate design tools and techniques. It should
contain at least four interrelated tables.
You would prefer to produce a more detailed document, so you will produce a comprehensive design for a
fully functional system which will include interface and output designs, data validations and cover data
normalization.
Your manager would like on the report your assessment of the effectiveness of the design in relation to user
and system requirements.

Part 2 (Assignment 2)
Once the designs have been accepted by your manager you have been asked to:
1. Develop the database system using evidence of user interface, output and data validations and querying
across multiple tables.
You want to include more than just the basics so you will implement a fully functional database system
which will include system security and database maintenance features.

2. You have decided to implement a query language into the relational database system. The developed
system will be demonstrated to your manager in the report including:
 Assessing whether meaningful data has been extracted through the use of query tools to produce
appropriate management information.
 Evaluating the effectiveness of the database solution in relation to user and system requirements,
and suggest improvements.
3. Once the system has been developed, you will test the system and your manager will complete a witness
statement indicating how your tests are performing against user and system requirements.

Page 7
Besides, you will produce a brief report assessing the effectiveness of the testing, including an explanation
of the choice of test data used.
4. Lastly you will produce technical and user documentation which will be given to the company.
You want to provide some graphical representations for ease of reference in the technical guide, so you
have decided to produce a technical and user documentation for a fully functional system, including
diagrams showing movement of data through the system, and flowcharts describing how the system
works.

Page 8
 Learning Outcomes and Assessment Criteria

Pass Merit Distinction

LO1 Use an appropriate design tool to design a relational database system for a substantial problem

P1 Design a relational M1 Produce a comprehensive D1 Assess the effectiveness of the

database system using design for a fully functional system design in relation to user and system
appropriate design tools and which includes interface and output requirements.
techniques, containing at least designs, data validations and data
four interrelated tables, with normalisation.
clear statements of user and
system requirements.

Contents
Database Design.............................................................................................................................................................. 10
Scenario of the chosen system: Student Grading System .......................................................................................... 10
1. System Requirement Specification (SRS) ............................................................................................................ 10
2. Logical design (ERD) ............................................................................................................................................ 10
3. Explanation ......................................................................................................................................................... 11
4. Physical design .................................................................................................................................................... 12
References .................................................................................................................................................................. 15

Page 9
Database Design
Scenario of the chosen system: Student Grading System
1. System Requirement Specification (SRS): The client requirement asked their system had to operate smooth and effective. They want to
manage their student’s grading on system easily to avoid confusion and shortcomings in their management period. The client objective is
managing student like: one student can learn how many classes, subjects? And when they input the student information into system then how the
system working? From class id, subject that the student learns until the grading or result of this student.
2. Logical design (ERD): The entity relation design without regard to what RDBMS or system it will be on. One common method of depicting
entities and relationships in a diagram.

Page 10
 Figure 1 Logical design by app.diagrams.net

3. Explanation: As we had mention that we develop the student grading system for university. In this ERD, we designed at least 4 interrelated
tables to shown client about basic ideas of us. We used 4 entities including: Student, Class, Grading, Subject. In Student’s entity, it has Student_ID,
Student_Name, Student_Subject. In Class’s entity, it has Class_ID, Class_Name, Subject_Name. In Grading’s entity, it has Student_ID, Class_ID,
Subject_Name, Grading_Date, Grading_time. And in Subject’s entity, it has Subject_Name, Subject_ID, Subject_Result. We set primary key for
each entities table excepted grading’s table: Student_ID for Student’s table, Class_ID for Class’s table, Subject_Name for Subject’s table. After set
primary key, we combine each entities to each corresponding entities of another table which set primary key. In our student grading system
project, we want to create the database which can manage student grading better. We will explain their relationship in simplest, one student can

Page 11
 learn in many classes and subjects. And in the opposite, just one Student_ID can grade many subjects for one student. Finally, the reason why ERD
is suitable for the system is help designer easily in thinking about client requirements.

4. Physical design: The design adapted to the RDBMS and system constraints and features.

Figure 2 Design in Student's table

Figure 3 Design in Class's table

Page 12
Figure 4 Design in Subject's table

Figure 5 Design in Grading's table

Page 13
Figure 6 Edit top in 200 rows of Student's table

Figure 7 Edit top in 200 rows of Class's table

Page 14
 Figure 8 Edit top 200 in rows of subject's table

Figure 9 Edit top 200 in rows of Grading's table

References:
[1]. Cogner, S., 2012. Hands-on Database: An Introduction to Database Design and Development. Prentice Hall.

[2]. Connolly, T.M. & Begg, C.E., 2015. Database Systems: A Practical Approach to Design, Implementation, and Management. 4th ed. Pearson.

Page 15