Question

Q1 Consider the following entities and their relationships. Create a RDB in 3NF with appropriate
data types and constraints.
[15 marks]
Country(Cid,CName,no_of_states,area,location,population)
Citizen(ID,Name,mother_tongue,state_name)
Relation between Country and Citizen is one to many.
Constraint : Primary key , area should not be Null.
Q2. Consider the above table and execute the following queries
1.List out country wise number of states.
2.Display the name of the name of the country having maximum population.
3.Display the name of the countries in descending order.
4.Display the name of the countries with population > 1000000.
5.Drop the column area from Country table .

Answer 1

Explanation:

Q1 Consider the following entities and their relationships. Create a RDB in 3NF with appropriate

data types and constraints.

[15 marks]

Country(Cid,CName,no_of_states,area,location,population)

Citizen(ID,Name,mother_tongue,state_name)

Relation between Country and Citizen is one to many.

Constraint : Primary key , area should not be Null.

Q2. Consider the above table and execute the following queries

1.List out country wise number of states.

2.Display the name of the name of the country having maximum population.

3.Display the name of the countries in descending order.

4.Display the name of the countries with population > 1000000.

5.Drop the column area from Country table .