Question

Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Room (roomno, desc, rate)

[15 Marks

Guest (gno, gname, no_of_days) The relationship between Room and Guest is One to One. Constraint: Primary key, no of days should be >0.

Consider the above tables and execute the following queries: 1. Update the rate of room to 5000 whose type is"AC" 2. Display the name of guest who is staying 2 days in roomno 101

please give right answer​

Answer 1

Answer:

Explanation:

Expber industry, fabric and clostry, textile industry, paper rubbbidi industry.er thing indu

Answer 2

Explanation:

Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. [15 Marks]

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:

List out country wise number of states.

Display the name of country having minimum population.