Slip 20 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Wholesaler (w_no, w_name, address, city) Product (product_no, product_name, rate) Relation between Wholesaler and Product is Many to Many with quantity as descriptive attribute. Constraint: Primary key, rate should be > 0. Consider the above tables and execute the following queries: 1. Update product_name to “Monitor” whose supplier is “Mr. Patil”. 2. Display product wise rate.

Solution:

Post a Comment

0 Comments