Given the data requirements, design an Entity-Relationship diagram for the following statements. Show all entities along
Posted: Tue May 24, 2022 8:32 am
Given the data requirements, design an
Entity-Relationship diagram for the following statements. Show all
entities along with minimum and maximum cardinalities. State any
necessary assumption, if
required.
Note: You can upload the ERD image that can be
either drawn by hand or online using any tool. Make sure to upload
the image within the quiz duration. No extra time will be given to
upload the image.
Scenario:
A city Library needs an information system to maintain the
information on their books, members and transactions efficiently.
Some of the database requirements are as follow:
· Information
stored about books include unique ID, title, ISBN, publication
year, author and publisher.
· A book might
have many copies and a copy belongs to exactly one book. Each copy
of a book is uniquely identified by copy ID and book ID.
· A book is
written by one or many authors. An author is characterized by
author ID name and date of birth.
Entity-Relationship diagram for the following statements. Show all
entities along with minimum and maximum cardinalities. State any
necessary assumption, if
required.
Note: You can upload the ERD image that can be
either drawn by hand or online using any tool. Make sure to upload
the image within the quiz duration. No extra time will be given to
upload the image.
Scenario:
A city Library needs an information system to maintain the
information on their books, members and transactions efficiently.
Some of the database requirements are as follow:
· Information
stored about books include unique ID, title, ISBN, publication
year, author and publisher.
· A book might
have many copies and a copy belongs to exactly one book. Each copy
of a book is uniquely identified by copy ID and book ID.
· A book is
written by one or many authors. An author is characterized by
author ID name and date of birth.