E-R Diagram for Library Management System ERD Example Book_id Title Author Pub_ID Address Price Books Published by Publisher Available Due date Brrowe by Return date Expiry_date Name Member Name Address Memb_type Memb_id Issue Memb_date 13
Added by Christopher F.
Close
Step 1
Entities: The main entities in this system would be Books, Publisher, Member, and Issue. Show more…
Show all steps
Your feedback will help us improve your experience
Liliane Martins and 61 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Akash M.
Given the E-R diagram on the following page, list the names of the entities, attributes, keys, and relationships being used. 2. For each entity, give a formal written description, including all of its attributes and its key. 3. For each relationship, give a formal written description of both directions of the relationship, including its cardinality.
Consider the following EER diagram. Map it to the relational model. Specify the relational schema in DBDL notation.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD