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

Finance
1.2K views

How does the Fed pursue its economic goals? How may the tools of monetary policy affect...

Physics
1.2K views

OO hem is first calculated assum point like charges a ing them t th Two...

Geometry
1.2K views

10 The volume of the right rectangular prism is V 270 cm Write a quadratic...

Basic Math
1.2K views

You measure 25 dogs' weights, and find they have a mean weight of 41 ounces....

Calculus
1.2K views

A cylindrical can has a volume of 1024? cm. What dimensions yield the minimum surface...

Calculus
1.2K views

An unfilled vacuum capacitor has a capacitance of 5 70mF It is then filled with...

Algebra
1.2K views

Plot the product of the complex numbers on the plane below.(2e^315'i) (2e^210i)

Accounting
1.2K views

PREGUNTA 1 Cul de las siguientes afirmaciones es correcta con respecto al mtodo de...

Accounting
1.2K views

Determine the price of a $1.5 million bond issue under each of the following independent...

Accounting
1.2K views

Bridgeport Corporation wished to raise money for a series of upcoming projects. On July 1,...

Accounting
1.2K views

Tami Tyler opened Tami's Creations, Incorporated, a small manufacturing company, at the beginning of the...

Finance
1.2K views

a. What is the total open interest on the June 2019 Australian dollar contract? b....