Q$2.$ a You are asked to design a database for recording information about magazines,

their writers, and subscribers, for a publication house. The information

requirements include:

For each magazine, its name, its writers, its editor, and the cities to which it

is delivered.

For each writer, their name. $($Note: a writer can write for more than one

magazine, but can only edit, at most, one magazine.$)$

For each subscriber, their name, favorite writers, city of residence, and what

magazines they receive.

Draw an ER diagram for the above requirements.

b After you have finished your design, you are then asked to incorporate a new

information requirement that keeps record of a relationship Researched$-$by among

two writers and a magazine. The intention is that this relationship set consists of

triples

$($writer$1,$ writer$2,$ magazine$)$

such that writerl wrote for the magazine at a time when some other writer $2$

was the magazine's editor.

i$.$ Draw the modification to the $\frac{E}{R}$ diagram.

ii$.$ Replace your ternary relationship with a new entity set and binary

relationships.