Pearson
Higher National in
Computing
Unit 4: Database Design &
Development
ASSIGNMENT
BRIEF
This Assignment Brief is the property of
THE MILLENNIUM UNIVERSAL COLLEGE
Higher National Certificate/Diploma in Computing
Assignment Brief
Pearson Reg. Number
Student Name
Unit Number and Title Unit 4: Database Design & Development
Academic Year 2024-25
Unit Tutor
Assignment Title Database Design & Development
Issue Date 14-October-2024
Submission Date 26-December-2024
Submitted On
Internally Verified? Yes No
IV Name Mir Wajid Ali
IV Date
Student Declaration
I solemnly declare that the work submitted for this assignment is my own and
research sources are fully acknowledged. I fully understand the consequences of
plagiarism and I understand that making a false declaration is a form of malpractice.
Student Signature: Tutor
Signature:
Date: Date:
Submission Format
The submission for this assignment brief will be in form of an individual written
report and an MS Access Project file. This should be written in a concise, formal
business style using single spacing and font size 12. You are required to make use
of headings, paragraphs and subsections 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 3,000–3,500 words, although you will not be penalised
for exceeding the total word limit.
The report will be split into multiple sections titled as:
System Design Documents (approx. 500 words) – developed using appropriate
tools like UML, ER etc. along-with their description.
Application Development (approx. 700 words) – having screenshots of the
activities performed along-with their formal description
Application Testing (approx. 500 words) – having a test plan with desired and
actual outcomes against each process. Support your evidence with relevant
screenshot and a brief description
This Assignment Brief is the property of
THE MILLENNIUM UNIVERSAL COLLEGE
Technical Manual (approx. 600 words) – having data flow information for major
processes. You may skip repeating processes on multiple interfaces.
User Manual (approx. 700 words) – having a walk-through for standard users
with regards to system operations.
Conclusion and Recommendation (approx. 250 words) – this section is optional
and may only be used if you would like to include your viewpoint with regards
to the whole process and how you could improve it further and what learning
you have achieved during this project.
The project file must be in *.ACCDB or *.MDB format and must include all interfaces,
queries, tables, validation, security and maintenance steps taken. In case of any
password protection, password must be documented in the Technical Manual
section under the Application Password heading.
You are required to submit your work for plagiarism checking. No work will be
considered if it contains plagiarism more than the acceptable level defined as per
TMUC’s plagiarism policy.
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.
LO3 Test the system against user and system requirements.
LO4 Produce technical and user documentation.
Assignment Brief and Guidance:
Scenario
Express Mart a new startup provides hypermarket shopping experience to its
customers. They have announced an innovation drive and have invited all
undergraduate students of the city so come up with a database solution for their
hypermarket. The best solution will be implemented and the designer will be given
an incentive of 20% on bill every month.
You a student at TMUC HN Computing program will take part in the drive and come
up with a solution
The basic requirements explained by Express Mart are:
Record of all staff members working in the hypermarket should be available
on the system
Staff Attendance can be marked (either manually or using some gadget i.e
face detection)
Monthly payroll based on staff attendance can be calculated
Item categories
Weekly/Monthly attendance report can be generated
Sale Report for Daily/Weekly/Fortnightly/Monthly and custom can be
generated
Monthly Income and Expenditure report
This Assignment Brief is the property of
THE MILLENNIUM UNIVERSAL COLLEGE
The requirements are generic yet giving a reasonable context of what is needed but
you are encouraged to come up with a solution which is holistic in nature regarding
a hypermarket.
Being the student of HND Computing and currently studying the Database Design
and Development unit, you have also opted to participate in this event.
As per the instructions from the Department, you will be completing this task in 3
stages.
Stage 1
You will have a thorough discussion with the stakeholders with regards to the user
requirements and their corresponding system requirements. Once your
requirements are identified, you are required to create a comprehensive set of
design documents for an effective relational database application that aligns with
the identified requirements.
Stage 2
You will start developing a comprehensive and secure database application using
MS Access. You should also devise a test plan that would include what are desired
and expected results of the application.
Once the application development is complete, you should use some sample data
set of your own choice and test the system for compliance with the user and
system requirements and evaluate its effectiveness in this regard along-with any
improvement recommendations.
Stage 3
Once the system testing is complete, you will compile your report for final
submission to client, and should include every necessary detail that may be needed
by the client for meeting any current or future requirements.
Please access HN Global for additional resources support and reading for this unit.
For further guidance and support on report writing please refer to the Study Skills
Unit on HN Global. Link to www.highernationals.com
This Assignment Brief is the property of
THE MILLENNIUM UNIVERSAL COLLEGE
Grading Criteria
Learning Outcome Pass Merit Distinction
LO1 Use an P1 Design a M1 Produce a D1 Evaluate the
appropriate design relational database comprehensive effectiveness of the
tool to design a system using design for a fully design in relation to
relational database appropriate design functional system user and system
system for a tools and techniques, which includes requirements.
substantial problem containing at least interface and output
four interrelated designs, data
tables, with clear validations and data
statements of user normalisation.
and system
requirements.
LO2 Develop a fully P2 Develop the M2 Implement a fully D2 Evaluate the
functional relational database system functional database effectiveness of the
database system, with evidence of user system which database solution
based on an interface, output and includes system in relation to user
existing system data validations, and security and and system
design querying across database requirements, and
multiple tables. maintenance. suggest
improvements.
P3 Implement a M3 Assess whether
query language into meaningful data has
the relational been extracted
database system. through the use of
query tools to
produce appropriate
management
information.
LO3 Test the P4 Test the system M4 Assess the
systems against against user and effectiveness of the
user and system system testing, including an
requirements requirements. explanation of the
choice of test data
used.
LO4 Produce P5 Produce technical M5 Produce D3 Evaluate the
technical and user and user technical and user database in terms of
documentation documentation. documentation for a improvements
fully functional needed to ensure the
system, including continued
data flow diagrams effectiveness of the
and flow charts, database system.
describing how the
system works.
This Assignment Brief is the property of
THE MILLENNIUM UNIVERSAL COLLEGE
