Music Society Database Integration and System Cleanup

Open
Cosmopolitan Music Society
Edmonton, Alberta, Canada
Manager
(10)
5
Project
Academic experience
60 hours of work total
Learner
Edmonton, Alberta, Canada
Intermediate level

Project scope

Categories
Data analysis Data modelling Information technology Databases
Skills
operational efficiency ibm system p data integration data redundancy database systems system optimization data retrieval database management data access data management
Details

The 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.

Deliverables

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.

Mentorship
Skills, knowledge and expertise

Sharing knowledge in specific technical skills, techniques, methodologies required for the project.

Tools and/or resources

Providing access to necessary tools, software, and resources required for project completion.

Regular meetings

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.

Gender equality

About the company

Company
Edmonton, Alberta, Canada
2 - 10 employees
Arts, Non-profit, philanthropic & civil society
Representation
Community-Focused

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!