MIS781 Business Intelligence and Database Assignment

Group Assignment: Database Design and Report

DUE DATE AND TIME:	Thursday 14 April 2021 (Week 6) 8:00 pm AEST
PERCENTAGE OF FINAL GRADE:	20%
WORD LIMIT:	2999 words

Learning Outcome Details

Unit Learning Outcome (ULO)	Graduate Learning Outcome (GLO)
ULO1: Explain and apply the business intelligence (BI) lifecycle concept, multidimensionality concept, and database concept	GLO1: Discipline-specific knowledge and capabilities - students are required to demonstrate an understanding of the business intelligence context and explain the BI and database technologies and associated implementation issues.
ULO2: Appraise and apply data warehousing architecture, technologies, development methodologies, and databases for business intelligence.	GLO3: Digital Literacy - students are required to apply BI and database technologies to find, use and disseminate actionable information.
ULO3: Collaborate constructively in a team to use BI and database technologies for the implementation of innovative BI solutions and better dissemination of information.	GLO7: Teamwork - students are expected to collaborate constructively in a team to appraise 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 5 May 2021 (Thursday; 5 pm).

Description / Requirement

In this group assignment, teams of 3 students will design an election-related 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 a retail setting. Based on the database design,  students will provide data to showcase the database.

Tasks:

1. Your task is to analyse the retail database requirement (e.g. retail trade, retail sales data, retail store data, aggregated spend pattern, average shopping time, etc) and design a database that considers normalization. You must explain each of your normal form tables and provide: 1NF, 2NF, and 3NF tables to depict your work. The database can be re-used for the practical assignment on retail dashboard development, as shown below example.
2. You may include the database tables as MS Word/Excel tables or as screenshot images. 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. E.g., 1 table for the retail owner, 1 table for government,  1 table for retail association). In the written report, you must explain the table structure,  define the data field/attribute and the data type (i.e., Integer, Floating-point number,  Character, String, Boolean), 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 a database table is provided below.
3. The entire assignment should be discussed and presented as one coherent report. The written report should include:
   1. Objectives of your database design
   2. Benefits of your database design
   3. Tables, data fields, commentary, 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 especially the HD column and the assignment outline example.
4. The contribution of each team member must be clearly stated in the Table of Contents (e.g., Introduction - done by Alex Smith).
5. A group contribution form must be signed by all group members and be attached as an appendix in the group report.
6. Some useful links: 
   • https://www.abs.gov.au/statistics/industry/retail-and-wholesale-trade/retail-trade australia/latest-release
   • https://data.world/datasets/retail
   • https://data.gov.au/data/dataset/retail-trade
   • https://fred.stlouisfed.org/tags/series?t=retail+trade
   • https://www.economy.com/australia/retail-sales
   • www.oecd.org/industry/business-stats/revisionsanalysisdatabaseforretailtradevolume.htm

Report guidelines

1. The assignment report should contain a table of contents, a series of logically organised sections, and a list of references.
2. Apply only APA referencing format.

3. You may include figures, diagrams, tables, charts, etc.
4. The length of the assignment excludes the table of content, database tables, and reference list. The maximum words limit is 2999 words. Note: Although at least 5 rows are expected, 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. Save your word file as group_number.docx.
7. Format: Times New Roman, font size 12 & single line spacing.

Group Restrictions

• Groups of 03 (THREE) members

Finding Group Members

Students should use the assessment discussion forums or discuss directly with their classmates to find group members to work with. Groups should be formed by the end of week 3, or the system will automatically/randomly assign students to a group of 3 members in week 4.

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, you will receive an email to your 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.

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 assignment 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 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.

Looking for MIS781 Business Intelligence and Database Assignment Help? You just need to contact our assignment experts via call, chat, or WhatsApp, explain your task, supply your instructions or requirements and place an order to avail the best assignment online tutoring service in Australia for your MIS781 Business Intelligence and Database Assignment Online.