Music Society Database Integration and System Cleanup

Project scope
Categories
Data analysis Data modelling Information technology DatabasesSkills
operational efficiency ibm system p data integration data redundancy database systems system optimization data retrieval database management data access data managementThe Cosmopolitan Music Society is seeking to enhance its operational efficiency by integrating its existing databases and cleaning up its computer systems. The current setup involves multiple databases that are not well-integrated, leading to data redundancy and inefficiencies in data retrieval. The goal of this project is to streamline these databases into a cohesive system that allows for seamless data access and management. Additionally, the project will involve cleaning up the computer systems to ensure they are running optimally, removing unnecessary files, and organizing the digital workspace. This project provides an opportunity for learners to apply their knowledge of database management and computer systems to a real-world scenario, enhancing their skills in data integration and system optimization.
- Analyze the current database structure and identify areas for integration.
- Develop a plan for integrating the databases into a single, cohesive system.
- Clean up computer systems by removing unnecessary files and organizing the digital workspace.
- Optimize system performance to ensure efficient operation.
The project deliverables will include a report detailing the analysis of the current database structure and the integration plan. Additionally, a fully integrated database system that allows for efficient data management will be delivered. The cleaned and optimized computer systems will also be a key deliverable, ensuring they are free from unnecessary files and organized for optimal performance.
- A report on the current database structure and integration plan.
- An integrated database system.
- Cleaned and optimized computer systems.
Sharing knowledge in specific technical skills, techniques, methodologies required for the project.
Providing access to necessary tools, software, and resources required for project completion.
Scheduled check-ins to discuss progress, address challenges, and provide feedback.
Supported causes
The global challenges this project addresses, aligning with the United Nations Sustainable Development Goals (SDGs). Learn more about all 17 SDGs here.
About the company
The Cosmopolitan Music Society of Edmonton has been helping Music Lovers become Music Makers since 1963. The Cosmopolitan Music Society (“Cosmo”) gives amateur adult musicians and singers the opportunity to learn and perform quality concert band, jazz, big band, handbell and choral music. Our beginner band program gives new players the opportunity to learn an instrument, to read music, and work towards a performance skill level that will enable them to play in one of the three concert bands. Under professional music direction, our concert bands and choirs perform at all levels of ability, from beginner to advanced; and our jazz bands at novice to intermediate (Big Band), and advanced (Jazz Orchestra). We strive to create community!
Portals
-
Vancouver, British Columbia, Canada