- Using the MySQL Workbench, implement each solution into a ERD model

- Export each of the ERDs into a .pdf file

Problem #2 Fish Magazine

Fish Folks, a magazine for fish enthusiasts, wants to keep track of its journalists, photographers, articles, and photos.

An article is authored by one journalist (who is identified by an id, and also has a name, date of birth, and year started in the profession). An article has a unique id, a date, a title, and a length. An article doesnt always have photos within it, but it may also have multiple. A photo has a unique id, a date taken, and a subtext. A photo is taken by a photographer, and information to track about each photographer includes his/her unique id, name, and expertise. Although not frequent, it is possible for a given photo to be used in many different articles.

Create the conceptual ERD in workbench to accurately represent the above situation.