The main goal of this project is to create a basic database management tool to manage our existing client contacts and provide a seamless method to add new contacts, and to bulk edit existing contacts by merging new data via an Excel spreadsheet or .csv file. This project will involve several different steps for the students, including:

• Attending a discovery meeting with Silver Meridian to assess our needs
• Based on the discovery results, research and report on the best software or technical method to achieve our goals
• Design and build the database management system
• Test and make improvements based on feedback from Silver Meridian
• Advise on how to deploy the system
• Train a Silver Meridian staff member on how to use the system

What the system will need to do:

• accept new bulk data via upload of a CSV or Excel file
• accept new single record entries
• accept single record edits
• integrate bulk data edits via upload of of a CSV or Excel file (this is actually our biggest pain point with using our existing contacts list which is an Excel spreadsheet)
• search functionality to search for contacts based on any and all fields

Secondary functionality (Nice to Haves)

• simple data analysis - ie: records that match specific criteria (geographic location, category, etc)
• simple UI dashboard for reporting on data analysis

This project will involve several different steps for the students, including:

• Attending a discovery meeting with Silver Meridian to assess our needs
• Based on the discovery results, research and report on the best database software or technical method for achieving our goals
• Design and build the database management system
• Test and make improvements based on feedback from Silver Meridian
• Advise on how to deploy the system
• Train a Silver Meridian staff member on how to use the system

Silver Meridian will offer the following support:

• staff member to attend initial discovery meeting to review our needs
• staff member to be available weekly by email/phone/Zoom for support throughout the project
• staff member to be available for review of final deliverables and to provide feedback
• Staff member to be available to train on final system implementation and use
• provide sample data for production and testing