• Home
• Homework Help UK
• CSY3024: Databases 3

CSY3024: Databases 3 | Homework Help UK

Faculty of Arts, Science and Technology
CSY3024 (Databases 3)
Level 6   
Assignment 1
University of Northampton  

Learning Outcomes Assessed:

LO1 Learning to learn: recognise their own major areas of weakness and accept the need for further work in those areas.

LO2 Design, build, and test a simplified database applications, corresponding to a particular specification.

LO3 Communication skills: outline the function and intercommunication between the various hardware/software components of a deployed application.

Introduction

This assignment is compulsory as it is a major part of the formal assessment. Read this document carefully and make sure that you are clear about what you have to do, and what you have to hand in, before you attempt the assignment.

You could demonstrate your work to the module tutor during practical sessions for formative feedback prior to the submission date.

This assignment has two main parts as below:

1. Part 1 (50%) –learning diary including lab exercises and reflection. Lab exercises will be given during usual teaching sessions. In the diary, the following can be included: approaches to the assigned tasks; what worked and what didn’t and the reason(s); what the solution(s) were; what have been learnt from the exercises and what still need to be improved, etc.
   Note : 1) to get the highest grade for this part , students need to complete ALL the lab exercises with some extra attempts and write good individual reflection on them; 2) for the reflection, do not just summarise what’s covered in the lecture or what activities have been done; instead, students need to summarise their understanding of the topics being practiced, using their own words; 3 ) It’s students’ responsibility to keep their diary in a secure place such as Dropbox, or use o nline tools such as Google Doc;
2. Part 2 (50%) - development of a graph database for a given data set , which can be found in the ‘Assignment’ section on NILE. The dataset contains information about the English Premier League (EPL) matches. Students are expected to design and create a graph database to visualise the dataset and to answer the following queries:
   
   1. Display total number of matches played.
   2. Display details of all matches involved “Arsenal FC”
   3. Display the number of matches “Liverpool FC” has lost.
   4. Display top five teams that have best scoring power.
   5. Display top five teams that have poorest defending.
   6. Display top five teams that have best winning records.
   7. Display top five teams with best home winning records.
   8. Displa y top five teams with worst home losing recording.
   9. Which teams had most “draw”?
   10. display the team with most consecutive “wins” .