Design the Relational Schema for the E-R diagram you drew for Question 1. The relations must be at least in 3NF. Perform the following operations on the relations:
a) Enter about five sets of meaningful data in each of the relation.
b) Specify the domain of various attributes.
c) Specify the Primary key of every relation.
d) Specify the Foreign keys and referential integrity constraints in the relations.

Answer the following queries using SQL for the database created in Question 2.
(i) List the title of the Book whose ISBN number is 978-9332582705
(ii) List the members whose membership is due for renew.
(iii) Find the list of books with multiple copies in the library.
(iv) List all the books that have been issued to the member having the member ID “A123”
(v) List the names of the members whose return of the book is overdue by one week.
(vi) Find the member who has got the maximum number of books issued.
(vii) List the names of the members who were issued the book having ISBN number
978-9332582705.
(viii) List the members who were not issued even a single book.
(ix) List the Book details and number of copies of each of these books.
(x) Calculate the total number of books issued in the last month.
Note: Make suitable assumptions, if any.

Explain the process of development of a database system for an organisation

Design an ER diagram for a Library book management system. The library has many books. The library keeps several copies of important books. Each book is identified by a unique identification number. In addition, the library records the ISBN number, title of the book, names of the authors of the book, publisher’s name, and year of publication for the books. The books can be issued to members. A member pays Rs 1000 for yearly membership. Membership is renewed every year. A member can be issued a maximum of 5 books. Identify and list the entities, attributes, relationships, cardinality, keys and constraints. Make and state suitable assumptions.