Learning Outcomes of this 33386, 34902 Advanced Database Assignment

The learning outcomes covered by this assignment are:

• 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 on going research and practical deployment of this field of study.

Key Skills to be Assessed for 33386, 34902 Advanced Database Assignment

This assignment assesses your skills in:
• Designing and implementing a database systems
• Conveying your knowledge of database systems
• Use of T-SQL
• Knowledge on ethical, legal and data protection issues in the database systems

Recommended Reading

The module notes are sufficient literature for completing this assignment successfully.

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.

The client is initially planning to import data from the Young Lives project 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 the University of Oxford.

Students 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.

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 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 data in Greater Manchester between Jan 2017 and Dec 2018. Data can be downloaded from below links.

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.

ORDER This 33386, 34902 Advanced Database Assignment NOW And Get Instant Discount