Draw an ER & Normalized ER Diagram for a Vacuum Manufacturing Company which has the following specifications.

The manufacturer wants to keep track of all the information about the vacuums that the Company manufactures.

To begin with, each vacuum has a unique serial number and date of manufacture.

Different models of vacuums are created in the Company. Every Vacuum created falls in to one of these models. So$,$ the manufacturer also wants to keep track of the model details. Each vacuum has a model name, model code, different colors, and price.

The company often manufactures thousands of vacuums of a certain model, and these models are designed by the Designer.

The information about the designer who designed the vacuum models is also stored in the database which includes the designer's name, contact information $($which includes an email id$,$ phone number & address along with street number, street name, city, state $8$ : zip code$).$ A designer can design any number of vacuums & a vacuum can be designed by several designers.

Each Vacuum is rigorously inspected by the Technicians before it is shipped to the Customers. These Technicians are identified by their employee number $($ID$)$ & also have other information like Name, Age & Date

employed, two contact numbers &$.$ Address. Each vacuum is inspected by only ane Technician.

For each inspection, the company records the date of Inspection and the Quality Status which should be either Pass, Fail or In progress.

Some of the Technicians also have supervisory responsibilities in addition to their inspection role. These Supervisors would have multiple other technicians report to them