University : Others UniLearnO is not sponsored or endorsed by this college or university.
Country : United Kingdom
Assignment Task :

 Learning Outcomes: 

Provide a broad overview of the general field of 'database systems' and to develop specialised knowledge in areas that demonstrate the interaction and synergy between ongoing research and practical deployment of this field of study

Key Skills to be Assessed 

This assignment assesses your skills in: 

Designing and implementing a database systema 

Conveying your knowledge of database systems 

Use of T-SQL 

Knowledge on ethical, legal and data protection issues in the database systems 

Task 1: 

Imagine you are employed as a database developer for an international charity organisation (the client). The client is currently in the process of developing a reporting tool called Child Well-Being Monitor  to analyse child poverty. A software developer will develop the functionality of the front-end reporting  tool. 

Child Well-Being Monitor is a simple and low-cost web-based reporting solution which can be used  to analyse child poverty. It allows users to extract and present data in charts, tables, and other  visualisations so users can find useful information. It can also allow you to build paginated reports ideal for  printing. The purpose of this tool is to translate data into actionable information to understand child  poverty in lower-income countries. and build several reports to understand Child poverty in lower- income countries. The Young Lives survey is an innovative long-term project investigating the changing nature of childhood poverty in four developing countries. The purpose of the project is to improve understanding of the causes and consequences of childhood poverty and examine how policies affect children's well-being, in order to inform the development of future policy and to target child welfare interventions more effectively. The study is being conducted in Ethiopia, India, Peru and Vietnam. These countries were selected because they reflect a range of cultural, geographical and social contexts and experience a variety issues facing the developing world, high debt burden, emergence from conflict, and vulnerability to environmental conditions such as drought and flood. The Young Lives study aims to track the lives of 12,000 children over 15 years, surveyed once every 3-4 years. Round 1 of Young Lives surveyed two groups of children in each country, at 1 year old and 5 years old. Round 2 returned to the same children who were then aged 5 and 12 years old. Round 3 surveyed the same children again at aged 7-8 years and 14-15 years, Round 4 surveyed them at 12 and 19 years old, and Round 5 surveyed them at 15 and 22 years old. It is sponsored by the 

Department for International Development and conducted by the Young Lives team based at theStudents are required to register and apply for a password with the UK Data Service and sign a confidentiality agreement before they can access the data. The client requires your knowledge and expertise to design, implement and test a database system for this reporting system. So, that software developer can build a front end of the reporting system. You will provide a report detailing your suggested schema and advice. In addition to the database schema, the client also requires working T-SQL statements, with meaningful comments to achieve the following: 

Insert the full dataset from the Young Lives data repository to the local SQL Server database. 

• Create all the tables using T-SQL. 

• Create various summarised reports that allow you to measure the child poverty in Ethiopia, India, Peru and Vietnam (minimum 5 reports). 

• Include filtering, sorting and grouping functionality in the reports. 

• Include various search facilities in the Child Well-Being Monitor. 

• Include concurrency techniques in the statements to ensure that the database remains in a consistent state when multiple users access it simultaneously. 

Extra features to be implemented To get more than a “Satisfactory” mark, a number of extra features should be implemented. Features include, but are not limited to: 

• Use of views 

• Use of stored procedures 

• Use of system functions and user-defined functions 

• Consider data protection issues as part of the design and implementation of your solution. 

Task 2 

The client is planning to initiate a project helping children from low-income families in Vietnam. They require to analysis the inequality in the education sector in Vietnam. Therefore, they require to analysis and generate an overview report using Young Lives: School Survey, Vietnam, 2016-2017 dataset. A school survey was introduced into Young Lives Project in 2010, following the third round of the household survey, in order to capture detailed information about children's experiences of schooling and to improve our understanding of the relationships between learning outcomes, and children's home backgrounds, gender, work, schools, teachers and class and school peer-groups The survey consists of three main elements: a child questionnaire, a household questionnaire and a community questionnaire. It covers a range of topics such as household composition, livelihood and assets, household expenditure, child health and access to essential services, and education. This is supplemented with additional questions that cover caregiver perceptions, attitudes, and aspirations for their child and the family. The client requires your knowledge and expertise to design, implement and test a simple reporting system for this project using SQL Server and Microsoft Excel. Use Microsoft Excel as a presentation layer. You will provide a report detailing your approach and proposed frond-end design in Microsoft excel. You will also provide your SQL statements with appropriate comments and a full backup of your database. In addition to the front-end design, the client also requires working T-SQL statements, with meaningful comments to achieve the following: 

• Insert the full dataset from the School Survey, Vietnam, 2016-2017 dataset to local SQL Server database. 

• Create all the tables and Views using T-SQL. 

• Create various summarised reports in Excel, which project participants can use to measure and understand the inequality in the education sector in Vietnam (minimum 3 reports). 

• Include filtering, sorting and grouping functionality in the reports. 

• Include various charts in the reports. 

• Consider data protection issues as part of the design and implementation of your solution. 

Task 3:

Imagine you are employed as a Research Assistance by the University of Salford for an academic research project. The objective of the project is to develop a reporting tool called Crime Profiler to  assist in the development of computational criminology as a part of the advancement of the theory and method in criminological research. As a part of the project, you have been given a task to build a report containing Lower Layer Super Output Areas (LSOAs) wise crime report with local population 

The principal investigator of the research project requires your knowledge and expertise to design and implement a simple reporting system using SQL Server and Microsoft Excel. Use Microsoft Excel as a presentation layer. You should provide a report detailing your approach and proposed frond-end design. In addition to the front-end design, the principal investigator also requires working T-SQL statements, Excel files, QGIS Maps and Screen Shots (where appropriate) to achieve the following:

Insert required Crimes data from the Police data repository to a local SQL Server database. 

Insert required Lower Layer Super Output Areas (LSOAs) data to a local SQL Server database. 

Create all the tables and Views using T-SQL. 

Create a summarised LSOAs wise crime report with local population data in Greater Manchester between Jan 2017 and Dec 2018. 

Include filtering, sorting and grouping functionality in the Excel report. 

 

This Business Assignment has been solved by our Business Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

  • Uploaded By : Alex Cerry
  • Posted on : April 20th, 2019
  • Downloads : 191

Whatsapp Tap to ChatGet instant assistance