Question: 2. When you are asked to build a database for the Goodwood, a scientific publishing company, there are some requirements they have given to you

2.

When you are asked to build a database for the Goodwood, a scientific publishing company, there are some requirements they have given to you as the following: - An author may write many publications. A publication may also be written by many authors. - There are many types of publications. One publication cannot be categorized into more than one type. - The publication will need to be categorized into different subjects, such as: science & technology, medical science & public health, business & management, etc - Each author has his/her own specialty subject. - An editor or a group of editors will be assigned to work on editing a publication. They can also work on editing other publications too at the same time. The editors will work together with the authors of the publications. - There is also a publishing staff which can manage the publications.

Please draw a complete ER Diagram for the scientific publishing company database. Please also specify the cardinality in the relationship.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!