Subject Code & Title :- MIS202 Managing Data And Information
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.
MIS202 Managing Data And Information Assignment
Learning Outcome Details
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.
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.
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 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.
MIS202 Managing Data And Information Assignment
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 Lucid chart 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 justifications as necessary.
MIS202 Managing Data And Information Assignment
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 with out 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 an extension.
ORDER This MIS202 Managing Data And Information Assignment NOW And Get Instant Discount
