I have got a case study :

name information description TEACHERS taught by teacher ID venue vocal has contact STUDENTS has Engagement CLASSES time name book name description quartity varsity selected sanity availat COMPANY manage SALES within Stock Hom REGULAR name D act as ONLINE OFF-THE-SHELF quantity hem price phone number AGENT oversee ORDERS image price date within brand Formation arity avail sic te quantly selected Stock lem quiter coke name description name colour SPOKE CHITAAS D MASON COLE CLARKTask 2: Business Case is a small, but rapidly growing business operating out of Geelong. The business began as a means for-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.coml. 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 offtheshelf 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 offtheshelf 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: 0 Acting as an agent for Maton and Cole Clark Guitars to arrange orders for bespoke acoustic guitars 0 Online and offtheshelf sales of regular acoustic guitars 0 Booking students into classes that music teachers teach 0 Booking music teachers to teach classes ofstudents 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. 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 backend 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 dia ram should contain the following com onents: ilwith-denoted) and or 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. Front page Title of the Project . Addressing the client manager(s) Name and contact details of the consultants . Your company name Date Table of Contents Executive Summary A brief summary of the objectives of this data analysis in the context of the company business goals; and findings from the project including your data model recommendations. 1. Introduction A short introduction to the report including who commissioned the project and why? 2. Company Profile Analyse the company profile and describe their business goal(s). Identify and state the project objective and scope. 3. Proposed Data Model - Assignment Task 2: EER Diagram . Propose a data model as specified in the Assignment. 4. Justify its match to the client requirements Clearly state any assumptions made. . Explain how the EER diagram meets the client's needs as per assignment specification. 5. Benefits and limitations Describe expected benefits of the proposed data model in relation to the company business goals. Inform the client of possible issues/limitations associated with the data model. Suggest ways to address them.6. Recommendations . Summarise the proposal. . State your recommendations clearly. Do you advocate this business adopting an information system with a database back-end built according to the EER model? Do the benefits identified in section 5 justify your recommendation(s)? 7. Appendix 1: Assignment Task 1 Include assignment Task 1 in this section - SQL queries, screenshots and accompanying explanations. 8. References . References that you use in conducting this data modelling project. If no references were used in the report then you may leave this section out. Useful resources: General guides for report writing can be found at: http:/www.deakin.edu.au/students/study-support/academic-resources/report-writing Referencing styles: http://www.deakin.edu.au/students/study-support/referencing APA is preferred