INTERNATIONAL SCHOOL OF
MANAGEMENT AND TECHNOLOGY
KATHMANDU, NEPAL
Qualification Unit Number & Title
Y/615/1682 – Unit 38: Database Management
BTEC HND IN COMPUTING
Systems
Student Name Assessor Name
Roshan Acharya
Assignment Launch Date Due Date Completion Date
29 September 2021 28 November 2021
Session/Year Assignment Number 1/1
Assignment Title Super Market Stock Management System
Assignment submission format
Each student has to submit their assignment as guided in the assignment brief. The students
are guided what sort of information is to produce to meet the criteria targeted. 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 APA referencing system.
Learning outcomes covered
LO1 Analyze different types of database management systems
LO2 Design a database management system using a relational model to meet client
requirements
LO3 Develop a database management system using a suitable platform
LO4 Demonstrate the system administration and management tools available on the
chosen platform
1|Page
Scenario
You have been hired as DBA for Bhat-Bhateni SuperMarket. Bhat-Bhateni Super Market is
one of the biggest retail supermarkets in Nepal. They want to extend their branch from central
to five different branches. So, it is necessary to build the database and an application to keep
the record of these members.
The System should include the following features:
- Keep all branch records
- Keep all Item and Stock records
- Employee details and attendance records
- Database security measures like login and permissions, back-up/restore, log
maintenance and system performance
Assignment Task
1. Write an article that compares and contrasts the different types of database models
and assesses how relational database models and the process of normalization can
provide reliable and efficient data structures. You can also make a critical evaluation
of different database management systems and operating systems available (both open-
source and vendor-specific), justifying the evaluation criteria. It should cover data
models, modeling languages and specifically examine relational databases and their
structures.
2. Design a relational database management system and analyze how the design will
optimize system performance.
3. Develop a fully functional system which meets client and system requirements, using
an open source language. Implement effective features to handle concurrency, security,
user authorizations and data recovery.
4. Produce evidence that shows you have tested the system for functionality and
performance.
5. Critically evaluate the effectiveness of the system you have designed and developed
against client and system requirement.
6. Prepare a document that
2|Page
A- Demonstrate the tools available in the system you have designed to monitor and
optimize system performance, and examine the audit logs.
B- Demonstrate (present) the tools available in the system you have designed to
manage security and authorizations.
C- Assess the effectiveness of the system administration and management tools
available on the platform identifying any drawbacks of the tools and analyze any
future improvements that may be required to ensure the continued effectiveness of
the database system you have designed.
Pass Merit Distinction
LO1 Analyse different types of database management systems D1 Critically evaluate
different database
management systems
P1 Compare and contrast the M1 Assess how relational available in relation to
different types of database database models and the process open source and vendor
models. of normalisation can provide specific platforms,
reliable and efficient data justifying the criteria used
structures. in the evaluation.
LO2 Design a database management system using a relational LO2 and LO3
model to meet client requirements
D2 Critically evaluate the
effectiveness of the
P2 Produce a design for a M2 Analyse how the design will system design and
relational database management optimise system performance. development against client
system to meet client and system requirements.
requirements.
LO3 Develop a database management system using a suitable
platform
P3 Develop a fully functional M3 Implement effective features
system which meets client and in the solution to handle
system requirements, using an concurrency, security, user
open source language (with an
3|Page
application software e.g. authorisations and data recovery.
MySQL with front end
Microsoft Access).
P4 Test the system for
functionality and performance.
LO4 Demonstrate the system administration and management
tools available on the chosen platform
P5 Demonstrate the tools M4 Assess the effectiveness of D3 Analyse any future
available in the system to the system administration and improvements that may be
monitor and optimise system management tools available on required to ensure the
performance, and examine the the platform identifying any continued effectiveness of
audit logs. shortcomings of the tools. the database system.
P6 Demonstrate the tools
available in the system to
manage security and
authorisations.
Grades Achieved
Note: Refer the unit details provided in your handbook when responding all the tasks above.
Make sure that you have understood and developed your response that matches the highlighted
key words in each task.
Plagiarism Notice
You are remined that there exist Academic Misconduct Policy and Regulation concerning
Cheating and Plagiarism.
Extracts from the Policy:
Section 3.4.1: Allowing others to do assignments / Copying others assignment is an offence
Section 3.4.2: Plagiarism, using the views, opinion or insights / paraphrasing of another person’s
original phraseology without acknowledgement
Requirements
It should be the student’s own work – Plagiarism is unacceptable.
4|Page
Clarity of expression and structure are important features.
Your work should be submitted as a well presented, word-processed document with
headers and footers, and headings and subheadings, both in hard and soft copies.
You are expected to undertake research on this subject using books from the Library, and
resources available on the Internet.
Any sources of information should be listed as references at the end of your document
and these sources should be referenced within the text of your document using APA
Referencing style
Your report should be illustrated with screen-prints, images, tables, charts and/or
graphics.
All assignments must be typed in Times New Roman, font size 12, 11/2 spacing.
The center policy is that you must submit your work within due date to achieve “Merit”
and “Distinction”. Late submission automatically eliminates your chance of achieving
“Merit and Distinction”. Also, 80% attendance is required to validate this assignment.
I declare that all the work submitted for this assignment is my own work and I understand that if
any part of the work submitted for this assignment is found to be plagiarised, none of the work
submitted will be allowed to count towards the assessment of the assignment.
Assignment Prepared By Signature Date
Bikul Koirala September 20, 2021
Brief Checked By Signature Date
Dhruba Babu Joshi September 24, 2021
5|Page
