Bulawayo Music Academy - Case Study - IT Assignment Help

Assignment Task

Question 1
EoSA Case#1: Bulawayo Music AcademyBulawayo Music academy, established in 1926, runs an in-demand piano teaching program. The academy is full of eccentric, highly gifted musicians, who live in the ‘old world’ of exercise books for notes, rulers on knuckles for piano students’ lazy/floppy wrists, and paying cash for lessons.  A leap into the 21st Century is required, and the academy – who would like to quantify what they actually do – have decided to ask one of the students, who studies computer science, to build them a basic database to manage the lessons and lesson-payment information of their piano teaching program.  
 
The general program, which has remained largely unchanged for 95 years, involves
students being matched with an expert piano-teacher for a 90 minute weekly one-on-one piano lesson in one of the dozens of individual studio/rooms; and
an expectation that each student nominate (and pay) for and attend at least one 60-minute music theory class (with other students) held on Saturday mornings in the main hall at the music academy.
 
The initial entities identified to be managed by the database include: (1) Piano-Teacher; (2) Piano-Student; (3) Piano-Level (level 1 through 10 – indicating standard reached by a student); (4) Piano-Lesson {individual}; (5) Theory-Lesson {class}; and (6) Lesson-Payment.  The kinds of information the academy wishes the database to capture is not just to manage actual timetables of teachers and students, but also to be able to measurably answer questions new students/parents ask, such as how long will it take before I can pass my Piano Level 1? How much will cost to get to Piano Level 3? etc. Consider what attributes the various entities named will require to answer the questions posed as part of your #4 task – testing the database. For this case, it will serve you well to read and consider the whole case (including the testing questions) before beginning to conceptualise or build your database.
 
Develop an ERD to conceptualise how the entities within the case/scenario relate to one another, so that a database can be built from that ERD.  You will need to:
Build the conceptual database:
Build an ERD that captures the conceptual database/model
include entities, relationships, and PK/FK attributes.
you may use crows-foot or UML class diagram annotation, but be consistent.
Write the business rules for every relationship you draw in your ERD
 
Develop the logical database – i.e., construct a schema that includes:
Write a DLL-schema (list of tables/columns) in correct table-creation order
Table description doc (entities/tables, attributes/columns, data-format (domains), column description)
Table structure doc (constraints/constraint-names for PKs, FKs, Not Nulls, Unique, other..)
NOTE: you may combine the 2 table documents, but format it well so table is neat and readable.
 
Write the physical database:
CREATE TABLE scripts to implement all tables/constraints
INSERT INTO scripts that provide at least 5 rows for each table, plus enough data to test the database using the queries/information retrieval outlined in #4.
NOTE: when selecting the data to insert, make it logical and able to represent what you will test in #4
 
Test your database: In your case, the Bulawayo Music Academy . . 
How much commitment is involved in learning the piano (a question many young students ask as their parent(s) drag them to the music academy to learn how to play the piano)e.g., Student, Harry Smith, has a weekly piano-lesson with Mrs Moira Strickland every Wednesday after school and a music theory class (with other students) every 2nd Saturday morning of every month.
How many Piano Lessons will Harry have between February 1st and August 31 this year?
How many theory classes will he take in that same period?
How much will it cost to learn the basics (reach Piano-Level 1)? e.g., Piano lessons are charged at $75 per hour, and Harry’s lesson is 90 minutes each week.  He also does a one-hour theory class ($45) at least twice a month.
How much will his weekly piano and fortnightly theory lessons cost him between Feb 1st and August 31?
How many total hours will Harry spend at the academy between February 1st and August 31.It takes a student on average around 7 months to reach (and pass) Piano-Level 1, then around 5 months for each new level. 
How many of the students in your database have currently reached Piano Level 4? 
How many lessons does it take (assuming average progression) to get to level 4.By the time a student is playing at level 4, how many $ have they (or their parents) invested?
Run queries to learn something about the piano teaching staff, including:
What is the average amount of time all the teachers who currently instruct in the piano teaching program have been working at Bulawayo Music Academy.Who is the most experienced piano teacher at the Academy, and how long have they been working at BMA.Who currently has the most contact teaching hours on staff.

This IT Assignment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.