## Style

style_id | style_name
--- | ---
1 | Modern
2 | Contemporary
3 | Traditional
4 | Rustic
5 | Minimalist

## Interior_Designer

designer_id | name | design_style
--- | --- | ---
|  | (→ Style.style_id)
1 | John Doe | 1
2 | Jane Smith | 2
3 | Michael Johnson | 3
4 | Emily Davis | 4
5 | David Brown | 5

## Landscape_Architect

architect_id | name | landscape_style
--- | --- | ---
|  | (→ Style.style_id)
1 | Mark Williams | 1
2 | Laura Wilson | 2
3 | Thomas Jackson | 3
4 | Nicholas Taylor | 4
5 | William Martin | 5

## Project

project_id | title | start_date | end_date | interior_designer_id | landscape_architect_id
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Interior_Designer.designer_id) | (→ Landscape_Architect.architect_id)
1 | Living Room Redesign | 2021-07-01 | 2021-09-01 | 1 | 1
2 | Kitchen Remodel | 2021-08-01 | 2021-10-01 | 2 | 2
3 | Bathroom Renovation | 2021-06-01 | 2021-08-01 | 3 | 3
4 | Garden Design | 2021-05-01 | 2021-07-01 | 4 | 4
5 | Office Space Makeover | 2021-04-01 | 2021-06-01 | 5 | 5

## Material

material_id | name | description
--- | --- | ---
1 | Wood | High quality hardwood
2 | Stone | Variety of natural stones
3 | Glass | Tempered and laminated glass
4 | Metal | Stainless steel and brass
5 | Textile | Cotton, silk, and wool fabrics

## ProjectMaterial

projectmaterial_id | project_id | material_id | quantity
--- | --- | --- | ---
| (→ Project.project_id) | (→ Material.material_id) |
1 | 1 | 1 | 50
2 | 1 | 2 | 25
3 | 1 | 3 | 10
4 | 1 | 4 | 20
5 | 1 | 5 | 30