The purpose of this assignment is to promote students analytical skills in analyzing a case scenario and utilizing the given information and resources to design an ER diagram and write SQL script.
Case Scenario:
XYZ Pulishing Company produces scientific books on various subjects. They need a database to maintain information about their authors, editors and books. The author information would include the name of the suthor, their phone# and email address, and the subject area that they specialze in. each author only specializes in one subject. Those subjects may include Biology, Physiscs, Geology, etc. Each author may be working with more than one editor at any given in time. Each author may have written many books. The editor information would include the name of the editor, their phone# and email address, the book that they are editing, and the authors they are working with. Each editor may be working with more than one author at any given time. Each editor may be editing many books at any given time.
The book information would include the title of the book, ISBN number, and the subject area that the book covers. Each book has only one author but may have many editors. Some of the goals that XYZ wants to accomplish with their database include the following information:
- Name of the authors and the name of the editors.
- Books that have been published for a particular subject area.
- Editor that have worked on books for a particular subject.