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 ongoing research andpractical deployment of this field of study.
This assignment assesses your skills in:
• Designing and implementing a database system
• Conveying your knowledge of database systems
• Use of T-SQL
• Knowledge on ethical, legal and data protection issues in the database systems
The module notes are enough literature for completing this assignment successfully.
• The assignment must be implemented using T-SQL, and any data should be stored in a Microsoft SQL server database. SQL statements should be stored in plain text files. Your submission must run on a computer with Microsoft SQL Server 2012, 2014,2016 or 2017.
For the successful completion of this assignment, a total of 75 hours should be budgeted.
Imagineyouareemployed asadatabase 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 the child poverty data. 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 visualisationssouserscanfindusefulinformation.Itcanalsoallowyoutobuildpaginatedreportsidealfor 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 (https://www.younglives.org.uk/) 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 afront endof the reporting system.
Youwillprovideareport detailing yoursuggested schema and advice. In addition tothedatabase schema, theclient also requiresworking T-SQL statements, withmeaningfulcomments 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.
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.
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.
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
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
