Skip to content
Snippets Groups Projects
Select Git revision
  • main default protected
1 result

advanced-databases

  • Clone with SSH
  • Clone with HTTPS
    • user avatar
    Untrack directories
    Oscar Lysak authored
    5cac6e9f
    History
    user avatar 5cac6e9f
    History
    Name Last commit Last update
    Activity1
    Activity2
    data
    .DS_Store
    .gitingore
    README.md
    manage.py
    requirements.txt
    README.md

    Advanced Databases Activity 1 & 2

    Description

    This project is a comprehensive football agents database system with two different implementations: one using SQL (PostgreSQL) and the other using NoSQL (MongoDB). The goal is to provide a flexible and scalable solution for football agents managing their clients.

    Installation

    To install the project, follow these steps:

    1. Clone the repository
    2. Install the dependencies using pip install -r requirements.txt

    Database Setup

    This project uses both PostgreSQL and MongoDB databases. Follow the steps below to set them up locally:

    PostgreSQL

    1. Install PostgreSQL if you haven't already. You can download it from here.
    2. Create a new PostgreSQL database.
    3. Update the DATABASE_URI configuration in Activity1/src/config.py with your database name, user, password, and host.

    MongoDB

    1. Install MongoDB if you haven't already. You can download it from here.
    2. Create a new MongoDB database.
    3. Update the DATABASE_URI configuration in Activity2/src/config.py with your database name and host.

    Database Setup

    1. Run the project using python manage.py

    Activities

    The project contains the following activities:

    • Activity1: SQL Implementation and required queries
    • Activity2: NoSQL Implementation and required queries

    Data

    The project uses data from players_data.csv which contains all data regarding players, teams, and contracts.