Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. a publisher needs to create a database based on th

A publisher needs to create a database based on the following requirements: The publisher publishes different books....

50.1K

Verified Solution

Question

Programming

A publisher needs to create a database based on thefollowing requirements:

The publisher publishes different books. Each book hasan ISBN, name, author(s) name, edition number, category, and price.Each book has a unique ISBN.

The publisher deal with many authors, each has a name,unique number.

For every book, each author will have differentpercentage of revenue.

They also hire editors, who edit books beforepublishing. Each has name, unique number, SSN, salary, bookcategory and list of books they edited.

Draw a complete ER diagram. Write the (min,max),total/partial and the cardinality ratio.

Answer & Explanation Solved by verified expert
4.0 Ratings (473 Votes)
Min CardinalityThe minimum number of occurrence of an entitythat participates in a relationshipMax Cardinality The maximum number of    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Should the National Security Agency be able to spy on average American citizens without their knowledge...

Psychology
Q

i have to plot time and frequency domains and then calculate damping ratio for the underdamped...

Mechanical Engineering
Q

Compounds in the saliva, hair and urine of pets may potentially trigger asthma in some patients....

Basic Math
Q

Discuss the four elements of negligence, and illustrate each element with an example.

Finance
Q

10 Jada is standing 10 feet from the base of tree and spots a nest...

Geometry
Q

Compute the following limit 9x 7 9x 2 lim 818 Select the correct choice below...

Calculus
Q

Let N be the set of natural numbers and two functions fand g be defined...

Algebra
Q

Piedmont Company segments its business into two regionsNorth and South. The company prepared...

Accounting
Q

Differential Chemical produced 13,500 gallons of Preon and 27,000 gallons of Paron. Joint costs incurred...

Accounting
Q

Please show step by step! Thank you! A and...

Accounting
Q

How would you distinguish managerial accounting from financial accounting?

Accounting
Q

Chalupa's work has highlighted the role of: a) Neurotrophic factors in brain development ...

Accounting