Assignment Brief (RQF)
Assignment Brief (RQF)
Higher National Certificate/Diploma in
Student Name/ID Number: Nawoda Balasooriya / M19941109004
Unit Number and Title:
4: Database Design & Development
Academic Year:
2019
Unit Assessor:
Assignment Title:
Trinity Music School
Issue Date:
Submission Date:
Internal Verifier Name:
Date:
Submission Format:
The submission is in the form of an individual written report. This should be written in a
concise, formal business style using single spacing and font size 12. You are required to ma
ke use of headings, paragraphs and subsecti ons as appropriate, and all work must be
supported with research and referenced using the Harvard referencing system. Please also
provide a bibliography using the Harvard referencing system. The recommended word limit is
2,000–2,50 0 words, although you will not be penalised f or exceeding the total word limit.
The submission is in the form of a f ully functional relational database system as an
individual written report.
The submission is in the form of a w itness statement of the testing completed by
the student; technical documentation; and a writ ten report
Unit Learning Outcomes:
LO1 Use an appropriate design tool to design a relational database system for a su
bstantial problem.
LO2 Develop a fully functional relational database system, based on an existing sy stem design.
LO3 Test the system against user and system requirements.
LO4 Produce technical and user do cumentation.
Prepared by: Higher Education Qualifications (H EQ) Approved by: HEQ, QDAM (HE)
Version 1.0 – November 2017
NAWODA BALASOORIYA / M19941109004 1
, Assignment Brief (RQF)
Assignment Brief and Guidance:
Assignment brief
Case study
Trinity Music School is a privately ru n music school based in Colombo. They want you to supply them
with a database to keep recor ds of their classes, which teachers teach on these classes, which
students are in each class and what instruments need to be rented for the cl ass. Musical instruments
are supplied to each cla ss, so that students do not have to buy their ow n. A class will rent a number
of musical instrumen ts of the same type. Each type of musical instrument is supplied by one
company. The rental for each type of musical instrument is for a particular n umber of those
instruments for a particular period. ach class has number of students. A student m ay be in more than
one class. Students are classified by type as Full_Time, Part_Time or Part_Ti me_Evening. A teacher
may teach in more than one class and a class may have more than one te acher.
Below are some of the paper records currently kept by Trinity Music School.
Class Record
Table 1. Class Record
Instrument Type Record
Table 2. Instrument Type Record
Students and their Classes
Table 3. Students and their Classes
There are many more paper record s. It was difficult to get all the records as they ha ve not
managed them properly. Therefore conceptualize and incorporate your own ideas when
doing the following tasks.
Prepared by: Higher Education Qualifications (H EQ) Approved by: HEQ, QDAM (HE)
Version 1.0 – November 2017
NAWODA BALASOORIYA / M19941109004 2
, Assignment Brief (RQF)
Task 1
1.1 The design of the relational database system using appropriate design
tool s and techniques. It should contai n at least four interrelated tables.
1.2 You will produce a comprehensive design for a fully functional system which will
include interface to Trinity Music School and output designs, data validations and
cover data normalisation. Clear statem ents of user and system requirements.
(Learning outcome L 01)
Task 2
2.1 Once the designs have bee n accepted you have been asked to develop the
database system using evidence of user interface, output and data validations
and q uerying across multiple tables.
2.2 You want to include more th an just the basics so you will implement a fully functional
database system which will include system security and database maintenance features.
2.3 You have decided to implement a query language into the relational database
system. Assessing whether meaningful data has been extracted through the use
of query tools to produce appropriate management information.
2.3.1 For each lecture display the total number of students attended.
2.3.2 Display the lecture details of Guitar class and his total number of lecture hours.
2.3.3 Display the class schedule of the week starting from 29/06/2016 to 0
5/06/2016. That is class code, instrument taught, teacher, time duration and
number of students attended.
(Learning outcome L02)
Task 3
3.1 Evaluating the effectiveness of the database solution in relation for educational
organizational environment and system requirements, and suggest improv ements
3.2 Once the system has been developed, you will test the system against user and
system Requirements, including an explanation of the choice of test data used.
3.3 Produce technical and user documentation which will be given to the Trinit y
Music School. provide some graphical rep resentations for ease of reference in
the technic al guide and produce a technical and us er documentation for a fully
functional system, i ncluding diagrams showing movement of data through the
system, and flowcharts describing how the system works.
(Learning outcome L0 3 and L04)
Prepared by: Higher Education Qualifications (H EQ) Approved by: HEQ, QDAM (HE)
Version 1.0 – November 2017
NAWODA BALASOORIYA / M19941109004 3
Assignment Brief (RQF)
Higher National Certificate/Diploma in
Student Name/ID Number: Nawoda Balasooriya / M19941109004
Unit Number and Title:
4: Database Design & Development
Academic Year:
2019
Unit Assessor:
Assignment Title:
Trinity Music School
Issue Date:
Submission Date:
Internal Verifier Name:
Date:
Submission Format:
The submission is in the form of an individual written report. This should be written in a
concise, formal business style using single spacing and font size 12. You are required to ma
ke use of headings, paragraphs and subsecti ons as appropriate, and all work must be
supported with research and referenced using the Harvard referencing system. Please also
provide a bibliography using the Harvard referencing system. The recommended word limit is
2,000–2,50 0 words, although you will not be penalised f or exceeding the total word limit.
The submission is in the form of a f ully functional relational database system as an
individual written report.
The submission is in the form of a w itness statement of the testing completed by
the student; technical documentation; and a writ ten report
Unit Learning Outcomes:
LO1 Use an appropriate design tool to design a relational database system for a su
bstantial problem.
LO2 Develop a fully functional relational database system, based on an existing sy stem design.
LO3 Test the system against user and system requirements.
LO4 Produce technical and user do cumentation.
Prepared by: Higher Education Qualifications (H EQ) Approved by: HEQ, QDAM (HE)
Version 1.0 – November 2017
NAWODA BALASOORIYA / M19941109004 1
, Assignment Brief (RQF)
Assignment Brief and Guidance:
Assignment brief
Case study
Trinity Music School is a privately ru n music school based in Colombo. They want you to supply them
with a database to keep recor ds of their classes, which teachers teach on these classes, which
students are in each class and what instruments need to be rented for the cl ass. Musical instruments
are supplied to each cla ss, so that students do not have to buy their ow n. A class will rent a number
of musical instrumen ts of the same type. Each type of musical instrument is supplied by one
company. The rental for each type of musical instrument is for a particular n umber of those
instruments for a particular period. ach class has number of students. A student m ay be in more than
one class. Students are classified by type as Full_Time, Part_Time or Part_Ti me_Evening. A teacher
may teach in more than one class and a class may have more than one te acher.
Below are some of the paper records currently kept by Trinity Music School.
Class Record
Table 1. Class Record
Instrument Type Record
Table 2. Instrument Type Record
Students and their Classes
Table 3. Students and their Classes
There are many more paper record s. It was difficult to get all the records as they ha ve not
managed them properly. Therefore conceptualize and incorporate your own ideas when
doing the following tasks.
Prepared by: Higher Education Qualifications (H EQ) Approved by: HEQ, QDAM (HE)
Version 1.0 – November 2017
NAWODA BALASOORIYA / M19941109004 2
, Assignment Brief (RQF)
Task 1
1.1 The design of the relational database system using appropriate design
tool s and techniques. It should contai n at least four interrelated tables.
1.2 You will produce a comprehensive design for a fully functional system which will
include interface to Trinity Music School and output designs, data validations and
cover data normalisation. Clear statem ents of user and system requirements.
(Learning outcome L 01)
Task 2
2.1 Once the designs have bee n accepted you have been asked to develop the
database system using evidence of user interface, output and data validations
and q uerying across multiple tables.
2.2 You want to include more th an just the basics so you will implement a fully functional
database system which will include system security and database maintenance features.
2.3 You have decided to implement a query language into the relational database
system. Assessing whether meaningful data has been extracted through the use
of query tools to produce appropriate management information.
2.3.1 For each lecture display the total number of students attended.
2.3.2 Display the lecture details of Guitar class and his total number of lecture hours.
2.3.3 Display the class schedule of the week starting from 29/06/2016 to 0
5/06/2016. That is class code, instrument taught, teacher, time duration and
number of students attended.
(Learning outcome L02)
Task 3
3.1 Evaluating the effectiveness of the database solution in relation for educational
organizational environment and system requirements, and suggest improv ements
3.2 Once the system has been developed, you will test the system against user and
system Requirements, including an explanation of the choice of test data used.
3.3 Produce technical and user documentation which will be given to the Trinit y
Music School. provide some graphical rep resentations for ease of reference in
the technic al guide and produce a technical and us er documentation for a fully
functional system, i ncluding diagrams showing movement of data through the
system, and flowcharts describing how the system works.
(Learning outcome L0 3 and L04)
Prepared by: Higher Education Qualifications (H EQ) Approved by: HEQ, QDAM (HE)
Version 1.0 – November 2017
NAWODA BALASOORIYA / M19941109004 3
