Click here to Skip to main content
14,697,572 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
Draw an ER diagram for multiple copies of the same book with unique book .

What I have tried:

can i try this with weak entity? as i take book as strong entity and copy as weak entity and i have no idea what can i give attribute of weak entity. the attribute of book is ISBN no.(primary key),price,edition,year,title,pages.and next what can i do?
Updated 12-Sep-20 7:07am

1 solution

The parent is the ISBN / Title; the children are the physical books for that ISBN.

The parent says nothing about condition, price, location / owner; the children do.

The parent may contain (original) author, first pub date, ... attributes not specific for a particular copy.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900