Question

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


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.​

Answer 1

Explanation:

setting jjkjhghkmnkkllbb