tasks/postgres/easy/employees/employee_projects_basic/description.md

Create and manage a basic employee projects table to track company projects. The IT team needs you to build the database table structure and populate it with initial project data.

## Your Tasks:

1. **Create the employee_projects table** — build a new table in the `employees` schema:

   **Table: `employee_projects`**
   * `project_id` (integer, primary key, auto-increment)
   * `project_name` (varchar(100), not null)
   * `start_date` (date, not null)
   * `end_date` (date)
   * `budget` (decimal(10,2))
   * `status` (varchar(20), default 'active')

2. **Insert exactly this initial data into `employee_projects`**:
   * Project 1: name='Database Modernization', start_date='2024-01-15', end_date='2024-06-30', budget=250000.00, status='active'
   * Project 2: name='Employee Portal Upgrade', start_date='2024-02-01', end_date='2024-05-15', budget=180000.00, status='active'
   * Project 3: name='HR Analytics Dashboard', start_date='2023-11-01', end_date='2024-01-31', budget=120000.00, status='active'

This will establish the basic project tracking foundation for the company.