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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started