| Literature DB >> 35755764 |
Abstract
This article focuses on introducing online piano teaching methods and has developed and implemented a preschool piano education online course platform. The system consists of four parts: backend, WeChat, client, and web page. Backend development uses PHP language and Laravel system framework, WeChat and web development both use JavaScript language and React framework, client development uses Objective-C language, and the system provides internal support for RESTful API, mainly for client, WeChat, and web. The client relies on the existing voice sensors of the research group to recognize and evaluate the performance of the students. The role of the client is to show the students their homework and demonstrate the activities performed by the teacher. The function of the WeChat terminal is to manage student work, user information, and user social interaction functions. The function of the web page is the score management and data analysis functions. Based on the knowledge of network course design, this article studies the design of piano preschool education platform and adds relevant components of the Internet cloud computer system and voice sensor to this platform, which provides great convenience for students to learn piano.Entities:
Mesh:
Year: 2022 PMID: 35755764 PMCID: PMC9217588 DOI: 10.1155/2022/6525866
Source DB: PubMed Journal: Comput Intell Neurosci
Figure 1Cloud computing architecture.
Figure 2Simulation diagram of a single access point table driving method.
Figure 3Comparison diagram of single access point table driving method and ideal situation simulation.
Figure 4System function module design.
Parent table.
| Field | Type of data | Remark |
|---|---|---|
| Id | int (ll) | Primary key id of the table |
| openid | varchar (64) | WeChat openid |
| Sign_up_time | datetime | Registration time |
| phone_number | varchar (20) | phone number |
| avatar | varchar (255) | Avatar URL |
| name | varchar (20) | Name |
Student table.
| Field | Type of data | Remark |
|---|---|---|
| id | int (ll) | Primary key id of the table |
| name | varchar (16) | Name |
| gender | tinyint (4) | gender |
| background_year | varchar (255) | Background image URL |
| Learning_year | tinyint (4) | Year of piano |
| avatar | varchar (255) | Avatar URL |
| sign_up_time | datetime | Registration time |
| practice_duration | decimal (4, 2) | Total time of practice |
| practice_count | int (ll) | Total number of exercises |
| total_star | int (ll) | Total stars earned |
| family_id | int (ll) | Family id |
| is_available | tinyint (4) | Whether the current student has been deleted |
Parent_family_relationship table.
| Field | Type of data | Remark |
|---|---|---|
| id | int (ll) | Primary key id of the table |
| parent_id | int (ll) | Parent's id |
| family_id | int (ll) | Family id |
| is_admin | tinyint (4) | Is the parent responsible for management |
| is_available | tinyint (4) | Whether the current parent-family relationship has been deleted |
| created_at | datetime | Creation time |
| relationship | tinyint (4) | Parents' relationship in the family |
Opern table.
| Field | Type of data | Remark |
|---|---|---|
| id | int (ll) | Primary key id |
| illustration_path | varchar (255) | URL of the illustration |
| Opern_path | varchar (255) | The URL of the score |
| English_name | varchar (255) | English name of the score |
| name | varchar (16) | Score name |
| page_number | tinyint (4) | The page number of the score in the book |
| book_id | int (ll) | The id of the book where the score is located |
| created_at | datetime | Creation time |
| is_deleted | tinyint (4) | Whether to be deleted |
| Opern_data_path | varchar (255) | Data storage URL parsed from the score |
| is_one_hand | tinyint (4) | One-handed or two-handed |
Recording table.
| Field | Type of data | Remark |
|---|---|---|
| Id | int (11) | Primary key id |
| created_at | datetime | Creation time |
| student_id | int (11) | Student id |
| demonstration_detail_id | int (11)) | Specific demonstration id |
| homework_detail_id | int (11) | Specific job id |
| opern_name | varchar (16) | Score name |
| opern_id | int (11) | Score id |
| is_available | tinyint (4) | Whether to be deleted |
| audio_path | varchar (255) | Audio file address |
| algorithm_path | varchar (255) | Algorithm file address |
| playback_path | varchar (255) | Playback file address |
| recording_created_at | datetime | Record creation time |
| Star | mediumint (4) | Number of stars obtained |
| Size | decimal (4, 2) | The size of the recording file |
| Duration | decimal (4, 2) | Duration of recording |
| like_count | tinyint (4) | Likes |
| homework_id | int (11) | Big job id |
| parent_id | int (11) | Parent id |
| Type | tinyint (4) | Recording type |
| teacher_id | int (11) | Teacher id |
| Uuid | varchar (64) | Unique ID of iPad |
| Hand | tinyint (4) | Left-handed, right-handed or two-handed |
| is_long_shared | tinyint (4) | Long-term sharing |
| is_stick_top | tinyint (4) | Whether to top |
Figure 5System structure diagram.