Create a series of ER Diagrams using MySQL Workbench. The database will store data about patients receiving drugs in a clinical trial.

This is version 1. Patients have the following attributes: patient_id, first name, last name, DOB and gender. Drugs simply have a name. Patients can receive >1 drug. Hint: Your design should have two tables.

This will be version 2 of the database. Modify your design to include the following requirements: Drugs have the following attributes: drug_id, drug_name, and manufacturer_name. Patients can receive >1 drug. Each drug is administered to >1 patient. Hint: This is an example of a many-to-many relationship. Review the readings to resolve this issue.

This will be version 3 of the database. Modify your design to include the following requirements: For each drug administration, also store drug-dosage and date. Hint: This does not require additional tables; the question is where to add these new attributes.