## Architect

id | name | email
--- | --- | ---
1 | John Smith | johnsmith@example.com
2 | Jane Doe | janedoe@example.com
3 | Mike Johnson | mikejohnson@example.com
4 | Emily Davis | emilydavis@example.com
5 | David Brown | davidbrown@example.com

## Firm

id | name | address
--- | --- | ---
1 | ABC Construction | 123 Main St, Anytown, USA
2 | XYZ Builders | 456 Elm St, Anycity, USA
3 | PQR Contractors | 789 Oak St, Anothertown, USA

## Building

id | building_name | firm_id | architect_id
--- | --- | --- | ---
|  | (→ Firm.id) | (→ Architect.id)
1 | Highrise Tower | 1 | 1
2 | Residential Complex | 2 | 2
3 | Office Building | 3 | 3
4 | School Building | 1 | 4
5 | Hospital | 2 | 5

## Project

id | project_name | building_id | start_date | end_date
--- | --- | --- | --- | ---
|  | (→ Building.id) |  |
1 | Tower Foundation | 1 | 2022-01-01 | 2022-03-31
2 | Complex Framework | 2 | 2022-02-01 | 2022-04-30
3 | Office Interior | 3 | 2022-03-01 | 2022-05-31
4 | School Renovation | 1 | 2022-04-01 | 2022-06-30
5 | Hospital Expansion | 2 | 2022-05-01 | 2022-07-31

## Material

id | material_type | cost
--- | --- | ---
1 | Concrete | 100.0
2 | Steel | 200.0
3 | Glass | 150.0
4 | Wood | 50.0
5 | Bricks | 75.0

## Employee

id | employee_name | position | firm_id
--- | --- | --- | ---
|  |  | (→ Firm.id)
1 | Tom Williams | Project Manager | 1
2 | Susan Thompson | Architect | 2
3 | Chris Jones | Superintendent | 3
4 | Lisa Brown | Engineer | 1
5 | Mark Taylor | Electrician | 2