Slip 19 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Item (item_no, item_name, quantity) Suppliers (sup_no, sup_name, address, city, phone_no) Relation between Item and Supplier is Many to Many with rate and discount as descriptive attribute. Constraint: Primary key, phone_no must be 10 digits. Consider the above tables and execute the following queries: 1. Display item wise quantity. 2. Display Suppliers whose names are starting with ‘s’ character.
0 Comments