Slip 9 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Property (pno, desc, area, rate) Owner (owner_name, addr, phno) The relationship between owner and Property is One to Many. Constraint: Primary key, rate should be > 0 Consider the above tables and execute the following queries: 1. Display area of property whose rate is less than 100000. 2. Give the details of owner whose property is at “Pune” .

Solution:



Post a Comment

0 Comments