Implement the database you designed for Assessment 1 using MySQL


Introduction to Relational Databases

Level: 5

Assessment:                        Assessment 2: Database Implementation

Module Tutor:                      

Weighting in Module:            50%

Hand out:                              Tuesday, 29 September 2020

Hand in:                                on or before midday Tuesday, 5 January 2021                   

                                             All assignments to be submitted using Brightspace

What is required?   Database (from Assessment 1) implemented with MySQL, populated with data and tested with appropriate user queries 1,000-word reflective essay critically analysing the decisions made during the implementation    
Learning outcomes to be assessed:   Demonstrate knowledge and understanding of database design techniques for a given context;   Demonstrate knowledge and understanding of database implementation techniques for a given context.   Use tools to convert logical database designs into physical, relational database implementations;   Use tools to maintain data within and retrieve required information from implemented relational databases.      
Assessment & Grading Criteria: Assessment Criteria 3 & 4 as described in the module specification.  
Assessment Brief. See the attached brief.  

Assessment Criteria

To achieve a Pass in this Assignment, the stated Pass criteria must be achieved

Learning Outcomes Assessed in this Assessment PASS criteria
Demonstrate knowledge and understanding of database design techniques for a given context;    
Demonstrate knowledge and understanding of database implementation techniques for a given context.    
Use tools to convert logical database designs into physical, relational database implementations;    
Use tools to maintain data within and retrieve required information from implemented relational databases.    

Grading criteria follow…….

To achieve a higher grade it is the quality of work that will be considered, rather than the amount of work done, and will be assessed against the given criteria:

Generic Grading criteria for Level 5

Knowledge and Understanding Good Pass Merit Distinction
Demonstrate knowledge and understanding of essential facts, concepts, principles and theories relating to relational databases   Appropriate and consistent application of relevant knowledge. Demonstrate the accurate and consistent use of technical terms and notation. Make clear and appropriate use of relevant theories and techniques. Validate and evaluate results and products effectively using appropriate theories or frameworks.
Cognitive Skills Carries out cognitive tasks more than once Demonstrate the appropriate and consistent application of relevant skills and knowledge. Express a deep understanding of the context of the problem set, the limitations on the solution methodologies, and the evaluation of the final deliverables.  
Research, interpret and analyse technical information, and be able to communicate the results appropriately to specific audiences
Subject Specific Skills Consider or use more than one solution method or technique where appropriate. Use technical skills effectively to produce complete products/artefacts which substantially meet the defined requirements. Use technical skills effectively to produce complete products/artefacts which completely meet the defined requirements.
Deploy appropriate theory, practices and tools for the specification, design, implementation and evaluation of relational databases
Key/transferable skills Be presented or documented clearly. Show evidence of independent learning and activity. Be presented in a professional manner suitable for the intended audience. Demonstrate an individual approach towards the presentation of results and discussion, and towards the solution of the problems involved. Be concise and focussed, with well justified discussions and, where appropriate, useful and accurate illustration.
Evidence the qualities and transferable skills necessary for employment requiring the exercise of personal responsibility and decision making  

Assignment Brief:

  1. Implement the database you designed for Assessment 1 using MySQL
  1. Keep records of the construction of your database (screen-shots or copy/paste text)
  1. Insert test data representative of an operational state and capable of demonstrating the functioning of your database. Keep records of your progress and of testing that your data is correct.
  1. Create a series of SQL queries that are representative of those likely to be used by the intended operators. These should relate to the enquiries from Assignment 1. Keep records of the queries and their results
  1. Write a 1,000-word reflective essay identifying & describing the key decisions made during the implementation of your database; this essay will be based on the journal you were encouraged to keep throughout the build section of the module

Submission requirements:

  1. Screen shots/printouts of the build, population and testing of your database
  1. Your database in electronic form using a ‘mysqldump’ command
  1. 1,000-word reflective essay critically analysing the decisions made during the implementation



Source link

Leave a Reply