Question

Q3. Consider the following entities and their relationships. Create a RDB in 3 NF with
appropriate data types and Constraints.
[15 Marks
Country (Cld, 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.​

Answer 1

Explanation:

wah bete moj kar di tum toh Sher nikale