CMI3509 Databases for Large Data Sets

School and Computing and Engineering
Assignment Specification

Module Code CMI3509
Module Title Databases for Large Data Sets
Course Title/s
Assignment Details
Title Portfolio Assignment
Weighting 35%
Mode of working for
assessment task.
☒ Individual
There should be no collusion or collaboration whilst working on and
subsequently submitting this assignment.
☐ Group
Module Leader Tony Jenkins Contact details:
Module Tutor/s
Hand-out date Week Commencing 20th January 2020.
How to submit your
Work should be submitted as PDF to the submission point on
Brightpsace. All submissions will processed through TurnItIn. Work
submitted in any format other than PDF (for example Word) will not
be marked.
Submission date/s and
Submit before 11:59 on Tuesday 21st April 2020.
Expected amount of
independent time you
should allocate to
complete this
About 15 hours.
Submission type and
Two tutorials, totalling approximately 1000 words.
Date by which your
grade and feedback
will be returned
May 20th 2020.
Your responsibility It is your responsibility to read and understand the University
regulations regarding assessment.
Please pay special attention to the assessment regulations (section
4) on Academic Misconduct.


In brief: ensure that you;
1. DO NOT use the work of another student – this includes students
from previous years and other institutions, as well as current
students on the module.
2. DO NOT make your work available or leave insecure, for other
students to view or use.
3. Any examples provided by the module tutor should be
appropriately referenced, as should examples from external
Further guidance can be found in the SCEN Academic Skills
Resource and UoH Academic Integrity Resource module in
If you experience difficulties with this assessment or with time
management, please speak to the module tutor/s, your Personal
Academic Tutor, or the Guidance Team. (
Requesting an
You are reminded to ‘back-up’ your work as extensions will not be
given for lost work, which includes work lost due to hardware and
software failure/s.
Extension requests will only be approved if you can demonstrate
genuine, unexpected circumstances along with independent
supporting evidence (e.g medical certificate) that may prevent you
submitting an assessment on time.
Submit an extension request via Student Portal within 2 working
days of the due date.
Extension requests, up to a maximum of 10 working days, but
typically 1-5 working days, will be considered provided that there is
appropriate evidence which clearly indicates reasons for the request.
You will have 5 working days after submitting a request to provide
the evidence. Failure to submit evidence will result in the request
being rejected and your work being marked as a late submission.
If you are unable to submit work within the maximum extension
period of 10 days, contact the School’s Guidance team
(, as you may need to submit a claim for
Extenuating Circumstances (ECs).
Circumstances (ECs)
An EC claim is appropriate in exceptional circumstance, when an
extension is not sufficient due to the nature of the request, or it
concerns an examination or In-Class Test (ICT).
You can access the EC claim form via MyHud or Registry website where
you can also find out more about the process.


You will need to submit independent, verifiable, evidence for your
claim to be considered.
Once your EC claim has been reviewed you will get an EC outcome
email from Registry. If you are unsure what it means or what you
need to do next, please speak to the Student Support Office –
An approved EC will extend the submission date to the next
assessment period (e.g July resit period).
Late Submission
(No ECs approved)
Late submission, up to 5 working days, of the assessment
submission deadline, will result in your grade being capped to a
maximum of a pass mark.
Submission after this period, without an approved extension, will
result in a 0% grade for this assessment component.
Tutor Referral
☐ Yes:
☒ No:
Resources Please note: you can access free office software and you have
1 Tb of free storage space available on Microsoft’s OneDrive system.
This exercise can be carried out purely by studying documentation and
reports. It would, however, be advantageous to install and test working
versions of the DBMSs.
All the software required is available for free download.

Databases and Applications
1. Assignment Aims
This assignment introduces you to some current database products. You will
gain knowledge, and ideally experience, of a range of database systems and
will learn to appreciate the application areas where each might find an
2. Learning Outcomes:
4. Elicit and conceptualise stakeholder needs.
5. Use a range of modelling techniques to produce effective designs for nonrelational databases.
3. Assessment Brief
The module will introduce you to at least seven current commercial database
systems. These include both relational and “NoSQL” databases. In this
assignment you will develop small databases using two of these.
Choose two current widely available database products and develop paperbased demonstration tutorials for each one. The tutorial should briefly explain
a suitable use case for each DBMS and then show clearly how to create and
query a database. If you wish, one of your chosen DBMSs can be relational,
but not both.
You may use any DBMS that is available to you (if in doubt, consult the
module tutor). You will need a working version of the DBMS, and this (along
with ease of installation) may influence your choices.
You are free to use one or more of the case studies you described in the
reading assignment. Indeed, this is probably the easiest way to proceed.
Note that the word limit is again tight. Keep the case study description short.
Note: You are free to use any relational DBMS should you wish to include that
model. However, if you studied CMI3411 last semester you may not use
MySQL (as you did a similar exercise with MySQL there). PostgreSQL or
SQLite are fine, freely available, alternatives.
4. Marking Scheme

Assessment Criterion Weighting %
Case Study 20
Tutorials 50
Clarity 15
Presentation 15

5. Grading Rubric

Criterion Distinction
Pass Marginal Fail Fail
Case Study Case study is very
clearly explained,
along with clear
comments about
appropriateness of
the chosen DBMS.
discussion of
the case
study, that is
relevant to the
strengths of
the chosen
description of
the case study
with some
consideration of
of the DBMS.
description of
the case study
with little
discussion of
the relevance
of the DBMS.
Case study is
absent or very
with no
discussion of
the DBMS.
Tutorials Excellently
articulated tutorials
guide the reader
through the
process of creating
and then using a
Good tutorials
where almost
everything is
included, but
some aspects
are left out or
Tutorials that
cover most
major aspects
but are missing
some details
and/or have
Tutorials do not
really explain
much, make
too many
and/or are
Poor tutorials
that do not
really address
any of the
Clarity Everything is clear
and the tutorials
are basically
potentially ready
for use and
everything is
clear, but
some steps
seem to be
Most things are
clear, but there
are too many
jumps and/or
Many aspects
are unclear; a
reader would
need some
knowledge in
order to follow
Presentation Extremely well
presented with
good use of
screenshots and/or
code samples.
but with some
presentation but
marred by
errors and
with many
and typos.
not what was


The post CMI3509 Databases for Large Data Sets appeared first on My Assignment Online.