Slip 17 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Politicians (pno, pname, telephone_no) Party (party_code, party_name) Relation between Politicians and Party is Many to One. Constraint: Primary key, party_name should not be null. Consider the above tables and execute the following queries: 1. Display the name of party whose politician is “Mr. Patil”. 2. Update party name of politician whose name is “Mr.Pawar”.

Solution:

Post a Comment

0 Comments