1
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: A.Jenkins@hud.ac.uk |
| Module Tutor/s |
| Hand-out date | Week Commencing 20th January 2020. |
| How to submit your work |
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 times |
Submit before 11:59 on Tuesday 21st April 2020. |
| Expected amount of independent time you should allocate to complete this assessment |
About 15 hours. |
| Submission type and format |
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. http://www.hud.ac.uk/registry/regulationsandpolicies/studentregs. Please pay special attention to the assessment regulations (section 4) on Academic Misconduct. |
2
| 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 sources. Further guidance can be found in the SCEN Academic Skills Resource and UoH Academic Integrity Resource module in Brightspace. 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. (sce.guidance@hud.ac.uk). |
|
| Requesting an Extension |
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 (sce.guidance@hud.ac.uk), as you may need to submit a claim for Extenuating Circumstances (ECs). |
| Extenuating 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 https://www.hud.ac.uk/registry/extenuatingcircumstancesfaqs where you can also find out more about the process. |
3
| 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 – SJ1/01 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 available |
☐ 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. https://students.hud.ac.uk/it/unimail/office365/ |
| 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. |
4
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
application.
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
5. Grading Rubric
| Criterion | Distinction (70+) |
Good Pass |
Pass | Marginal Fail | Fail |
| Case Study | Case study is very clearly explained, along with clear comments about the appropriateness of the chosen DBMS. |
Clear discussion of the case study, that is relevant to the strengths of the chosen DBMS. |
Adequate description of the case study with some consideration of the appropriateness of the DBMS. |
Barely adequate description of the case study with little discussion of the relevance of the DBMS. |
Case study is absent or very poorly described, with no discussion of the DBMS. |
| Tutorials | Excellently articulated tutorials that comprehensively guide the reader through the process of creating and then using a database. |
Good tutorials where almost everything is included, but some aspects are left out or poorly explained. |
Tutorials that cover most major aspects but are missing some details and/or have errors. |
Tutorials do not really explain much, make too many assumptions and/or are generally inadequate. |
Poor tutorials that do not really address any of the relevant issues. |
| Clarity | Everything is clear and the tutorials are basically potentially ready for use and distribution. |
Generally everything is clear, but some steps seem to be missing. |
Most things are clear, but there are too many jumps and/or assumptions made. |
Many aspects are unclear; a reader would need some knowledge in order to follow this. |
Incoherent. |
| Presentation | Extremely well presented with good use of screenshots and/or code samples. |
Good presentation, but with some lapses. |
Acceptable presentation but marred by errors and typos. |
Poor presentation, with many errors, inconsistencies and typos. |
Incoherent, not what was required. |
6
The post CMI3509 Databases for Large Data Sets appeared first on My Assignment Online.