数据库代写 | ISYS1055 Database Concepts Assessment 4 Database Design Project

itcsdaixie％1 $ S

本次澳洲代写是一个数据库设计和开发的assignment

Overview

You are required to investigate and understand a publicly available dataset, design a conceptual model for storing
the dataset in a relational database, build the database according to your design and host the data, and develop
SQL queries in response to a set of requirements.

The objective of this assignment is to reinforce what you have learned in the whole course. Specifically, it involves
how to build a simple application that connects to a database backend, running a simple relational schema.

  • Part A: Part A: Understanding the Data (0 Marks, Preliminary Work)
  • Part B: Designing the Database (10%)
  • Part C: Creating the Database (10%)
  • Part D: Data Retrieval (15%)

Assessment criteria

This assessment will measure your ability to:

  • Analyse the requirements outlined in the problem description
  • Develop a conceptual model to assist you with the design of the database backend required for the
    system
  • Use an industry-standard ER modelling tool to draw the ER model
  • Use 7-step mapping process to create relational database schema
  • Use normalisation process to evaluate the schema and make sure that all the relations are at least
    3NF
  • Create tables on SQLite Studio and populate them with data available from the sources outlined above
  • Write SQL statements required for CRUD (create, read, update, and delete) operations on the database you built

Assessment details

Part A: Understanding the Data

In this assignment, we are working with the publicly available dataset: A Global Database of COVID-
19 Vaccinations. Further details about this dataset are available in the article available through the
following URL: https://www.nature.com/articles/s41562-021-01122-8. The abstract of the article is
as follows.

An effective rollout of vaccinations against COVID-19 offers the most promising prospect
of bringing the pandemic to an end. We present the Our World in Data COVID-19
vaccination dataset, a global public dataset that tracks the scale and rate of the vaccine
rollout across the world. This dataset is updated regularly and includes data on the total
number of vaccinations administered, first and second doses administered, daily
vaccination rates and population-adjusted coverage for all countries for which data are
available (169 countries as of 7 April 2021). It will be maintained as the global vaccination
campaign continues to progress. This resource aids policymakers and researchers in
understanding the rate of current and potential vaccine rollout; the interactions with
non-vaccination policy responses; the potential impact of vaccinations on pandemic
outcomes such as transmission, morbidity and mortality; and global inequalities in
vaccine access.

A live version of the vaccination dataset and documentation are available in a public GitHub
repository at https://github.com/owid/covid-19-data/tree/master/public/data/vaccinations. These
data can be downloaded in CSV and JSON formats.

For the purposes of completing this assignment, we are using the following files. You may review the
other files available as part of the dataset for a better understanding of it.

程序代写代做C/C++/JAVA/安卓/PYTHON/留学生/PHP/APP开发/MATLAB

本网站支持淘宝 支付宝 微信支付  paypal等等交易。如果不放心可以用淘宝交易！

E-mail: itcsdx@outlook.com  微信:itcsdx

如果您使用手机请先保存二维码，微信识别。如果用电脑，直接掏出手机果断扫描。

发表评论