IGNOU BCS 111 2026 2027 - Design a simple database for a Library Management System. Identify:

Question

Design a simple database for a Library Management System. Identify:
 Tables
 Fields
 Primary Keys
 Relationships

08 Aug 2026

Answer :

Word Count : 431

A Library Management System database is designed to store and manage information about books, members, authors, publishers, and the issue and return of books. A simple relational database can be created using tables connected through primary and foreign keys. The main tables required are Books, Authors, Members, Publishers, and Issue_Return. The Books table stores information about every book available in the library. Its fields can include Book_ID, Book_Title, Author_ID, Publisher_ID, ISBN, Category, Publication_Year, and Quantity. The Book_ID is the primary key because it uniquely identifies each book. Author_ID and Publisher_ID are foreign keys that connect the Books table with the Authors and Publishers tables. The Authors table contains information about the authors of books. Its fields can include Author_ID, Author_Name, Address, and Contact_No. Author_ID is the primary key. One author may write several books, so a one-to-many relationship can exist between Authors and Books. The Publishers table

__________ _______ _________ ___ __________ ____ ___ ________.
____ ____ ______ ____ ________ __________ _______ __________ _______.
____ ____ _______ ___ _____ _________ ____ _______.
_________ ____ _______ __________ ______ ______ _______ _________.
___ ___ _________ ____ ______ _____.
______ ___ _________ ________ _______ _______ ___.
___ _________ ______ _______ _________ __________.
_________ ___ _____ _____ ________ ___ ________ _________ ___ ________ _________.
__________ ______ ___ ______ _____ __________ ___ ____ ____ ______ ___ ________.
_________ ___ ___ ____ ____ __________ ________ __________ _____ ______ _________ ___.
_____ _______ _________ ____ ____ _______ ____ ___ _________.
_________ _______ _____ _____ _________.
_______ _______ _________ _________ ______.
_____ _____ ___ _____ _________ _______ ____ ______ ______.
______ _________ ___ ____ _________ ____ _____ ___.
____ ________ _____ _________ ______ _______ ____ _______ ___ ______ ____ _____.
____ _____ ____ _______ ___ _________ ____ ______ _________.
______ _____ ___ ________ _____ __________ __________.
___ _______ _______ ________ ______ _________ _________ ______.
____ _____ ___ _______ ______ _______ ________ __________ __________ _______ ______.
___ _______ ___ ______ ________ _____.
____ ________ __________ _____ ________ _______ _____ ___ __________.
_____ ________ __________ _______ ____ ________.
_______ ____ ________ ____ ____ _____ _________.
_______ ____ ____ _______ _______ _______ ___ _______ _____ ____.
_____ ______ ______ ______ ________ _______.
______ _________ __________ _______ _______ ___ _______ ______ ____.
______ ______ __________ __________ ____ _______ _____ _______ _______ _______ _________.
_____ _______ ___ _____ _______ ______ _____ ________.
______ ________ __________ ______ _______ ___ _________ ________ _____.
_____ ______ _________ ______ _______ __________ __________ __________ _______ __________ ________.
___ _______ ___ ________ ___ ___ _______.
_____ _______ _______ ___ _______ ______.
________ ___ _______ ____ ______ __________.
______ _____ _____.

IGNOU ACADEMY

Your IGNOU journey, made easier.

Solved Assignments
Study Notes
Guess Papers
Question Papers

Call Us WhatsApp

STUDY • PREPARE • SUCCEED

Skip in 10