Question: Q1: 25 Points Create an ER diagram based on the following requirements. Show entities, relationships, and attributes. Science Magazines is a publishing company that keeps
Q1: 25 Points Create an ER diagram based on the following requirements. Show entities, relationships, and attributes. Science Magazines is a publishing company that keeps track of: - For each magazine it publishes: unique magid, unique magname, average weekly circulation (magavgwcirc). - For each writer: unique wid, wname (composed of wfname and wlname), date of joining the company (wdatestarted), number of years writer has been working for the company (wyrsworking), one or more writer spoken languages (wslanguage), writers contact phone (wphone) - not every writer has a contact phone because some of the writers are very private and reserved and are never to be disturbed. - For each printing facility: pflocation, unique pfid. Additional requirements: - Each magazine is printed at one printing facility. Each printing facility prints at least one magazine but can print more than one. - A writer writes for at least one magazine, but can write for up to three magazines. Each magazine has multiple writers writing for it. We keep track of the date when a writer started writing for a magazine. - Each magazine has one writer who is its editor-in-chief. A writer can be an editor-in-chief for only one magazine but does not have to be an editor-in- chief for any magazine.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
