Slip 8 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Book (Book_no, title, author, price, year_published) Customer (cid, cname, addr) Relation between Book and Customer is Many to Many with quantity as descriptive attribute. Constraint: Primary key, price should be >0. Consider the above tables and execute the following queries: 1. Display the name of book whose author is “Mr. Gadhave”. 2. Add column EMailId into customer table.
0 Comments