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.

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

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

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