kl7011_Advanced Database_The Newbigging_Council Library_Case_study

Programmes: MSc Advanced Computer Science / MSc Data Science Module Code: KL7011 Module Title: Advanced Databases Distributed on: Monday 19th October 2020 Submission Time and Date: Monday 30th November 2020 by 23.59 GMT Date by which Work and Feedback will be returned to Students: 23rd December 2020 Weighting This coursework accounts for 60% of the total marks for this module Submission of Assessment Electronic Management of Assessment (EMA): Please note your assignment is to be submitted electronically and it will be submitted online on Blackboard It is your responsibility to ensure that your assignment is submitted before the submission deadline stated above. See the University policy on late submission of work. Instructions on Assessment: • You are expected to produce a word-processed answer to this assignment. Please use Arial font and a font size of 12. For SQL code and output, you can use courier new font, which preserves SQL format and layout. • You are required to use the Harvard Style of referencing and citation. The “Cite them right” guide is recommended for referencing and citation (Pears and Shields, 2008) which should be followed throughout your answer especially Part 3. Please do not include references to lecture notes. Mapping to Programme Goals and Objectives This assignment covers the following learning outcomes for the module: Knowledge & Understanding: 1. Demonstrate critical understanding of the entire data life cycle and classical database engineering processes and approaches, and non-traditional database systems Intellectual / Professional skills & abilities: 3. Critically analyse, select, apply and evaluate advanced data modelling, database design, implementation and manipulation methods, techniques and tools to a complex data management problem Personal Values Attributes (Global / Cultural awareness, Ethics, Curiosity) (PVA): 5. Develop critical awareness of the responsibilities of database developer with respect to professional, legal, security and ethical issues individually or as part of a team Assessment Regulations You are advised to read the guidance for students regarding assessment policies (Northumbria, 2019). They are available online here. Late submission of work Where coursework is submitted late without approval, after the published hand-in deadline, the following penalties will apply. For coursework submitted up to 1 working day (24 hours) after the published hand-in deadline without approval, 10% of the total marks available for the assessment (i.e.100%) shall be deducted from the assessment mark. Coursework submitted more than 1 working day (24 hours) after the published hand-in deadline without approval will be regarded as not having been completed. A mark of zero will be awarded for the assessment and the module will be failed, irrespective of the overall module mark. These provisions apply to all assessments, including those assessed on a Pass/Fail basis. The full policy can be found here. Students must retain an electronic copy of this assignment (including ALL appendices) and it must be made available within 24hours of them requesting it be re-submitted. Academic Misconduct The Assessment Regulations for Taught Awards (ARTA) contain the Regulations and procedures applying to cheating, plagiarism and other forms of academic misconduct. The full policy is available