Project Blackberry Live Demo

This is a class project for Oregon State University's CS340 Databases course. The goal was to design and implement an end-to-end data management solution for a hypothetical organization in order to track the things that they care about. As denizens of the Puget Sound, we decided to create an organization that would track whale sightings in the area.

Collaborators

• Erin Eckerman
• Joshua Nees

Components

This project consists of the following components:

• Relational database (Postgres)
• API for executing CRUD operations (Node.js/Express)
• Client user interface (React)

Entities Tracked

• Whales
• Whale Species
• Researchers
• Organizations
• Sightings

Database Entity Relationship Diagram

UI Screenshots

This series of screen shots shows the UI components involved in some example CRUD operations.

Read Sightings_Whales

Create Whales

Update Whales

Delete Whales

Sample Data

Sightings

Whales

Researchers

Organizations

Species

Sightings_Whales

Installation for local development

Note: This assumes that you have heroku credentials in your environment for this project. To fork this project, you will need to configure the server to connect to your own db.

1. Install Server from the project directory npm install

2. Run server nodemon server.js

3. Install Client cd client npx install

4. Run client npm start

What does any of this have to do with Blackberries?

Blackberry is the name of one of our favorite orcas in the J-Pod of the famous Southern Resident Killer Whales.