Slip 11 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Bill (billno, day, tableno, total) Menu (dish_no, dish_desc, price) The relationship between Bill and Menu 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 tableno whose dish_desc is “Veg”. 2. Display the special menu of Monday.

Solution:

Post a Comment

0 Comments