Metadata-Version: 2.1
Name: employee-events
Version: 0.1.0
Summary: SQL Query API and Dashboard Visualizer
Description-Content-Type: text/markdown
Requires-Dist: pandas==2.2.3


# Software Engineering for Data Scientists 

This repository contains starter code for the **Software Engineering for Data Scientists** final project. Please reference your course materials for documentation on this repository's structure and important files. Happy coding!

### Repository Structure
```
â”œâ”€â”€ README.md
â”œâ”€â”€ assets
â”‚Â Â  â”œâ”€â”€ model.pkl
â”‚Â Â  â””â”€â”€ report.css
â”œâ”€â”€ env
â”œâ”€â”€ python-package
â”‚Â Â  â”œâ”€â”€ employee_events
â”‚Â Â  â”‚Â Â  â”œâ”€â”€ __init__.py
â”‚Â Â  â”‚Â Â  â”œâ”€â”€ employee.py
â”‚Â Â  â”‚Â Â  â”œâ”€â”€ employee_events.db
â”‚Â Â  â”‚Â Â  â”œâ”€â”€ query_base.py
â”‚Â Â  â”‚Â Â  â”œâ”€â”€ sql_execution.py
â”‚Â Â  â”‚Â Â  â””â”€â”€ team.py
â”‚Â Â  â”œâ”€â”€ requirements.txt
â”‚Â Â  â”œâ”€â”€ setup.py
â”œâ”€â”€ report
â”‚Â Â  â”œâ”€â”€ base_components
â”‚Â Â  â”‚Â Â  â”œâ”€â”€ __init__.py
â”‚Â Â  â”‚Â Â  â”œâ”€â”€ base_component.py
â”‚Â Â  â”‚Â Â  â”œâ”€â”€ data_table.py
â”‚Â Â  â”‚Â Â  â”œâ”€â”€ dropdown.py
â”‚Â Â  â”‚Â Â  â”œâ”€â”€ matplotlib_viz.py
â”‚Â Â  â”‚Â Â  â””â”€â”€ radio.py
â”‚Â Â  â”œâ”€â”€ combined_components
â”‚Â Â  â”‚Â Â  â”œâ”€â”€ __init__.py
â”‚Â Â  â”‚Â Â  â”œâ”€â”€ combined_component.py
â”‚Â Â  â”‚Â Â  â””â”€â”€ form_group.py
â”‚Â Â  â”œâ”€â”€ dashboard.py
â”‚Â Â  â””â”€â”€ utils.py
â”œâ”€â”€ requirements.txt
â”œâ”€â”€ start
â”œâ”€â”€ tests
 Â Â  â””â”€â”€ test_employee_events.py
```

### employee_events.db

```mermaid
erDiagram

  employee {
    INTEGER employee_id PK
    TEXT first_name
    TEXT last_name
    INTEGER team_id
    
  }

  employee_events {
    TEXT event_date
    INTEGER employee_id FK
    INTEGER team_id FK
    INTEGER positive_events
    INTEGER negative_events
  }

  notes {
    INTEGER employee_id PK
    INTEGER team_id PK
    TEXT note
    TEXT note_date PK
  }

  team {
    INTEGER team_id PK
    TEXT team_name
    TEXT shift
    TEXT manager_name
  }

  team ||--o{ employee_events : "team_id"
  employee ||--o{ employee_events : "employee_id"
  notes }o--o{ employee_events : ""
```
