Q1. Book club consists of members to whom the books are sold. The books are made available at different places in the city. The books are recognized by a book_id, the author and the publisher. The author can write more than one book and a book can encompass more than one author. Members encompass information like Memership_id, Name, Phone# and Status. The member can place more than one order. You can select additional attributes for the schema which seem suitable. Illustrate any supposition you make.
Show minimum and maximum cardinality ratios based on your suppositions.
a) Design an E-R schema diagram for this application.
b) Map the E-R diagram to relational model.
Q2. Explain how does SQL implement the entity integrity and referential integrity constraints of the relational data model? Describe with an illustration.
Q3. Illustrate the meaning of the view in SQL? Describe giving an appropriate illustration, when:
a) View with single defining table.
b) Views defined on the multiple tables by using joins.
c) Views defined by using grouping, is/are updatable.
Q4. Illustrate the meaning of JOIN? Describe different JOIN operations in the Relational Algebra with illustration.