-- DISEASES -- No changes. GROUPERS -- 1.4.1) Delete all duplicate tuples using all attributes in the GROUP BY clause. -- Hint: Week 7, slide 31 (5 points). -- 1.4.2) Add a primary key constraint using grouper id and disease id. Hint: ALTER TABLE hw3.groupers ADD CONSTRAINT groupers_pk... (2 points). -- 1.4.3) Remove all grouper entries that are not associated with an existing disease type. -- Hint: disease_id NOT IN (sub-query) (5 points). -- 1.4.4) Add a foreign key constraint for disease id (3 points). -- MEDICATION_TYPES -- 1.5) Set medication name to 'NOT NULL' (2 points). -- MEDICATIONS -- 1.6.1) Set encounter id, medication id, and patient id to 'NOT NULL' (5 points). -- 1.6.2) Create foreign key references for encounters and patients (5 points)