Draw ER Diagram

ER D$$agram:

Designer

DesignerID $($PK$)$

Name

Email

PhoneNumber

StreetNumber

StreetName

City

State

ZipCode

Model

ModelCode $($PK$)$

ModelName

Colors

Price

Vacuum

SerialNumber $($PX$)$

DateOfManufacture

ModelCode $($FX$)$

Technician

TechnicianID $($PK$)$

Name

Age

DateEmployed

ContactNumber$1$

ContactNumber$2$

StreetNumber

StreetName

City

State

ZipCode

SupervisorID $($FK$)-($self$-$referential$)$

Inspection

InspectionID $($PK$)$

SerialNumber $($FK$)$

TechnicianID $($FK$)$

DateOfinspection

QualityStatus

Relationships:

Designer$-$Model: Many$-$to$-$many.

Model$-$Vacuum: One$-$to$-$many.

Vacuum$-$Inspection: One$-$to$-$many.

Technician$-$Inspection: One$-$to$-$many.

Technician$-$Supervisor: One$-$to$-$many $($self$-$referential$).$