XXXXXXXXXXDeakin's Bachelor of Commerce and MBA are internationally EPAS accredited. Deakin Business School is accredited by AACSB MIS202 – Managing Data & Information Trimester 1, 2022 Assessment 1 –...

1 answer below »
i have the lecture notes aswell, please provide quote for the assignment.


Deakin's Bachelor of Commerce and MBA are internationally EPAS accredited. Deakin Business School is accredited by AACSB MIS202 – Managing Data & Information Trimester 1, 2022 Assessment 1 – A Formal Business Report DUE DATE AND TIME: 29th of April 2022, 8:00 PM Melbourne Time PERCENTAGE OF FINAL GRADE: 50% (Task 1 & 2 = 40%, Task 3 = 10%) WORD LIMIT: 2000 words max Any text beyond the word limit will not be assessed, Table of contents, EER diagrams, SQL code, appendices and any references are not included in the word count. Learning Outcome Details Unit Learning Outcome (ULO) Graduate Learning Outcome (GLO) ULO 1: Explain the social and regulatory context in which the management of data and information takes place. GLO1: Discipline-specific knowledge and capabilities. GLO3: Digital literacy GLO: Global citizenship ULO 2: Compare and contrast the current technical approaches to the management of data and information. GLO1: Discipline-specific knowledge and capabilities GLO3: Digital literacy ULO 3: Analyse an organisation’s data needs to derive an appropriate relational model and SQL queries. GLO1: Discipline-specific knowledge and capabilities GLO3: Digital literacy GLO5: Problem solving ULO 4: Assess changes in technology and their impact on data and information management GLO1: Discipline-specific knowledge and capabilities GLO3: Digital literacy GLO8: Global citizenship https://www.efmd.org/index.php/accreditation-main/epas http://www.aacsb.edu/ Page 2 of 8 Assignment Learning Objectives and Graduate Learning Outcomes This is an individual assignment. The aim of the assignment is for you to develop understanding of information management and database concepts, modelling approaches and applying them to a realistic business context by: • Designing SQL queries capable of producing specific database reports relating to information management (ULO4, and GL01/GLO3/GL08); • Design a simple database using ERR modelling, illustrating how the business can use and manage information (ULO3, and GLO1/GLO3/GL05); and • Critically evaluating the business case and reporting a solution accordingly (ULO3 and GLO3/GL05). Starting the Assignment You are strongly encouraged to make a start on this Assignment by the end of the 4th Week of Trimester, and you should progress thoughtfully through the steps. Multiple iterations are necessary even for experienced data modellers to perfect a design. An early start will get you a long way ahead! Remember, hasty decisions made in the design process may result in much more work later. Feel free to discuss concepts and ideas with peers but remember your submission must be your own work. Be careful not to allow others to copy your work. (EER diagrams should use crow's foot notation as per lecture notes. Under no circumstances will the ‘quaint’ diagrams produced from Microsoft Access be acceptable, nor will its curious and unique form of SQL be acceptable. Such submissions will attract zero marks.) Task 1: SQL Queries Include the following SQL queries that were completed as part of the weekly workshops. These were labelled as Assignment Question within each of the workshops. a) Workshop Week 2 - Question 3 b) Workshop Week 3 - Question 6 c) Workshop Week 4 - Question 8 d) Workshop Week 5 - Question 4 e) Workshop Week 5 - Question 5 For each SQL query include the following: i. Actual textual SQL query (e.g. SELECT column FROM table;) ii. A screenshot of the SQL query being executed on your university database account and the resulting table. Make sure the SQL query and the resulting table are captured in full in the screenshot. The table should be formatted with no lines wrapping around. Use set linesize command (see Workshop Week 2) to increase line length if necessary. iii. An explanation of each of the SQL queries in your own words (1 or 2 sentences max). Page 3 of 8 Task 2: Business Case Graeme’s Music School is a small, but rapidly growing business operating out of Geelong. The business began as a means for Graeme to follow his passion for playing guitar and offering music lessons for both adults and children. As much as he enjoys playing live music, it is not a very profitable occupation, so Graeme also teaches music. Within a year of beginning this business Graeme was approached by other teaching musicians looking for opportunities to teach students various instruments and singing styles. Not long after, he became an agent for selling Australian made acoustic Maton and Cole Clark guitars (see: www.maton.com.au and www.coleclarkguitars.com). While most of his guitar sales are mostly local from Victoria, there have been online sales to all Australian states and territories. Three years later, Graeme finds his online and off-the-shelf acoustic guitar sales is making a reasonable income from the 20% commission that he charges both manufacturers for one-of orders for individually built, bespoke guitars made for individual orders and 50% markup for regular acoustic guitars sold off-the-shelf on the business premises and through the online businesses. The music school side of the business has also expanded and he has 15 musicians who are teaching music into groups of students organised into classes; and the demand is still increasing. Approximately two thirds of the classes are for school age children, and one third is for adults. The music school keeps track of which musicians have a “Working with Children Check” card and its expiry date, and the age of musicians to ensure that only approved adults can teach children. Graeme’s Music is now carrying out the following core business operations: • Acting as an agent for Maton and Cole Clark Guitars to arrange orders for bespoke acoustic guitars • Online and off-the-shelf sales of regular acoustic guitars • Booking students into classes that music teachers teach • Booking music teachers to teach classes of students So far, his business has been operating with temporary notes scribbled on notebooks in combination with a series of disorganised spreadsheets. But these tools are becoming inefficient and increasingly inapt at managing the growing demands of the business. A transition to an information system is urgently needed. http://www.maton.com.au/ http://www.coleclarkguitars.com/ Page 4 of 8 Task 2: EER Model You are employed as a business analyst at Deakin Innovative Solutions, a business consulting firm. You task is to investigate and develop a data model (an EER model) for the back-end database in the newly proposed system. The back-end database will store all of the critical data and support all core business operations mentioned above. Note: The design of any payments system is outside the scope of this project. EER Diagram EER diagram should contain the following components: Entities, named relationships, attributes (with Primary keys denoted) and cardinalities for all relationships. A faster way of doing the EER diagram is to sketch it up on a blackboard, take a digital photograph and paste it into your report. Alternatively, you may use any software tools at your disposal (Lucidchart for example). If hand-drawn make sure your EER diagram is legible. Tasks 3: Business Report Produce a concise business report for the business case. Include Task 1 as Appendix 1 in your report. Also, list any assumptions made when completing Task 2 and ensure that you give adequate justification/s as necessary. Page 5 of 8 Mark Allocation: Tasks Marks 1. SQL Queries Produce SQL statements outlined under the section Task 1 SQL Queries above. 20 marks ULO4 GLO1, GLO3, GLO8 2. EER Model Construct an Enhanced Entity-Relationship (EER) model for the business case as outlinedunder the section Task 2 EER Model Business Case. Make sure you include in your model the details of entities, relationships, attributes, primary keys and cardinalities of all relationships. All many-to-many relationships should be resolved. List any assumptions made and ensure that adequate justification is provided. 20 Marks ULO3 GLO1, GLO3, GLO5 3. Business Report Produce a business report for the business case. Include Task 1 as Appendix One. Also, list any assumptions made when completing Task 2 and ensure that you give adequate justification. More information about writing a business report and a sample report structure is provided in the separate document titled “A Guide to Writing Business Reports” available on CloudDeakin. 10 marks ULO3 GLO1, GLO3, GLO5 Submission Instructions The assignment must be submitted as soft copy in the form of a PDF document via CloudDeakin by the due date. File should be named your firstname_lastname (e.g. John_smith.pdf). You do not have to submit an actual database! 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 of the submission. Page 6 of 8 Assessment Feedback Students who submit their work by the due date will receive their marks and feedback on CloudDeakin 15 business days after the due date. Extensions No extensions will be considered unless a written request is submitted and negotiated with the Unit Chair before the due date and time. Extensions will only be considered if a draft assignment is attached with your request for an extension which shows progress has been made, and documentary evidence for the extension. Applications after this date will not be accepted, and submissions after the due date/time without an approved extension will be considered late. Extensions are only granted in extreme circumstances, such as ongoing health, personal hardship or work-related problems. Temporary illnesses, normal work pressures, multiple assignments due at the same time, failure to keep backups, technology failure, etc are not reasons for
Answered 2 days AfterMay 01, 2022Deakin University

Answer To: XXXXXXXXXXDeakin's Bachelor of Commerce and MBA are internationally EPAS accredited. Deakin Business...

Aditi answered on May 03 2022
92 Votes
GRAEME’S MUSIC SCHOOL
ADDRESSED TO: JADA SMITH, CLIENT MANAGER
PREPARED BY: JOHN FISCHER, BUSINESS ANALYST, DEAKIN INNOVATIVE SOLUTIONS
3RD MAY 2022
Table of Contents
· Executive Summary
· Introduction

· Company Profile
· Proposed Data Model
· Justification with Client Requirements
· Benefits and Limitations
· Recommendations
Executive Summary
As the business operations of Graeme’s Music School skyrocketed in the past couple of years, the founder now deems fit to move towards an information management system. There has been an increase in the number of core operations and an expansion of customer base justifies the development of an online, easy-to-use, readable, easily retrievable model. To this end, an extensive data analysis was performed for identifying the key components of the data to be modelled, as well as the dependencies brought about by business rules.
Introduction
This report details the data models for developing a back-end database for creating an information system to be used for the day-to-day operations of Graeme’s Music School. It lists out all the database requirements necessary for creating, maintaining, utilizing, and updating the company information on the go. With this report, and the EER model included herewith, the database designers can understand and implement the back-end system accurately. It takes care of all business rules, making necessary assumptions for catering to them.
Company Profile
Graeme’s Music School is a rapidly progressing business firm from Geelong. Graeme started this off for making some extra money teaching music, but now this school has attracted musicians with different skills teaching different courses. There is quite a variety in the kind of training available – staring from classes for learning different instruments to musicians teaching several types of singing styles.
Graeme also sells guitars – both online and offline. During the initial days of starting the music school, he worked as an agent for selling Australian made acoustic Maton and Cole Clark guitars locally. Now...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here