Slip 15 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. [15 Marks] Plan (plan_no, plan_name, nooffreecalls, freecalltime, fix_amt) Customer (cust_no, cust_name, mobile_no) Relation between Plan and Customer is One to Many. Constraint: Primary key, fix_amt should be greater than 0. Consider the above tables and execute the following queries: 1. Display the details of plan who has taken by “Mr. Patil”. 2. Update the mobile No of customer to 7020079536 whose name is “Mr Roy” and plan is “Go Max”.

Solution:

Post a Comment

0 Comments