Question
Draw an Entity Relationship Diagram (ERD) for thefollowing case study: Management Book Association (MBA) is engaged in a wide range of publishing, marketing and distribution
Draw an Entity Relationship Diagram (ERD) for thefollowing case study: Management Book Association (MBA) is engaged in a wide range of publishing, marketing and distribution activities in Singapore. These are in the areas of educational textbooks, children's books, general and trade books, academic and scholarly publications, reference materials and some electronic publications. MBA also collaborates with the local universitys professors to conduct industry seminars and workshops for professionals. MBA wishes to produce course books on the various seminars and workshops that it now conducts. The books are written by professors who specialises in one particular subject. Two or more professors may specialise in a particular subject. MBA employs professional editors who may not be a specialist in a particular area. Each editor may edit one or more books at a time. A professor may write more than one book at a time. When writing a particular book, the professor works with one editor. If the professor is working on a second book at the same time, he has to work with another editor on the second book.
please indicate primary key and foreign key as well many thanks!!
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