MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE w1742302_device (
  deviceCatalogID varchar(5),
  deviceCatalogName varchar(20),
  deviceDescription varchar(300),
  availabilityStatus boolean,
  CONSTRAINT pk_device_catalogID PRIMARY KEY (deviceCatalogID)
);

CREATE TABLE w1742302_hearing_Device (
  deviceCatalogID varchar(5),
  hdMake varchar(20),
  hdModel varchar(20),
  CONSTRAINT pk_hearingDevice_catalogID PRIMARY KEY (deviceCatalogID),
  CONSTRAINT fk_hearingDevice_catalogID  FOREIGN KEY (deviceCatalogID) REFERENCES w1742302_device(deviceCatalogID)
);
CREATE TABLE w1742302_visual_Device (
  deviceCatalogID varchar(5),
  frBrand varchar(20),
  frModel varchar(20),
  lensSerialN varchar(20),
  lensVisionType varchar(20),
  lensTint set('1','2','3'),
  lensThinnessLevel set('1','2','3'),
  CONSTRAINT pk_visionDevice_catalogID PRIMARY KEY (deviceCatalogID),
  CONSTRAINT fk_visionDevice_catalogID  FOREIGN KEY (deviceCatalogID) REFERENCES w1742302_device(deviceCatalogID)
);