This repository represents the assignments that are part of ISYS 5713 - Special Projects in Advanced Data Management with Python.

• Individual Assignment 1 - In this assignment, students will be able to practice creating repositories, adding files, committing changes, dealing with branches and managing pull requests.
• Individual Assignment 2 - The objective of this assignment is to provide you with hands-on experience in creating and manipulating objects in Python using object-oriented programming concepts. You will gain proficiency in defining classes, creating instances, setting attributes, and implementing methods.
• Individual Assignment 3 - In this assignment, students are going to focus on getting data out of a database, using a few different methods
• Individual Assignment 4 - In this assignment, students will explore public Application Programming Interfaces (APIs) learn how to make a connection to a public API to query for data and use the data that is returned.

The groups assignments will be building toward a deployable API with a unique front-end which provides and example of how to use the API and also excercise the API. Throughout the group assignments, teams will discover the need to go back and address deficencies in prior areas of the design - so while this is shown as a linear path, that's not how the implementation will actually procede. Here's the end result

graph TD
    E[Database] <-->|DB Data| F[API DB Access]
    F <-->|Filtered data| G[API Endpoints]    
    
        G <-->|HTTP| A[Webpage]
        G <-->|HTTP| B[Jupyter Notebook]
        G <-->|HTTP| D[Console App]
        G <-->|HTTP| H[Mobile]

• Group Assignment 2 - The purpose of this assignment is to help students understand how to load data into a database using Python.

graph TD
    subgraph "GA2"
        E[Database]<-->|DB Data| F[API DB Access]
    end
    F <-->|Filtered data| G[API Endpoints]
    G <-->|HTTP| A[Webpage]
    G <-->|HTTP| B[Jupyter Notebook]
    G <-->|HTTP| D[Console App]
    G <-->|HTTP| H[Mobile]

• Group Assignment 3 - The purpose of this assignment is to give students the opportunity to design and develop an API which will be able to interact with the database.

graph TD
    E[Database] <-->|DB Data| F[API DB Access]
    subgraph "GA3"
        F <-->|Filtered data| G[API Endpoints]    
    end
    G <-->|HTTP| A[Webpage]
    G <-->|HTTP| B[Jupyter Notebook]
    G <-->|HTTP| D[Console App]
    G <-->|HTTP| H[Mobile]

• Group Assignment 4 - The purpose of this assignment is to give students the opportunity to design and develop an API which will be able to interact with the database.

graph TD
    E[Database] <-->|DB Data| F[API DB Access]
    F <-->|Filtered data| G[API Endpoints]    
    
        G <-->|HTTP| A[Webpage]
        G <-->|HTTP| B[Jupyter Notebook]
        G <-->|HTTP| D[Console App]
        G <-->|HTTP| H[Mobile]
    subgraph "GA4"
        A
        B
        D
        H
    end