Draw the Entity Relationships (ER) diagram and also design the relatio

Question

Draw the Entity Relationships (ER) diagram and also design the relational database schema for the following activity: (20) The IGNOU book club has members. The book club sells books to its members. The member places orders for books, which the book club fulfills. Each order contains one or more than one book. The books are written by author(s). The publisher publishes the book. An author can write more than one book and a book can have more than one author. A book is published by a publisher, but a publisher publishes many books. A member can place more than one order. He/She also can choose not to place an order. The book club sells many books.

16 Apr 2024

Answer :

Word Count : 1088

To address the activity of designing an Entity Relationship (ER) diagram and the relational database schema for the described scenario involving the IGNOU book club, we need to carefully analyze the requirements and identify the key entities, relationships, and attributes. Below is a detailed step-by-step explanation, including the ER diagram and relational schema.

### Step 1: Identifying Entities and Relationships

Based on the provided information, we can identify the following entities:

1. Member – The person who is part of the book club and may place orders.
2. Book – A book that is sold to the members.
3. Order – The transaction placed by a member to purchase one or more books.
4. Author – The writer(s) of the books.
5. Publisher – The organization or entity that publishes books.

### Step 2: Defining Attributes for Each Entity

Now, let’s define the attributes for each entity:

1. Member
- MemberID (Primary Key)
- Name
- Address
- Email
- Phone Number

2. Book
- BookID (Primary Key)
- Title
- ISBN (International Standard Book Number)
- Price
- Publication Year

3. Order
- OrderID (Primary Key)
- OrderDate
______ _____ ______ __________ __________ __________ ______ ______ _______ _________.
_______ _____ ________ __________ _________ ________.
______ _______ _____ __________ _____ ___.
_______ _______ ___ ________ ________ ______.
_________ ____ ___ _____ _______ ______ ________.
_______ ____ ____ ______ _________ _______ ______ ______ _____.
____ _________ ___ ____ _____.
_________ ____ ________ ____ ___ _________ ________ ________ __________ _____ ______.
________ ____ ________ _______ _____ ______ ____ _____ _________ ____ ____ __________.
_________ ________ ______ _____ __________ _______ ____ _____ _____ __________ __________.
________ ____ ___ _________ ______ ________.
__________ _________ ___ ________ _____ __________.
_______ _______ __________ _______ ________.
_____ _________ _______ ______ __________ ____ _________ ____ _________ _________.
_________ ___ ______ _________ __________.
_________ ________ _______ ___ ________ _____ _______.
__________ ____ _____ _____ ____ ___ ________ ____ ____ _________ ___ _________.
_____ ___ _____ ____ _______ _______ _________ ______ ________ ____ ___ ________.
_________ _________ ___ _______ ______ _______ ________ _________ _________ _______ _____.
_______ ______ ________ ________ _________ ______ _________ _______.
________ ________ ___ _____ __________ _________ ______ __________ __________.
__________ _________ ___ ______ _____.
__________ _____ ______ _____ _______ ________ __________ __________ _________.
__________ _______ __________ ____ ______.
______ ____ _______ _________ __________ ______ ______.
______ ________ ______ _________ ______ _____ ___.
_____ ____ _________ __________ ___ ___ ____ __________ __________ _______ ________ _________.
_______ ________ _______ ______ _____ ______ _______.
___ _____ _________ __________ _________ ______ ________.
___ ________ ______ ____ ________ ______ _______ _____ ____ _________ _________.
_______ __________ ___ _____ ______ ______ _____ ___ ___ __________.
_________ __________ ____ ________ __________ _______ ____ __________.
______ ___ ________ _______ ________ _______ _______ _________ ________.
___ ____ ______ _________ ____ ____ ________ _________ ___ ________ ___.
____ _________ __________ ________ _______ __________ ___.
________ _____ ___ _______ _____ ____ _________ _______ ________ _________ ____ ______.
________ ____ _________ _____ _______ _____ ___.
________ _____ __________ ____ ___ _______ ________ _______ ______ _________ ____ _________.
____ ___ __________ ______ ________ ______ ________.
____ _________ _____ ______ __________ ________.
__________ ____ _____ _______ _________.
_______ _______ ________ ______ _____ _____ __________ ___.
________ _______ ______ __________ _______ _________ __________ _____.
___ ________ _________ _________ __________ __________ ________.
________ ___ ___ _________ ___ ___ _________ ______ ___ ________ ________.
________ ______ _____ __________ ___.
________ ____ __________ ________ _____ ___ __________ __________ ____ ________.
______ ______ ______ ____ ____ ___ _______ ____.
______ ________ _____ ______ _____ ______ _____ __________.
_________ ___ ________ ___ ____ _________ __________ ________ ___ ______.
_______ __________ ________ ______ ____ _____ _________ ___ ______.
______ ___ _____ ________ _____ _____ _____ _______.
___ ____ ____ ______ __________ ______ ___ ____ _______ _______ __________.
________ ________ ___ _____ ____ _____ ______ _________ ________ __________.
_____ _______ ___ ___ _________ _____ ____ ______.
_______ ______ _______ _____ ________ ___ __________ ___ ______.
_____ _____ _________ ________ _____ __________ ____.
________ __________ ___ ______ _______ ____.
_______ ____ ___ _________ ___.
___ __________ ______ _________ ___ ____ _____ _________.
____ ___ _____ ________ _____ ____ ___ _____.
_____ ______ ______ ______ ___.
___ _________ ___ _____ ______.
__________ _________ ______ _________ ________ ____ __________ _______ ____ ____.
____ ___ ___ ____ ___ ________ _________ ________.
_________ __________ ___ ________ ___ _________ _____ _______ ______ ________.
______ _______ ____ _____ _______ _________ ________ _____ ____ ___.
_______ _______ ____ ________ ____ _________ _______ ____ ______.
____ ____ ___ _______ _________ _________ __________ ________.
________ ________ _____ ________ _______ _____ __________ ___ ____.
_______ __________ _______ _________ _________ ______.
_______ _____ __________ ______ ___.
______ ______ __________ _______ ____ ___ ____ ________.
_____ ______ _______ ______ _____ _________ ___ ___ _____ __________ _______ ____.
_________ ______ ______ ___ ____ ________ ____ _________ __________ __________.
________ _________ ___ _________ _______ ___ ________ ________ ___ ___ __________ ___.
________ _______ _________ _________ ___ _________ ___ _____ ______ ___.
___ _____ _________ ___ ______.
________ _________ __________ ______ ___ ______ ______ ____ _______ __________ ________.
______ ___ ____ _____ _______ __________ ______ _______ _______ ____ ___.
__________ ________ ________ ____ _______ ______ ________ ___.
________ _________ _________ _____ _________ ___ ____ _____ ________ _____ ________ _____.
_____ __________ ___ ______ ______.
_________ ________ _________ _____ _________ ________ _____ ________ ____ ___.
______ ____ _________ _______ ______ __________ _______ _________.
____ ____ __________ _______ ___ ____ ________ __________.
_____ _____ _____ __________ ________ ________ ___ ____ __________ ___.
_______ __________ _____ ____ __________ ____ _________ __________ ______.
______ __________ ____ ___ _________ _________ __________ ______.
_________ ___ _________ _________ ______ ______.
_______ ____ __________ _____ ______ _________ ____ ___.
____ ______ ____ ____ ____ _______ __________ ________ ____ ______ __________.
_____ _____ _______ __________ ________ _______ __________ _____ _______ ____ ____.
_____ ____ _______ __________ ____ _______ _____.
______ ______ _____ _________ _____ ____ ___ ______ __________.
_________ ___ ________ ________ _________ __________ ___ ______ __________ ______.
_____ ______ ___ __________ ____ ___.
_____ _____ _______ ________ _______ ______ ________ _________.
___ ______ ____ _________ _______ _________.
_________ _________ ____ ____ _______ __________.
_____ _________ _____ _________ ____ ___ ___.
___ ________ ______ _________ ______ _____ ___ ___.
________ __________ __________ _________ ______ ___ _________ ____ ____ ______ _________ _________.
___ _____ ______ _________ ____ _________.
Get Full Answer on WhatsApp

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★