Order ID:89JHGSJE83839 | Style:APA/MLA/Harvard/Chicago | Pages:5-10 |
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 |
||||||
Excellent Quality 95-100%
|
Introduction
45-41 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned. |
Literature Support 91-84 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned. |
Methodology 58-53 points Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met. |
|||
Average Score 50-85% |
40-38 points More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided. |
83-76 points Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration. |
52-49 points Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met. |
|||
Poor Quality 0-45% |
37-1 points The background and/or significance are missing. No search history information is provided. |
75-1 points Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration. |
48-1 points There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met |
|||
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow |
Assignment at the Bulawayo Music Academy