business intelligence and database
MIS781 Business Intelligence and Database
Trimester 2, 2020
Group Assignment: Database Design and Report
DUE DATE AND TIME:
PERCENTAGE OF FINAL GRADE:
WORD LIMIT:
Friday 28th August 2020 (Week 6) 8:00pm AEST
20%
2000 words
Learning Outcome Details
Unit Learning Outcome (ULO) Graduate Learning Outcome (GLO)
ULO1: Explain and apply the business intelligence GLO1: Discipline-specific knowledge and capabilities –
(BI) lifecycle concept, multidimensionality students are required to demonstrate an
concept and database concept understanding of the business intelligence context
and explain the BI and database technologies and
ULO2: Appraise and apply data warehousing associated implementation issues.
architecture, technologies and development
methodologies and database for business GLO3: Digital Literacy – students are required to apply
intelligence. BI and database technologies to find, use and
disseminate actionable information.
ULO3: Collaborate constructively in a team to use
BI and database technologies for implementation GLO7: Teamwork – students are expected to
of innovative BI solutions and better collaborate constructively in a team to appraise
dissemination of information. business intelligence and database requirements and
develop BI solutions.
Assessment Feedback:
Students who submit their work by the due date will receive their marks and feedback on
CloudDeakin on 18th Sept 2020 (Friday; 5pm).
Description / Requirement
In this group assignment, teams of 3 students will design database and produce a report to explain
the database.
Students are required to apply the database and normalization knowledge to analyse database
requirements and associated business intelligence needs (see individual practical assignment
requirement) within COVID-19 pandemic setting. Based on the database design, students will
provide data to showcase the database.
Deakin’s Bachelor of Commerce and MBA are internationally EPAS accredited.
Deakin Business School is accredited by AACSB and EQUIS.
https://www.efmd.org/index.php/accreditation-main/epas
http://www.aacsb.edu/
Tasks:
1. A typical COVID-19 pandemic database collects large amount of data, e.g.,
confirmed cases, deaths, recovered, case-fatality ratio, testing rate, hospitalisation
rate, filtered by country, state, etc.
2. Your task is to analyse the COVID-19 database requirement and design a database
that considers normalization. You must explain each of your normal form tables and
provide: unnormalized form (UNF) or 1NF, 2NF, and 3NF tables to depict your work.
3. You must produce the database tables in MS Word or Excel table format. The
tables can be reused for your practical assignment (BI dashboards). For 1NF, 3
tables are expected (with at least 5 rows for each field of the tables; hence each
group member can develop one table). In the written report, you must explain the
table structure, define the data field/attribute and the data type, and provide
details of the business rule, primary key, etc (include any assumptions that you
may have made). As a group assignment, there should be only one set of business
rules for all tables. An example of 1NF table is provided below.
Doctor Name Address Phone Dept Patient Patient Room Room Bed
ID ID ID Name ID Type ID
D123 Dr. Peter Abc123 04123 Neurology P11 Bill R1 Royal B7
Smith Singer
D456 Dr. Casey Def123 04456 ICU P22 Jill Star R2 Normal B8
Lee
D789 Dr. John Ghi123 04987 ENT P33 Penny Hill R3 VIP B4
Rock
4. The entire assignment should be discussed and presented as one coherent report.
The written should include: 1) objectives of your database design, 2) tables, data
fields and commentary, 3) benefits of your database design, overall justifications,
etc. Feel free to make reasonable assumptions. You may create your own artificial
datasets. Real-world dataset is not compulsory. Note: Do refer to the assignment
marking rubric.
5. Fill out this peer evaluation form (due by 31st Aug 2020 Monday 8pm).
Some useful links:
1. https://coronavirus.jhu.edu/map.html
2. https://www.abs.gov.au/
3. https://data.oecd.org/
4. https://data.un.org/
5. https://www.data.gov/
6. https://www.who.int/data
7. https://www.who.int/gho/database/en/
8. https://github.com/CSSEGISandData/COVID-19
9. https://www.health.gov.au/news/health-alerts/novel-coronavirus-2019-ncov-
health-alert/coronavirus-covid-19-current-situation-and-case-numbers
10. https://www.who.int/emergencies/diseases/novel-coronavirus-2019
Page 2 of 4
https://docs.google.com/forms/d/e/1FAIpQLScTkqVT-E_gDWd2S274ovSWJ4nflTRne9hXYd0EpPyr2J8BwA/viewform
https://coronavirus.jhu.edu/map.html
https://www.abs.gov.au/
https://data.oecd.org/
https://data.un.org/
https://www.data.gov/
https://www.who.int/data
https://www.who.int/gho/database/en/
https://github.com/CSSEGISandData/COVID-19
https://www.health.gov.au/news/health-alerts/novel-coronavirus-2019-ncov-health-alert/coronavirus-covid-19-current-situation-and-case-numbers
https://www.health.gov.au/news/health-alerts/novel-coronavirus-2019-ncov-health-alert/coronavirus-covid-19-current-situation-and-case-numbers
https://www.health.gov.au/news/health-alerts/novel-coronavirus-2019-ncov-health-alert/coronavirus-covid-19-current-situation-and-case-numbers
https://www.who.int/emergencies/diseases/novel-coronavirus-2019
Report guidelines
1. The body of the report should contain ‘Table of Content’, logically organised sections, and
‘List of references’.
2. Apply only APA referencing format, see:
https://www.deakin.edu.au/students/studying/study-support/referencing/apa-6
3. You may include figures, diagrams, tables and charts, etc.
4. The length of the assignment includes everything (e.g. Table of content and Reference list).
The minimum words limit is 1800 words, and maximum words limit is 2999 words. Note:
Although at least 5 rows are expected, but more rows can be added to better depict your
table.
5. Reports should be written in Microsoft Word and submitted as a Word file (PDF file will not
be marked).
6. Assignments are to be submitted online to the CloudDeakin dropbox (see submission details
below).
7. Format: Times New Roman, font size 12 & line spacing 1.5
Submission Instructions
You must keep a backup copy of every assignment you submit, until the marked assignment has
been returned to you. In the unlikely event that one of your assignments is misplaced, you will
need to submit your backup copy.
Any work you submit may be checked by electronic or other means for the purposes of detecting
collusion and/or plagiarism.
When you are required to submit an assignment through your CloudDeakin unit site, you will
receive an email to your Deakin email address confirming that it has been submitted. You should
check that you can see your assignment in the Submissions view of the Assignment dropbox folder
after upload, and check for, and keep, the email receipt for the submission.
Page 3 of 4
https://www.deakin.edu.au/students/studying/study-support/referencing/apa-6
Notes
• Penalties for late submission: The following marking penalties will apply if you submit an
assessment task after the due date without an approved extension: 5% will be deducted
from available marks for each day up to five days, and work that is submitted more than five
days after the due date will not be marked. You will receive 0% for the task. ‘Day’ means
working day for paper submissions and calendar day for electronic submissions. The Unit
Chair may refuse to accept a late submission where it is unreasonable or impracticable to
assess the task after the due date.
• For more information about academic misconduct, special consideration, extensions, and
assessment feedback, please refer to the document Your rights and responsibilities as a
student in this Unit in the first folder next to the Unit Guide of the Resources area in the
CloudDeakin unit site.
• Building evidence of your experiences, skills and knowledge (Portfolio) – Building a portfolio
that evidences your skills, knowledge and experience will provide you with a valuable tool to
help you prepare for interviews and to showcase to potential employers. There are a number of
tools that you can use to build a portfolio. You are provided with cloud space through OneDrive,
or through the Portfolio tool in the Cloud Unit Site, but you can use any storage repository
system that you like. Remember that a Portfolio is YOUR tool. You should be able to store your
assessment work, reflections, achievements and artefacts in YOUR Portfolio. Once you have
completed this assessment piece, add it to your personal Portfolio to use and showcase your
learning later, when applying for jobs, or further studies. Curate your work by adding meaningful
tags to your artefacts that describe what the artefact represents.
Page 4 of 4
Sample assignment outline
This report has been prepared by:
x, y, z
MIS781 Business Intelligence and Database Group Assignment
Sample report MIS781
Page 1 of 5
Table of content
1. Introduction ……………………………………………………………………………………………………………………………………………….. 2
1.1 Objectives of the database design ……………………………………………………………………………………………………………….. 2
1.2 Benefits of the database design ………………………………………………………………………………………………………………….. 2
1.3 Assumptions……………………………………………………………………………………………………………………………………………… 2
1.4 Description of business rules and variables used in this report ……………………………………………………………………….. 3
1.5 Target Audience ………………………………………………………………………………………………………………………………………… 3
2. Database within COIVD-19 pandemic setting ……………………………………………………………………………………………………… 4
2.1 Database 1: For Health Department/Government …………………………………………………………………………………………. 4
2.2 Database 2: For Public ……………………………………………………………………………………………………………………………….. 5
2.3 Database 1: For Local Council / Hospital ………………………………………………………………………………………………………. 5
3. References (use APA ref) …………………………………………………………………………………………………………………………………. 5
Sample report MIS781
Page 2 of 5
1. Introduction
COVID-19 pandemic setting…..
1.1 Objectives of the database design
• Objective 1
• Objective 2
• Objective 3
1.2 Benefits of the database design
• Benefit 1
• Benefit 2
• Benefit 3
Eg. Three key benefits are:
• Empowering people to tackle the challenge of climate change
• Encouraging the use of/switch to renewable energy
• Provide a tangible outcome
1.3 Assumptions
The findings and analyses identified by the dashboard are derived from an amalgamation of publicly available data
sources from two organisations identified in Table 2.
Table 1 Assumptions
Assumption 1: Eg. The death rate includes those who passed away at home
Assumption 2: Eg. Senior citizen: 65+
Assumption 3
Assumption 4…..
Sample report MIS781
Page 3 of 5
1.4 Description of business rules and variables used in this report
Example Table 2. Business Rules and final variables used for analysis
1.5 Target Audience
1. Health Department/Government
2. Public
3. For Local Council / Hospital
Sample report MIS781
Page 4 of 5
2. Database within COIVD-19 pandemic setting
2.1 Database 1: For Health Department/Government
1NF
Field 1 2 3 4 5 6 7
PK Row 1
2
3
4
5
Commentary: Explain this 1NF table xxxxx
2NF
2NF table 1
Explain this 2NF table 1: xxxxx
2NF table 2
Explain this 2NF table 2: xxxxx
2NF table 3
Explain this 2NF table 3: xxxxx
3NF
3NF table 1
Explain this 3NF table 1: xxxxx
Sample report MIS781
Page 5 of 5
3NF table 2
Explain this 3NF table 2: xxxxx
3NF table 3
Explain this 3NF table 3: xxxxx
3NF table 4
Explain this 3NF table 4: xxxxx
2.2 Database 2: For Public
1NF -> 2NF -> 3NF
Commentary
2.3 Database 1: For Local Council / Hospital
1NF -> 2NF -> 3NF
Commentary
3. References (use APA ref)
1….
2….