Architect

idnameemail
1John Smithjohnsmith@example.com
2Jane Doejanedoe@example.com
3Mike Johnsonmikejohnson@example.com
4Emily Davisemilydavis@example.com
5David Browndavidbrown@example.com

Firm

idnameaddress
1ABC Construction123 Main St, Anytown, USA
2XYZ Builders456 Elm St, Anycity, USA
3PQR Contractors789 Oak St, Anothertown, USA

Building

idbuilding_namefirm_idarchitect_id
(→ Firm.id)(→ Architect.id)
1Highrise Tower11
2Residential Complex22
3Office Building33
4School Building14
5Hospital25

Project

idproject_namebuilding_idstart_dateend_date
(→ Building.id)
1Tower Foundation12022-01-012022-03-31
2Complex Framework22022-02-012022-04-30
3Office Interior32022-03-012022-05-31
4School Renovation12022-04-012022-06-30
5Hospital Expansion22022-05-012022-07-31

Material

idmaterial_typecost
1Concrete100.0
2Steel200.0
3Glass150.0
4Wood50.0
5Bricks75.0

Employee

idemployee_namepositionfirm_id
(→ Firm.id)
1Tom WilliamsProject Manager1
2Susan ThompsonArchitect2
3Chris JonesSuperintendent3
4Lisa BrownEngineer1
5Mark TaylorElectrician2