Consider the following database Room (room_no,room_name,room_type,charges)

Consider the following database
Room (room_no,room_name,room_type,charges)
Guest(Guest_code, Gname,city)
The relationship is as follows: Room-Guest: one-to-one. room_type can have values as either AC or
NonAC.
Q 2) A Create the above database in PostGreSQL and insert sufficient records.