Style

style_idstyle_name
1Modern
2Contemporary
3Traditional
4Rustic
5Minimalist

Interior_Designer

designer_idnamedesign_style
(→ Style.style_id)
1John Doe1
2Jane Smith2
3Michael Johnson3
4Emily Davis4
5David Brown5

Landscape_Architect

architect_idnamelandscape_style
(→ Style.style_id)
1Mark Williams1
2Laura Wilson2
3Thomas Jackson3
4Nicholas Taylor4
5William Martin5

Project

project_idtitlestart_dateend_dateinterior_designer_idlandscape_architect_id
(→ Interior_Designer.designer_id)(→ Landscape_Architect.architect_id)
1Living Room Redesign2021-07-012021-09-0111
2Kitchen Remodel2021-08-012021-10-0122
3Bathroom Renovation2021-06-012021-08-0133
4Garden Design2021-05-012021-07-0144
5Office Space Makeover2021-04-012021-06-0155

Material

material_idnamedescription
1WoodHigh quality hardwood
2StoneVariety of natural stones
3GlassTempered and laminated glass
4MetalStainless steel and brass
5TextileCotton, silk, and wool fabrics

ProjectMaterial

projectmaterial_idproject_idmaterial_idquantity
(→ Project.project_id)(→ Material.material_id)
11150
21225
31310
41420
51530