Slip 29 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Country (CId, CName , no_of_states, area, location, population) Citizen( Id, Name, mother_toung, state_name) Relation between Country and Citizen is one to many. Constraint: Primary key, area should not be null. Consider the above tables and execute the following queries: 1. List out country wise number of states. 2. Display the name of country having minimum population.

Solution:

Post a Comment

0 Comments