Answered: పిరరర్

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

100%

Draw the relationships and entities model for each of the following:

* in the traditional way* for example: see the pic??.

In the database of the library, the author can author more than one book, and the book can be subscribed to
Written by more than one author

Expert Solution

Step 1

We are given two entities and we are going to draw ER diagram for it.

Two entities are: Author and Book

Relationship type: many to many

Author can have attributes like name,contact no etc. And Book entity can have attributes like Book id and title etc. These two will have written relationship which shows an author can author more than one book and one book can be written by More than one author,thats why many to many relationship. Please refer image for the ER diagram.