Assignment at the Bulawayo Music Academy
Order ID 53563633773 Type Essay Writer Level Masters Style APA Sources/References 4 Perfect Number of Pages to Order 5-10 Pages Description/Paper Instructions
Assignment at the Bulawayo Music Academy
Bulawayo Music Academy, founded in 1926, offers a popular piano lesson program. The institution is full of eccentric, exceptionally talented musicians who live in the “old world” of exercise books for notes, rulers on knuckles for piano students’ sluggish/floppy wrists, and paying cash for lessons. A leap into the twenty-first century is required, and the academy has chosen to ask one of their students, who studies computer technology, to construct them a rudimentary database to manage the lessons and lesson-payment information for their piano instruction program.
Students are 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 each student is expected to nominate (and pay for) and attend at least one 60-minute music theory class (with other students) held on Saturday mornings in the main studio.
(1) Piano-Teacher; (2) Piano-Student; (3) Piano-Level (level 1 through 10 showing standard obtained by a student); (4) Piano-Lesson individual; (5) Theory-Lesson class; and (6) Lesson-Payment are the first entities recognized to be controlled by the database. Not only does the school want the database to store information about teachers and students’ schedules, but it also wants to be able to answer queries from new students and parents, such as how long will it take me to pass Piano Level 1? What will it cost to advance to Piano Level 3? etc. Consider what qualities the various named entities will require to answer the questions provided in your fourth task database testing. It will be beneficial to study and consider the entire case (including the testing questions) before starting to conceptualize or design your database in this example.
Create an ERD to visualize how the entities in the case/scenario interact with one another so that a database may be created from it. You’ll have to:
1. Create a conceptual database
a. Create an ERD for the conceptual database/model.
Entities, relationships, and PK/FK properties are all included.
You can annotate your class diagrams with crows-foot or UML class diagrams, but be consistent.
a. In your ERD, write the business rules for each relationship you create.2. Create the logical database that is, create a schema that includes the following:
c. Create a DLL-schema (a list of tables/columns) in the correct order of table formation.
d. Documentation for table descriptions (entities/tables, attributes/columns, data-format (domains), and column descriptions)
e. Documentation for table structure (constraints/constraint-names for PKs, FKs, Not Nulls, Unique, etc.)
NOTE: You may combine the two table documents, but be sure to format them properly so that the table looks nice and readable.3. Produce a physical database:
f. CREATE TABLE scripts for all tables/constraints to be implemented
g. INSERT INTO scripts with at least 5 rows per table, as well as enough data to test the database using the queries/information retrieval described in #4.
NOTE: When choosing data to insert, make sure it’s reasonable and can represent what you’ll be testing in #4.4. Test your database: In your scenario, the Bulawayo Music Academy… h. How much time and effort is required to learn to play the piano (a question that many young kids ask when their parents bring them to the music academy to learn how to play the piano)
Harry Smith, for example, gets a weekly piano lesson with Mrs Moira Strickland every Wednesday after school and a music theory session (with other pupils) every second Saturday morning of the month.
Between February 1st and August 31st of this year, how many piano lessons will Harry have?
In that time frame, how many theory classes will he take?
i. What would it cost to study the fundamentals (to get to Piano-Level 1)? Piano lessons, for example, are $75 per hour, and Harry’s weekly lesson is 90 minutes. At least twice a month, he also teaches a one-hour theory class ($45).
Between February 1st and August 31st, how much will his weekly piano and fortnightly theory lessons cost him?
Between February 1st and August 31st, how many hours will Harry spend at the academy?
j. It takes an average of 7 months for a student to attain (and pass) Piano-Level 1, and then 5 months for each subsequent level.
How many of your database’s students have progressed to Piano Level 4?
How many lessons does it take to get to level 4 (assuming typical progression)?
How much money has a student (or their parents) spent by the time they reach level 4?
k. Run inquiries to learn more about the piano teaching team, such as: How long have all of the teachers who presently instruct in the piano teaching program worked at Bulawayo Music Academy on average?
Who is the Academy’s most experienced piano teacher, and how long have they worked at BMA? Who on staff presently has the most contact teaching hours?
RUBRIC
QUALITY OF RESPONSE NO RESPONSE POOR / UNSATISFACTORY SATISFACTORY GOOD EXCELLENT Content (worth a maximum of 50% of the total points) Zero points: Student failed to submit the final paper. 20 points out of 50: The essay illustrates poor understanding of the relevant material by failing to address or incorrectly addressing the relevant content; failing to identify or inaccurately explaining/defining key concepts/ideas; ignoring or incorrectly explaining key points/claims and the reasoning behind them; and/or incorrectly or inappropriately using terminology; and elements of the response are lacking. 30 points out of 50: The essay illustrates a rudimentary understanding of the relevant material by mentioning but not full explaining the relevant content; identifying some of the key concepts/ideas though failing to fully or accurately explain many of them; using terminology, though sometimes inaccurately or inappropriately; and/or incorporating some key claims/points but failing to explain the reasoning behind them or doing so inaccurately. Elements of the required response may also be lacking. 40 points out of 50: The essay illustrates solid understanding of the relevant material by correctly addressing most of the relevant content; identifying and explaining most of the key concepts/ideas; using correct terminology; explaining the reasoning behind most of the key points/claims; and/or where necessary or useful, substantiating some points with accurate examples. The answer is complete. 50 points: The essay illustrates exemplary understanding of the relevant material by thoroughly and correctly addressing the relevant content; identifying and explaining all of the key concepts/ideas; using correct terminology explaining the reasoning behind key points/claims and substantiating, as necessary/useful, points with several accurate and illuminating examples. No aspects of the required answer are missing. Use of Sources (worth a maximum of 20% of the total points). Zero points: Student failed to include citations and/or references. Or the student failed to submit a final paper. 5 out 20 points: Sources are seldom cited to support statements and/or format of citations are not recognizable as APA 6th Edition format. There are major errors in the formation of the references and citations. And/or there is a major reliance on highly questionable. The Student fails to provide an adequate synthesis of research collected for the paper. 10 out 20 points: References to scholarly sources are occasionally given; many statements seem unsubstantiated. Frequent errors in APA 6th Edition format, leaving the reader confused about the source of the information. There are significant errors of the formation in the references and citations. And/or there is a significant use of highly questionable sources. 15 out 20 points: Credible Scholarly sources are used effectively support claims and are, for the most part, clear and fairly represented. APA 6th Edition is used with only a few minor errors. There are minor errors in reference and/or citations. And/or there is some use of questionable sources. 20 points: Credible scholarly sources are used to give compelling evidence to support claims and are clearly and fairly represented. APA 6th Edition format is used accurately and consistently. The student uses above the maximum required references in the development of the assignment. Grammar (worth maximum of 20% of total points) Zero points: Student failed to submit the final paper. 5 points out of 20: The paper does not communicate ideas/points clearly due to inappropriate use of terminology and vague language; thoughts and sentences are disjointed or incomprehensible; organization lacking; and/or numerous grammatical, spelling/punctuation errors 10 points out 20: The paper is often unclear and difficult to follow due to some inappropriate terminology and/or vague language; ideas may be fragmented, wandering and/or repetitive; poor organization; and/or some grammatical, spelling, punctuation errors 15 points out of 20: The paper is mostly clear as a result of appropriate use of terminology and minimal vagueness; no tangents and no repetition; fairly good organization; almost perfect grammar, spelling, punctuation, and word usage. 20 points: The paper is clear, concise, and a pleasure to read as a result of appropriate and precise use of terminology; total coherence of thoughts and presentation and logical organization; and the essay is error free. Structure of the Paper (worth 10% of total points) Zero points: Student failed to submit the final paper. 3 points out of 10: Student needs to develop better formatting skills. The paper omits significant structural elements required for and APA 6th edition paper. Formatting of the paper has major flaws. The paper does not conform to APA 6th edition requirements whatsoever. 5 points out of 10: Appearance of final paper demonstrates the student’s limited ability to format the paper. There are significant errors in formatting and/or the total omission of major components of an APA 6th edition paper. They can include the omission of the cover page, abstract, and page numbers. Additionally the page has major formatting issues with spacing or paragraph formation. Font size might not conform to size requirements. The student also significantly writes too large or too short of and paper 7 points out of 10: Research paper presents an above-average use of formatting skills. The paper has slight errors within the paper. This can include small errors or omissions with the cover page, abstract, page number, and headers. There could be also slight formatting issues with the document spacing or the font Additionally the paper might slightly exceed or undershoot the specific number of required written pages for the assignment. 10 points: Student provides a high-caliber, formatted paper. This includes an APA 6th edition cover page, abstract, page number, headers and is double spaced in 12’ Times Roman Font. Additionally, the paper conforms to the specific number of required written pages and neither goes over or under the specified length of the paper. GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDER
CLICK ON THE LINK HERE: https://www.perfectacademic.com/orders/ordernow
Also, you can place the order at www.collegepaper.us/orders/ordernow / www.phdwriters.us/orders/ordernow
Do You Have Any Other Essay/Assignment/Class Project/Homework Related to this? Click Here Now [CLICK ME]and Have It Done by Our PhD Qualified Writers!!