ISYS1055 Database Concepts

RMIT Classification: Trusted

School of Science

ISYS1055 Database Concepts

Assessment 4: Database Design Project

RMIT_icon_Industry_connections_Red_RGB.pngAssessment type: Take-home assessmentWord limit: N/A
  RMIT_icon_add_an_event_Red_RGB.png  Due Date: 12 June at 23:59 (Melbourne Time) 
    Weighting: 35%, 35 Marks 

Overview

This is a practical and real-world project that puts the knowledge you gained into practice. You are required to investigate and understand a publicly available dataset, design a conceptual model for storing the dataset in a relational database, apply normalisation techniques to improve the model, build the database according to your design and import the data into your database, 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: Understanding the Data (0 Marks, Preliminary Work)
  • Part B: Designing the Database (10%)
  • Part C: Creating the Database and Importing Data (10%)
  • Part D: Data Retrieval and Visualisation(15%)

Assessment criteria

This assessment will measure your ability to:

  • Analyse the requirements outlined in the problem description
  • Develop a conceptual model for the design of a 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

Page 1 of 8

RMIT Classification: Trusted

  • Create tables on SQLite Studio and populate them with data available from the specified sources.
  • Write SQL statements required for CRUD (create, read, update and delete) operations on the database you built
  • Develop your knowledge further to represent data in a meaningful way using data visualisation.

Course learning outcomes

This assessment is relevant to the following course learning outcomes:

  CLO1Describe the underlying theoretical basis of the relational database model and apply the theories into practice;
CLO2Explain the main concepts for data modelling and characteristics of database systems.
  CLO3Develop a sound database design using conceptual modeling mechanisms such as entity-relationship diagrams.
CLO4Develop a database based on a sound database design;
  CLO5Apply SQL as a programming language to define database schemas, update database contents, and to extract data from databases for specific users’ information needs.

Page 2 of 8

RMIT Classification: Trusted

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.

Text Box: 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 only using the following files. You are required to review and analyse the dataset available in these files. You will find that reviewing the rest of the files, even if not listed below, will help you to form a better understanding about the big picture.

 FILE NAMEDESCRIPTION
1locations.csvCountry names and the type of vaccines administered. Each line represents the last observation in a specific country. Refer to README.md for the details.
2us_state_vaccinations.csvHistory of observations for various locations in the US.
3vaccinations-by-age-group.csvHistory of observations for vaccinations of various age groups in each country.
4vaccinations-by- manufacturer.csvHistory of observations for various types of vaccines used in each country.
5vaccinations.csvCountry-by-country data on global COVID-19 vaccinations. Each line represents an observation date. Refer to README.md for the details.
6country_data/Australia.csvDaily observations of vaccination in Australia.

Page 3 of 8

RMIT Classification: Trusted

7country_data/United States.csvDaily observations of vaccination in the US.
8country_data/England.csvDaily observations of vaccination in England.
9country_data/China.csvDaily observations of vaccination in China.

Table 1: List of data files

To complete the tasks in the following sections, you are required to review and analyse the dataset that is available in the named files.

Part B: Designing the Database (10%)

Task B.1 Produce an ER diagram for a relational database that will be able to store the given dataset.

It is important to note that the given CSV files are not necessarily representing a good design for a relational database. It is your task to design a database that will adhere to good design principles that were taught throughout the course. This means your database schema will not match the structure of the CSV files and, therefore, you will require to manipulate the structure of the dataset (and not the data itself) to import it into your database. Importing the data is required to complete Task C.2.

The ER diagram must be produced by Lucidchart similar to the exercises that were completed in in the course. UML notation is expected and using other notations will not be acceptable. Including a high-quality image representing your model is important, which can be achieved using Export function of Lucidchart.

You are also required to transform the ER diagram into a database schema that will be used in the next part of the assignment.

Creating a good database design typically involves some database normalisation activities. You should document your normalisation activities and support them with good reasoning. This typically involves explaining what the initial design was, what the problem was, and what changes have been made to rectify the issue.

The expected outcome of completing this task is one PDF file named model.pdf containing the following sections.

  1. Database ER diagram and, if needed, a reasonable set of assumptions.
  • Explanation of normalisation challenges and the resulting changes.
  • Database schema.

Part C: Creating the Database and Importing Data (10%)

Task C.1 Produce one SQL script file named database.sql. This script file requires all the SQL statements necessary to create all the database relations and their corresponding integrity constraints as per your proposed design in Part B. The script file must run without any errors in

Page 4 of 8

RMIT Classification: Trusted

SQLite Studio and contain necessary commenting to separate various relations. Note that this script is not supposed to store any data into the relations.

The expected outcome of completing this task is one script file with the specific name of database.sql.

Task C.2 Create a database file named Vaccinations.db. Import the given dataset into your database.

To complete this task, you may need to change the format of the CSV files to match the attributes of your designed database. You can use a spreadsheet editor such as Microsoft Excel.

The next step is to import the spreadsheets into the database you create in SQLite Studio. To complete this task, use the menu option Tools – Import in SQLite.

The expected outcome of completing this task is one database file named Vaccinations.db, which must contain all the data that is stored in the CSV files named in Table 1.

Part D: Data Retrieval and Visualisation (15%)

Now that you have created and populated a database, it is time to create some queries to investigate the data in various ways. In addition to writing the required queries, you are also asked to produce data visualisation for the results of your queries.

The tasks in this section represent the queries that must be supported. Each query must consist of one SQL statement. It would be acceptable to use several nested queries, combine several SELECT statements with various operators etc. However, it would not be acceptable to have multiple and separated queries for each task.

After you have written each query, you are expected to produce a data visualisation for each result set. You have the freedom to choose the tool for creating your visuals (e.g., Excel, Google Charts, Tableau) as well as the visualisation techniques (e.g., charts, plots, diagrams, maps). Completing this portion of the work will require that you understand the nature of the results of each query, undertake research to choose a visualisation tool you are comfortable with, decide about the best technique to visually represent each result set, and produce the visualisation. Answers to tasks in Part D that are not supported by a visualisation can achieve up to 80% of the grade associated with each task.

The expected outcome of completing this task is as follows.

  1. One SQL script file named Queries.sql containing all the queries developed for the tasks in this section. It is important that you add comment lines to separate the queries and indicate which task they belong to. Note that valid SQL comments must not generate errors in SQLite Studio. The marker of your work will use this file to execute and test your queries.
  2. A PDF file named QuerieResults.pdf containing the following elements for each task.
  1. The SQL query

Page 5 of 8

RMIT Classification: Trusted

  • a snapshot of the first 10 results of your query. The snapshot must also show the total number of results retrieved by the query. A sample snapshot is provided below for your reference.

Figure 1: Sample results snapshot with total rows

  • Data visualisation

List of Tasks

Task D.1 For any two given dates (i.e., you can assume any two dates, e.g., 1 April and 3 April), list the dates, the total number of vaccines administered in each observation date in each of all countries, and the difference between the administered vaccines. Each row in the result set must have the following structure. (Note: OD2 is after OD1)

Observation Date 1 (OD1)Country Name (CN)Administered Vaccine on OD1 (VOD1)Observation Date            2 (OD2)Administered Vaccine                      on OD2 (VOD2)Difference of totals (VOD1-VOD2)

Figure 2: Column Headers in the Result Set for Task D.1

Task D.2 Find the countries with the cumulative numbers of COVID-19 doses administered by each bigger than the average doses administered by all countries. Produces a result set containing the name of each country and the cumulative number of doses administered in that country. Each row in the result set must have the following structure.

CountryCumulative Doses

Figure 3: Column Headers in the Result Set for Task D.2

Task D.3 Produce a list of 10 countries with the biggest numbers of vaccine types, with the type of vaccines (e.g., Oxford/AstraZeneca, Pfizer/BioNTech) administered in each country. For a country that has administered several types of vaccine, the result set is required to show several tuples

Page 6 of 8

RMIT Classification: Trusted

reporting each type of vaccine in a separate tuple. Each row in the result set must have the following structure.

CountryVaccine Type

Figure 4: Column Headers in the Result Set for Task D.3

Task D.4 There are different data sources used to produce the dataset. Produce a report showing the total number of vaccines administered according to each data source (i.e., each unique URL). Order the result set by source name and URL. Each row in the result set must have the following structure.

Source NameTotal Administered VaccinesSource URL

Figure 5: Column Headers in the Result Set for Task D.4

Task D.5 How does various countries compare in the speed of their vaccine administration? Produce a report that lists all the observation dates in 2022 and, for each date, list the total number of people fully vaccinated in each one of the 4 countries used in this assignment.

[Date, Australia, United States, England, China]

DateAustraliaUnited StatesEnglandChina

Submission Format

Figure 6: Column Headers in the Result Set for Task D.5

You are required to submit the files with the exact names as below.

  1. Model.pdf
  2. Database.sql
  3. Vaccinations.db
  4. Queries.sql
  5. Queries.pdf

In the previous sections of the assignment, the expected content of each of the files is explained in detail.

Referencing guidelines

Use RMIT Harvard referencing style for this assessment.

You must acknowledge all the courses of information you have used in your assessments.

Refer to the RMIT Easy Cite referencing tool to see examples and tips on how to reference in the appropriated style. You can also refer to the library referencing page for more tools such as EndNote, referencing tutorials and referencing guides for printing.

Academic integrity and plagiarism

Academic integrity is about honest presentation of your academic work. It means acknowledging the work of others while developing your own insights, knowledge, and ideas.

You should take extreme care that you have:

Page 7 of 8

RMIT Classification: Trusted

  • Acknowledged words, data, diagrams, models, frameworks and/or ideas of others you have quoted (i.e., directly copied), summarised, paraphrased, discussed, or mentioned in your assessment through the appropriate referencing methods.
  • Provided a reference list of the publication details so your reader can locate the source if necessary. This includes material taken from Internet sites.

If you do not acknowledge the sources of your material, you may be accused of plagiarism because you have passed off the work and ideas of another person without appropriate referencing, as if they were your own.

RMIT University treats plagiarism as a very serious offence constituting misconduct. Plagiarism covers a variety of inappropriate behaviours, including:

  • Failure to properly document a source
  • Copyright material from the internet or databases
  • Collusion between students

For further information on our policies and procedures, please refer to the University website.

Assessment declaration

When you submit work electronically, you agree to the assessment declaration.

Page 8 of 8

Order Now

Get expert help for ISYS1055 Database Concepts and many more. 24X7 help, plag free solution. Order online now!

Universal Assignment (June 7, 2023) ISYS1055 Database Concepts. Retrieved from https://universalassignment.com/isys1055-database-concepts/.
"ISYS1055 Database Concepts." Universal Assignment - June 7, 2023, https://universalassignment.com/isys1055-database-concepts/
Universal Assignment July 26, 2022 ISYS1055 Database Concepts., viewed June 7, 2023,<https://universalassignment.com/isys1055-database-concepts/>
Universal Assignment - ISYS1055 Database Concepts. [Internet]. [Accessed June 7, 2023]. Available from: https://universalassignment.com/isys1055-database-concepts/
"ISYS1055 Database Concepts." Universal Assignment - Accessed June 7, 2023. https://universalassignment.com/isys1055-database-concepts/
"ISYS1055 Database Concepts." Universal Assignment [Online]. Available: https://universalassignment.com/isys1055-database-concepts/. [Accessed: June 7, 2023]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Get 90%* Discount on Assignment Help

Most Frequent Questions & Answers

Universal Assignment Services is the best place to get help in your all kind of assignment help. We have 172+ experts available, who can help you to get HD+ grades. We also provide Free Plag report, Free Revisions,Best Price in the industry guaranteed.

We provide all kinds of assignmednt help, Report writing, Essay Writing, Dissertations, Thesis writing, Research Proposal, Research Report, Home work help, Question Answers help, Case studies, mathematical and Statistical tasks, Website development, Android application, Resume/CV writing, SOP(Statement of Purpose) Writing, Blog/Article, Poster making and so on.

We are available round the clock, 24X7, 365 days. You can appach us to our Whatsapp number +1 (613)778 8542 or email to info@universalassignment.com . We provide Free revision policy, if you need and revisions to be done on the task, we will do the same for you as soon as possible.

We provide services mainly to all major institutes and Universities in Australia, Canada, China, Malaysia, India, South Africa, New Zealand, Singapore, the United Arab Emirates, the United Kingdom, and the United States.

We provide lucrative discounts from 28% to 70% as per the wordcount, Technicality, Deadline and the number of your previous assignments done with us.

After your assignment request our team will check and update you the best suitable service for you alongwith the charges for the task. After confirmation and payment team will start the work and provide the task as per the deadline.

Yes, we will provide Plagirism free task and a free turnitin report along with the task without any extra cost.

No, if the main requirement is same, you don’t have to pay any additional amount. But it there is a additional requirement, then you have to pay the balance amount in order to get the revised solution.

The Fees are as minimum as $10 per page(1 page=250 words) and in case of a big task, we provide huge discounts.

We accept all the major Credit and Debit Cards for the payment. We do accept Paypal also.

Popular Assignments

BAFI 3257 – Corporate Financial Management

School of Economics, Finance and Marketing Master of Finance BAFI 3257 – Corporate Financial Management ASSESSMENT TASK 3 – INDIVIDUAL ASSIGNMENT Semester 1 – 2021 Marks Due Date Submission Instructions Objective In this assignment, you are required to apply techniques and concepts acquired in this course to analyse and provide

Read More »

MMP742 – Investment Valuation

MMP742 – Investment Valuation Trimester 1, 2021 Assessment Task 2 DUE DATE AND TIME:                        Week 10, 17/05/2021, 8PM (AEST) PERCENTAGE OF FINAL GRADE:        25% WORD COUNT:                                   2,500 words Learning Outcome Details Unit Learning Outcome (ULO) Graduate Learning Outcome (GLO) ULO 1: Collect, evaluate and interpret market data relevant to property

Read More »

Initial Instructions: Research Report

General Information For this assignment, the class will participate in a simple research project which you will write up as a research report with the following sections: Abstract, Introduction, Method, Results, Discussion and References. In order to successfully complete this assignment, you will need to I encourage you to work

Read More »

LST3LPC Policy Proposal

Due: Tuesday October 26 (11:59pm) Size: 1500 words Worth: 40% Submission: Turnitin Description Students are required to produce a policy proposal, including the discussion of a social issue, policy options and recommendations. To support students to complete this task comprehensively and in accordance with expectations for policy proposals produced outside

Read More »

HLT54115 Diploma of Nursing

Assessment 2: Literature Review- Evidence-Based Practice HLT54115 Diploma of Nursing CHCPOL003 Research and apply evidence to practice Instructions for Student Instructions Select one of the topics below and undertake a literature review using evidence-based Practice (EBP).   Topics The impacts of effective hand hygiene practices in nursing.Improvements in nursing interventions

Read More »

Assessment 2 – Narrated Presentation

Assessment 2 – Narrated Presentation Assessment Type Narrated Presentation of an Educational Resource Description: Teaching and Learning Outline.  In this assessment item you are required to: 1. Topic is: Blood Glucose level management and subcutaneous insulin application for patients with type 2 diabetes. 2. Conceptualise an educational resource that will

Read More »

FOOD PANDA Case Study

FOOD PANDA Question 2 – Delivery performance measure Delivery Performance is the level at which an organization’s provision of products and services meets the criteria anticipated by its consumers. To achieve maximum client happiness, service providers must focus on quality. The top 2 approaches performance measure to evaluate their food

Read More »

BUSN3003 Exam – Session 2, 2021

BUSN3003 Exam – Session 2, 2021 Instructions: Please save this document onto your computer. Type your answers into the document, saving the document as you go – you don’t want to lose any answers! Once complete, upload the final document via the Turnitin Exam Submission Link on the Blackboard site

Read More »

Hospitality Services Management

Hospitality Services Management Group members: each doing 7 marks worth Chloe Kate Tori Gideon Assessment 2 Group Task – (using a Wiki) A Group Task, using a Wiki, to create a new service organisation Related Topics: 3, 4, 5 & 6. You have been assigned to a group drawn from

Read More »

Development and Construction – Assignment 3

Development and Construction – Assignment 3 Marking Guide This is a guide to help you with the structuring of your report and highlighting what specific information should be included in your report. You should use information from your previous assignments, including designs and the feasibility study, as the basis for

Read More »

Case Analysis Sarita

Sarita due Sunday 12 September 2021 2500 words ± 10% You will be marked against the criteria in the marking rubric for Case analysis. Theme  5 Stress response in health and illness and theme 6 Immunology concepts Weighting: 50% referenced using APA style. • ll written assessments are to be

Read More »

Assignment 1: Argumentative Essay

Assignment 1: Argumentative Essay Topic Healthcare professionals have an ethical responsibility to always advocate for the introduction of new treatments and technologies into healthcare. Instructions In relation to your selected topic: • Consider the application of the bioethical principles. • Consider the application of ethical theories and other ethical concepts.

Read More »

Healthcare Ethics Argumentative essay

ASSESSMENT INFORMATION   Assessment Title   Argumentative essay     Purpose The purpose of this assessment is for students to demonstrate the capacity to develop an ethical argument/s based around the four bio-ethical principles: autonomy, justice, beneficence, and non-maleficence. Students will use their chosen topic to develop a sound ethical

Read More »

Marking Guide for Assessment 1 Part B: Reflection

Marking Guide for Assessment 1 Part B: Reflection Reflection (Total of 30 marks) – Due 31st October 2021 Reflect on the desirable qualities of counselling and how these qualities shape your approach and values to counselling and/or developing a therapeutic professional relationship. Reflect on your PART A reflection and consider

Read More »

Critical Reflection scenario-based essay

Purpose: The purpose of this assessment is to deepen student’s understanding of the characteristics of leadership styles and the dynamic relationship of leadership with workplace communication and culture. Aim: This assessment provides the student the opportunity to apply and evaluate leadership styles in a scenario involving making changes to improve workplace

Read More »

MBA621 Healthcare Systems

Assessment 2 Information Subject Code: MBA621 Subject Name: Assessment Title: Assessment Type: Length: Case Study Slide Deck Individual PowerPoint presentation slides with notes 2000 words (+/- 10% allowable range) 20 slides with 100 words per slide Weighting: 35% Total Marks: Submission: 100 Online Due Date: Weeks 7 Your task Develop

Read More »

MATH7017: Probabilistic Models and Inference

MATH7017: Probabilistic Models and Inference, Project 2023                    (total: 40 points) Conditional Generation with Variational Autoencoders and Generative Adversarial Networks Overview In this project, you will work with Variational Autoencoders (VAEs) and Generative Adversarial Networks (GANs). You will build and train conditional versions of these models to generate MNIST digits given

Read More »

Surveying Plan Assignment Help

Submission Component and Marks Awarded Marks   PLAN:     Find Scale of plan and explain 4   9 Bearing and Distances of three lines 3 Plan Presentation 2 HORIZONTAL ALIGNMENT     Deflection Angles 4   18 Curve Elements 4 Chainages along the Road 10 VERTICAL ALIGNMENT:    

Read More »

NURBN3034 Assessment Task

NURBN3034 Assessment Task 1a Global Health Issues Group ePoster Presentation Weighting: 30% Due date: Thursday August 18th 13.59pm each group Purpose: The purpose of this learning task is to choose one of the following global health issues that under the right conditions has or is likely to have a significant

Read More »

ISYS3375 Business Analytics

School of Business, IT and Logistics — ISYS3375 Business Analytics Assessment 2: Case Study Assessment Type: Individual report                                               Word limit: 2000-3000 (+/– 10%) Each Table or Figure is counted as Due date: Sunday of Week 5 23:59 (Melbourne time) Weighting: 35% 50 words + the number of words in its

Read More »

NURBN3032 Task 2: Managing a Transition to Practice Issue

NURBN3032 Task 2: Managing a Transition to Practice Issue Weight: 60% Due: Thursday 18th May (Week 11) In this task, students are required to demonstrate knowledge relating to understanding and addressing a transitional issue that can affect new graduate nurses. Using evidence from current scholarly literature (i.e., less than seven

Read More »

ATS2561 Sex and the Media

Assessment Guide – Research Essay Due: Friday Week 12, submit on Moodle Weighting: 40% Length: 2000 words Write an essay responding to one of the following questions/topics: ‘objectifying’ images might be different, or that they should be understood as the same, for men and women. Your argument should address why

Read More »

ITC597 Digital Forensics

ITC597 Digital Forensics – SAMPLE EXAM ONLY This paper is for Distance Education (Distance), Port Macquarie, Study Centre Sydney and Study Centre Melbourne students. EXAM CONDITIONS: NO REFERENCE MATERIALS PERMITTED No calculator is permitted No dictionary permitted WRITING TIME:                     2 hours plus 10 minutes reading time Writing is permitted during

Read More »

Simulation Project- Computer Lab Project

Model and analyse the communication tower at the Casuarina campus. Apply dead, live and wind load as per in AS 1170 or other relevant standards in SAP2000. You should measure size of the elements as far as you can from or make reasonable assumptions about the dimensions. Reasonable assumptions should

Read More »

COM621 UX Strategy

Solent University Coursework Assessment Submission Module Name:    UX Strategy Module Code:    COM621 Module Leader: Assessment Submission Date: Student Number: UX Strategy Contents Part 1 – Introduction to System (1K words) 2 1.0 Introduction. 2 1.1       Current SUAA UX Design and Business Model 2 1.2       Academic and Market Research. 3 1.3      

Read More »

MIT302 Internet of Things

Group Presentation and Video (part 2) Unit:             MIT302 Internet of Things Due Date:       09/06/2023 Total Marks:    This assessment is worth 10% of the full marks in the unit. Instructions: 1.        Students are required to cover all stated requirements. 3.        Please save the document as: MIT302_Firstname_Surname_StudentNumber[assessment1].ppt Requirements: Write a PowerPoint of

Read More »

Can't Find Your Assignment?

Open chat
1
Free Assistance
Universal Assignment
Hello 👋
How can we help you?