Slip 30 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Library(Lno, Lname, Location, Librarian, no_of_books) Book(Bid, Bname, Author_Name, Price, publication) Relation between Library and Book is one to many. Constraint: Primary key, Price should not be null. Consider the above tables and execute the following queries: 1. Display library details having number of books greater than 10000. 2. Display the list of books of ‘BPB’ publication.

Solution:

Post a Comment

0 Comments